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".
- How to connect the Google Sheets integration
- Add a blank page to a report (Scroll down to the "Adding a text box to a blank report section" section)
- Add a Google Sheets widget to a client marketing dashboard
- Add custom text, images, and more to any report page