Google Sheets Integration
Automatically sync form submissions to a Google spreadsheet
Static Forms has a built-in Google Sheets integration. Connect your Google account and every form submission is automatically appended as a new row in a spreadsheet — no Zapier, no Apps Script, no code.
Pro Feature
Google Sheets integration is available on the Pro plan. Upgrade to Pro to unlock this feature.
How It Works
- A dedicated spreadsheet is created in your Google Drive when you connect.
- Form field names become column headers automatically on the first submission.
- New form fields are added as new columns — existing data stays aligned.
- Each submission adds a row with submitted_at and submission_id meta-columns plus all form data.
- Errors are recorded and visible in the integration card — they never block the form submission itself.
Setup
Open Integrations
Navigate to Settings → (select your account) → Integrations.
Connect Google Sheets
Click Connect Google Sheets. You will be redirected to Google to authorize access. We request drive.file and email scopes only — drive.file limits access to files created by Static Forms and does not grant access to your existing Drive content.
Verify the spreadsheet
After authorization, a new spreadsheet titled StaticForms — (your account name) appears in your Google Drive. Click Open spreadsheet in the integration card to verify.
Send a test row
Click Send test row to confirm the connection works end-to-end.
Managing the Integration
Enable / Disable
Toggle the sync switch to pause or resume row delivery without disconnecting. Your spreadsheet and data stay intact.
Change the sheet tab
By default, rows go to the Submissions tab. You can change this in the integration card — the tab must already exist in the spreadsheet.
Disconnect
Click Disconnect to revoke access. Your spreadsheet remains in Google Drive; only the connection to Static Forms is removed.
Per-Account Connections
Each account has its own Google Sheets connection. This means you can connect different Google accounts (or the same account) to different forms, each with its own spreadsheet.
Troubleshooting
Last error displayed
If a submission fails to sync, the error message and timestamp appear in the integration card. Common causes:
- Token expired / revoked — Disconnect and reconnect.
- Spreadsheet deleted — Disconnect and reconnect to create a new one.
- Sheet tab renamed or deleted — Update the tab name in the integration card, or recreate the tab in the spreadsheet.
Missing columns
Columns are added dynamically. If a new form field appears after the first submission, it gets appended as a new column. Earlier rows will have blank cells for that column.