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 the type of widget you want to display.
Your widget will then be added to the report page section.
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".
Add a blank page to a report (Scroll down to the "Adding a text box to a blank report section" section)