Google Sheets live sync
Automatically push every new response to a Google Spreadsheet as it comes in.
Google Sheets Live Sync pushes every new form submission to a Google Spreadsheet in real time. Your team can view, analyze, and share data in a familiar spreadsheet interface without any manual export.
Connecting a Google Sheet
- 1Open the form in the builder and go to the Connect tab.
- 2Click "Connect" on the Google Sheets card and sign in with your Google account.
- 3That's it — no further setup is required. By default, Spiceform automatically creates a new spreadsheet named after your form when the first response arrives.
Exporting to an existing spreadsheet
Prefer to keep responses in a spreadsheet you already have? After connecting, open the settings (gear icon) on the Google Sheets card, click "Choose spreadsheet" and pick any spreadsheet from your Google Drive. Spiceform adds a "Form Responses" tab with column headers to it (your existing tabs and data are never touched), and the card shows which spreadsheet responses are exporting to.
How syncing works
- •New submissions are appended as rows to the "Form Responses" tab within seconds of being submitted.
- •The first column is the submission timestamp; the remaining column headers are generated from your question titles.
- •Existing rows are never modified — each submission is a new row.
- •Answers are written as readable text: file uploads and signatures appear as download links, and fields with multiple parts (like Contact Info or Address) are broken down into labeled lines.
- •By default, only completed submissions are synced — partial (abandoned) submissions are not exported.
Partial submissions
If you also want responses from people who started your form but never finished, open the settings (gear icon) on the Google Sheets card and turn on "Sync partial submissions" — a submission left unfinished for one hour is exported automatically and marked accordingly, and each one is exported once. When this is on, every row gets a "Status" column marking it as Completed or Partial, so you can filter them apart in your sheet.
Syncing your response history
When you first connect, your existing completed responses are synced to the spreadsheet automatically (once). The "Response history" section in the card's settings has two manual buttons: "Sync completed" exports your past completed responses again, and "Sync all (incl. partial)" does the same but mixes in past partial submissions too. Note that re-syncing to a sheet that already contains your history will duplicate those rows.
Disconnecting and reconnecting
Your chosen spreadsheet is remembered. If you disconnect and later reconnect (or if Google ever invalidates the authorization — we'll email you if that happens), responses resume exporting to the same spreadsheet rather than creating a new one, and your history is not re-synced (no duplicate rows).
Combine Google Sheets sync with Google Data Studio (Looker Studio) to build real-time dashboards from your form data.
Note: responses received after you exceed your plan's monthly response limit are not delivered to integrations until the limit resets or you upgrade.
Was this article helpful?