Set up write-back to Google Sheets
To save changes from this dashboard directly to your spreadsheet, deploy a small Google Apps Script as a web app. It takes about 3 minutes.
1 Open your spreadsheet → Extensions → Apps Script
2 Replace all code with the snippet below, then click Save
3 Click Deploy → New deployment → Web app. Set "Who has access" to Anyone. Copy the URL.
4 Paste the URL here: