Form to Google Sheets — every submission appended as a new row
Connect your form to a Google Sheet in 30 seconds. New submissions append in real time, columns auto-map by field name, no Apps Script required.
Google Sheets
- ✓30-second OAuth setup — no Apps Script, no copy-pasting webhook URLs into formulas
- ✓Auto column mapping by field name with manual override and field hiding
- ✓System columns toggle (timestamp, IP, country, user agent, source URL) with one click
Google Sheets in splitforms, shipped to production.
Connect your form to a Google Sheet in 30 seconds. New submissions append in real time, columns auto-map by field name, no Apps Script required.
splitforms connects any HTML form to a Google Sheet without Apps Script, without copy-pasting webhook URLs into your spreadsheet, and without paying $20/month for a glue tool that polls every 5 minutes. In the dashboard, click Integrations → Google Sheets, sign in with your Google account, pick a spreadsheet and worksheet, and confirm the column mapping. From that moment on, every form submission appends a new row in real time (typically under one second from submit). Column mapping happens automatically by matching form field names to sheet headers — case-insensitive, with spaces collapsed, so 'full_name' maps to 'Full Name' without any configuration. You can override any mapping by hand, hide internal fields like access_key from the sheet, and toggle on system columns to auto-append submission_id, submitted_at (UTC), ip, country, user_agent, and source URL. If you rename a column header in the sheet, the integration adapts on the next submission; if you delete a column, splitforms warns you in the dashboard so you can re-map. Conditional rules let you write only some submissions to the sheet — for example, 'only append rows where source = careers' — useful when one form serves multiple downstream destinations. The OAuth scope is sheet-specific (Google Drive's drive.file scope), so splitforms can only see the spreadsheet you pick, never your whole Drive. Disconnecting takes one click, removes splitforms' Google access, and leaves all existing rows untouched. Google Sheets is the easiest way to share leads with non-technical teammates without giving them dashboard access.
google-sheets.html · live preview
Three steps. From zero to a working production setup.
How google sheets actually flows through splitforms — what you do, what we do, and what lands in your inbox.
Open Integrations → Google Sheets in the dashboard
Sign in with the Google account that owns the destination spreadsheet. splitforms uses the drive.file OAuth scope, which means it can only read and write the specific sheet you pick — it cannot see, list, or modify any other file in your Drive.
Pick the spreadsheet and confirm column mapping
Choose your sheet and worksheet. splitforms auto-maps form field names to sheet headers (case-insensitive, spaces collapsed); override any mapping, skip fields you don't want in the sheet, or toggle on system columns to auto-append submission_id, submitted_at (UTC ISO 8601), ip, country, user_agent, and source URL.
Submit a test — watch the row appear in real time
Hit Submit on your form. Within ~1 second a new row appears at the bottom of the sheet. Every subsequent submission appends in real time, so non-technical teammates can sort, filter, and pivot leads straight from the spreadsheet — and you can pipe that sheet into Looker, Geckoboard, or Notion.
Why teams pick splitforms for google sheets.
Five reasons this is the boring, reliable choice — every one shipped by default on every plan, including free.
30-second OAuth setup — no Apps Script, no copy-pasting webhook URLs into formulas
Auto column mapping by field name with manual override and field hiding
System columns toggle (timestamp, IP, country, user agent, source URL) with one click
Real-time append — new row appears within ~1 second of submit, not 5-minute polling
Scoped Drive access (drive.file) — splitforms only sees the sheet you pick
Multi-worksheet routing — pipe different submissions to different sheet tabs by field value with conditional rules
Drop this into any project.
Replace YOUR_ACCESS_KEY with the key from your splitforms dashboard. No SDK install. No package to npm i. The same html you already know.
Things developers ask before they integrate.
Direct answers, no marketing fluff. Missing one? Email hello@splitforms.com.
Start using google sheets today.
Create your form, grab your access key, and ship it in five minutes. Free for 1,000 submissions per month, forever.
