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 support@optmyzr.com.