All Collections
Reports
How To
Configure a Google Sheets table widget in a report
Configure a Google Sheets table widget in a report

Hover over the widget, click the ellipsis ("...") at the top right, and apply your customization options

Matthew Davis avatar
Written by Matthew Davis
Updated over a week ago

How to configure a Google Sheets table widget in a report

Once you've connected the Google Sheets integration and added a Google Sheets table widget, you'll need to configure the widget according to your reporting needs.

To format the table widget, click the widget; this will turn the Widget sidebar on the right of the screen into the Edit Widget sidebar. Here you can format the title, spreadsheet, sort order, and more.

Title

Add a title for this widget which will show up at the top of the widget.
โ€‹

Date Column

You can take advantage of the Google Sheet widget's full date range capabilities by setting a date column. This means that when you change the date range in the platform, the data in those widgets will also change.


Table Row Limit

Choose how many rows to display for this widget

Date

If you're taking advantage of the widget's date range capabilities, you have the option to have the widget follow the report's date range or select a specific date range for this widget instead.

Spreadsheet

Select which sheet from your Google Sheets account to use for this widget.

Spreadsheet Tab

Select which tab in the Google Sheet to use for this widget.

Show Table Header

This toggles between showing or hiding the first row of your sheet as a header for this widget.


Wrap Text

This toggles between showing the entire sheet or allowing you to specify the exact height. Selecting "Yes" for Dynamic Height will allow you to adjust the widget's height (cropping the table) while selecting "No" will show the entire sheet.

Once you've configured your widget's settings, click Save Settings.


โ€‹Note: The Google Sheet that you're importing MUST be formatted to remove any empty rows or columns. If you leave the thousands of empty rows/columns that exist by default in a Google Sheet, those empty rows/columns will also be imported, and will cause the report to "hang".ย 

What's Next

Did this answer your question?