All Collections
Reports
How To
Import data from Google Sheets to a report
Import data from Google Sheets to a report

Import a custom spreadsheet and embed it into any automated report

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

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 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, 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. 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?