How to import data from Google Sheets

Once you've connected the Google Sheets integration, you can then import any Sheet from your Google Drive account into our automated reports.

To start, open either a new or existing report for editing. Google Sheets can be embedded into any page, but the most common use case is with our "Blank Page" option.

Navigate to the page where you'd like to embed a Google Sheet, and click the "Add Item To Report" button:

Click "Add Widget".

Go to Misc --> Google Sheets, and choose either a Stat Widget (which displays a single cell from the sheet), or a Table Widget (which displays an entire sheet).

Your widget will then be added to the report page section.

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?