The Spreadsheet widget allows you to pull data from a Google spreadsheet and include it as a table in your report.
To start using this widget, you need to set the sharing settings of the spreadsheet first. You need to use at least "anyone with a link" to enable our system to pull the data.
After copy/pasting the spreadsheet URL, click on 'Fetch headers and choose.' This will show a list of the columns from the spreadsheet. You can then choose the columns that you want to include in the table.
If you have the widget in a scheduled report, it will refresh the data before sending the report via email
To enable this widget for your account, please write to us at email@example.com.