DatumForms.
Join the panel Sign in Create a survey

DATUMFORMS DOCUMENTATION

Connect Google Sheets and refresh a survey export

Keep an authorized spreadsheet connected to your survey data.

For researchers and administrators

Updated 15 November 2026

On this page

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

  1. Open the survey’s Google Sheets connection or export control and follow the Google authorization flow for the intended account.
  2. Confirm the destination spreadsheet and check that it belongs to the intended project.
  3. Request a refresh using the available export control, or call sheets.refresh from an integration with sheets:write.
  4. Read sheets.status with sheets:read to inspect refresh_pending, revision and spreadsheet_id.
  5. 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.

Next steps

Use Apps Script.

Need help with this task? Contact DatumForms. Include the article URL and the step you reached.

Tracking preferences

Essential functions stay on. Choose whether to allow optional tracking on this website. You can change your choices in the footer at any time.

Read our privacy policy