Spreadsheet Widget

Use the widget to import information into your report using a spreadsheet with your data

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

This widget is currently available in the Pro and Enterprise plans. To enable this widget for your account, please write to us at support@optmyzr.com.

Can’t find what you’re looking for?

Our award-winning customer care team is here for you.