How to configure a Google Sheets stat widget in a report

Once you've connected the Google Sheets integration and added a Google Sheets stat widget, you'll need to configure the widget according to your reporting needs.

To start, hover your mouse over that widget and click the ellipsis ("...") icon in the upper right corner.

In the Edit Widget popup, select the sheet you'd like to display from the dropdown. You can also give your widget a title, and choose the cell of the sheet you'd like to display. For example, entering "A1" into the Cell area will display everything entered into cell A1 of the sheet. Click "Save Widget" once you're done.

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". 

What's Next

Did this answer your question?