All Collections
Reports
How To
Add a Google Sheets table widget to a report
Add a Google Sheets table widget to a report

In the Widget sidebar, click Google Sheets, then drag and drop the Table option onto your report page.

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

How to add a Google Sheets table widget to a report

Once you've connected the Google Sheets integration, you can import any Sheet from your Google Drive account into a table widget within our reports.

Navigate to the report section where you'd like to embed a Google Sheet. If the widget Sidebar is not visible on the right side, expand it by clicking the gray line on the far right of your report editor.

Then, find "Google Sheets" under the Integrations tab.

Next, click the Table icon, then drag and drop the table widget onto your report page.

Your table widget will then be added to the report page section. To format the widget, click the widget, then in the Widget sidebar, select the Spreadsheet you'd like the widget to display. You can also specify a spreadsheet tab, if needed.
โ€‹

Note: The Google Sheet that you're importing should 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 can also be imported, and can cause the report to "hang".

What's Next

Did this answer your question?