How to configure a Google Sheets stat widget
Ensure that your dashboard is in "Edit Dashboard" mode, then click the "gear" icon on the widget that you just added.
First, select the Google Sheet from your Google Drive account that you'd like to use with the widget.
Then, select the cell from that sheet for which you'd like to pull in data.
Finally, configure any additional options, such as widget title, color, and theme. Click "Save Settings" and then click the "Save" button to save your dashboard.