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 "Widgets" tab on the left hand menu.
Then, find "Google Sheets" under the Integrations tab.
Then, choose the type of widget you want to display and drag the widget onto the section.
Your widget will then be added to the report page section. You will be prompted to select the spreadsheet you'd like to use for the widget and other widget settings that you can set.
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)