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.
Add a title for this widget which will show up at the top of the widget.
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
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.
Select which sheet from your Google Sheets account to use for this widget.
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.
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".