Google Sheets

Automatically sync every form submission to a Google Spreadsheet in real time.

Requires Pro plan or higher.


Setup overview

There are two steps:

  1. Connect Google — done once in Settings, authorizes forms.wtf to access your Google Sheets

  2. Enable per form — each form can sync to its own spreadsheet


Step 1 — Connect your Google account

  1. Go to Settings → Integrations

  2. Click Connect Google Sheets

  3. Sign in with your Google account and grant access

  4. You'll be redirected back to Settings with Google connected

This is a one-time step. All your forms can use Google Sheets after this.


Step 2 — Enable sync for a form

  1. Open the form builder for the form you want to sync

  2. Click Settings

  3. Scroll to Google Sheets

  4. Toggle Sync to Google Sheets on

  5. Either:

    • Create a new spreadsheet — forms.wtf creates one named after your form

    • Select existing — paste a spreadsheet URL or ID

  6. Optionally set a custom sheet name (tab name within the spreadsheet)

  7. Save


How the sync works

Every time someone submits your form:

  1. forms.wtf writes a new row to your spreadsheet

  2. The first row (headers) is automatically updated to match your current question set

  3. Responses appear within seconds of submission

The sync runs in the background — it does not slow down or block form submission.


Spreadsheet structure

Row 1 (headers):

Each subsequent row:

  • Questions appear in the same order as in your form

  • Columns stay in sync with your form — if you add, rename, or remove questions, headers update automatically

  • Only "input" questions appear as columns (Welcome Screen, End Screen, and Statement are excluded)

  • Skipped optional questions → empty cell (no column shift)


File uploads in Sheets

For File Upload questions, the cell contains a link:

Clicking this link:

  1. Checks if you're logged in to forms.wtf

  2. If yes → generates a signed download URL and redirects to the file

  3. If not → redirects to login, then to the file

This keeps uploaded files private while making them accessible from Sheets.


Disconnecting

To disable sync for a specific form:

  • Go to Form Settings → Google Sheets and toggle it off

To disconnect Google entirely:

  • Go to Settings → Integrations → Disconnect Google

  • This disables sync for all your forms


Troubleshooting

New submissions aren't appearing in my sheet

  • Verify Google is still connected in Settings

  • Check that the spreadsheet still exists and hasn't been deleted

  • Ensure you haven't revoked forms.wtf's access in your Google account settings

Headers are wrong

  • Headers are re-synced on every submission. Submit a test response to trigger a re-sync.

I see a #REF error in Sheets

  • This can happen if you manually deleted a column that forms.wtf is trying to write. Delete the header row and let forms.wtf rebuild it on the next submission.

Last updated

Was this helpful?