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 start, hover your mouse over the widget in question and click the "Gear" icon in the upper right corner.
In the Edit Widget popup, select the sheet you'd like to display from the dropdown. You can also configure the Dynamic Height, which 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. Click Save Widget once you're finished.
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".