Send responses to Google Sheets
Connect a form to a spreadsheet once and every response becomes a new row, with the columns mapped the way you want.
Updated 3 November 2026
Connect a form to a spreadsheet once and Onlyform appends a row every time somebody submits. The row is there by the time the respondent sees the thank-you screen; nothing is queued for later and nothing needs exporting.
Set it up
- In the form you want to connect, open the Integrations tab and pick Google Sheets.
- Sign in with Google and choose the Drive the spreadsheet lives in. Onlyform only sees the sheets in the account you authorise.
- Point at an existing spreadsheet, or let Onlyform create one named after the form. Existing responses are backfilled the moment you connect.
- Map the columns: confirm which field writes to which column, add the metadata you want alongside (response id, timestamp, device) and switch the connection on.
You only come back here if you add a question and want it in a particular column.
Good to know
- Every row carries the response id and an ISO timestamp, so the sheet stays sortable and auditable.
- If Sheets is unavailable the delivery retries for 24 hours and every attempt shows in the delivery log on the form.
- Timestamps use the workspace timezone, not the respondent's.
Quick answers
Frequently asked questions
Rows are missing or not syncing
Check the connection is still authorised, then open the delivery log on the form: every attempt and its response is listed there. Google caps a spreadsheet at 10 million cells; past that new rows are rejected and the log will say so.
I cannot see the spreadsheet I want
Onlyform only lists sheets in the Google account you authorised. Reconnect with the account that owns the sheet, or share the sheet with that account first.
How do I disconnect without deleting the sheet?
Switch the connection off in the Integrations tab. The spreadsheet and every row already written stay exactly where they are.