How to add a Google Sheets stat widget in a report
Once you've connected the Google Sheets integration, you can import any Sheet from your Google Drive account into a stat widget within our reports.
Navigate to the report section where you'd like to add a Google Sheet stat widget. 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, click the Stat icon, then drag and drop the Stat object onto your report page.
From the general tab, you can add a name to your widget. To format further, click on the stat widget on your report, then in the Widget sidebar, select the Data tab. Next, choose the Spreadsheet you'd like the widget to display. You can also specify a spreadsheet tab, if needed.
These settings will then be applied to the Google Sheets stat widget in the report. Make sure to save the report, after making any alterations to your widgets.