Before you start
You need administrator access and permission to authorize the intended Google account. Use the product’s existing connection flow and verify the selected spreadsheet.
Open: Your project → Results → Google Sheets.
Steps
- Open the survey’s Google Sheets connection or export control and follow the Google authorization flow for the intended account.
- Confirm the destination spreadsheet and check that it belongs to the intended project.
- Request a refresh using the available export control, or call sheets.refresh from an integration with sheets:write.
- Read sheets.status with sheets:read to inspect refresh_pending, revision and spreadsheet_id.
- Open the spreadsheet and check a known submitted response and the expected headers after processing finishes.
Check the result
The connected spreadsheet reflects the completed export revision. A queued refresh is distinct from a completed refresh.
Troubleshooting
If refresh reports no connection, reconnect the intended Google account in the project. A response that queued work does not prove the worker finished; check pending status and the destination sheet.