Send form submissions to Google Sheets
You can send form submissions to Google Sheets without Zapier: connect your Google account to SagePigeon once, paste a spreadsheet's URL into a form's settings, and each new submission is added as a row. The columns keep their places as the form changes, and the sync tells you when it stops instead of failing quietly. It works on every SagePigeon plan, including Free.
What the sheet looks like
On an empty sheet, SagePigeon writes the header for you. Three columns come first, then one per field:
| Submitted at | Form | Submission ID | Name | Message | |
|---|---|---|---|---|---|
| 2026-10-28T08:02:51.000Z | Website contact form | 7a0e… | Tomás Ortega | tomas@example.com | Do you deliver to Leeds? |
| 2026-10-28T09:40:13.000Z | Website contact form | 1c94… | Grace Liu | grace@example.com | Can I change my booking date? |
Headings are made from your field names, so phone_number becomes "Phone number". The time is in UTC. Values are written exactly as submitted, so Sheets will not turn a phone number into a sum or a product code into a date.
Set it up
You connect Google once for the whole workspace, then choose a sheet per form. Connecting needs an owner or admin.
- Create the spreadsheet in Google Sheets. An empty one is fine.
- In SagePigeon, open Settings in the sidebar, then Integrations. Under Google Sheets, press Connect Google and allow access in the window Google opens.
- Open the form, go to its Settings tab, then Integrations, and scroll to Google Sheets.
- Paste the spreadsheet's address from your browser into Spreadsheet. The long id in the middle of the URL also works on its own.
- Type the tab's name into Tab, or leave it blank for the first tab.
- Press Start syncing.
SagePigeon opens the spreadsheet as soon as you press the button. If the address is wrong, or the connected account cannot edit the sheet, you find out there and then, with one of three messages: the spreadsheet does not exist or this account cannot open it, the account cannot edit it, or there is no tab with that name. A typo shows up now, and not three weeks later when somebody asks where the leads went.
Send a test from the form's Setup tab with Send a test submission, and the first row appears.
How the columns behave when your form changes
A spreadsheet sync tends to break months after set-up, when somebody adds a field to the form.
SagePigeon reads the sheet's first row before every new row. If the submission has a field that is not in the header yet, the field is added as a new column at the right-hand end. Existing columns never move, so rows from last spring stay under the right headings and the formulas or filters you built still point at the right letters.
If you rearrange the columns yourself, SagePigeon follows your order, because row 1 is read fresh each time. You can also delete a column you never want, but it will come back if a later submission still sends that field.
One safety rule applies to every value. A visitor could type =IMPORTXML(…) or +SUM(…) into your form, hoping it runs when someone opens the sheet. SagePigeon writes any value that starts with =, + or @ with a leading apostrophe, so Sheets shows it as text and never runs it.
When something breaks
Most failures are passing ones. Google times out, or answers with a server error, and the next try works. SagePigeon tries the row again after 30 seconds, 2 minutes, 10 minutes and 15 minutes, and only the row. The email notification is not sent twice, and a submission is never written to the sheet twice. If all 5 attempts fail, the form's Health tab counts it under "Not accepted on delivery".
Three failures will never fix themselves. The Google access was revoked, the spreadsheet was deleted, or the connected account lost edit rights. When SagePigeon hits one of these, it does not retry. It switches off syncing on that form and writes the reason into the submission's delivery log. Fix the cause, then press Start syncing again on the form. Submissions that arrived while it was off are not added afterwards; they are all in SagePigeon's Inbox.
Disconnecting Google from the workspace's Integrations page stops syncing on every form at once. Rows already written stay where they are, and connecting again carries on from the next submission.
Sheets without a middleman
You could do all of this with Zapier: a form trigger, a Sheets action, a Zap per form. That route earns its keep when you need to change the data on the way, such as splitting a full name, looking up a postcode, or writing to three sheets depending on an answer.
For a straight copy of each submission into a sheet, a direct sync is simpler. There is no per-task bill, no extra account holding your submissions, and nothing to rebuild when you add a field. If you later need the extra steps, webhooks are available on Pro, and Make or n8n can subscribe to the same submissions.
When a sheet stops being enough
A spreadsheet is a good list. It is a poor to-do list. Once two or more people work through the leads, a sheet cannot tell you who has replied to whom, and colour-coding rows by hand stops being reliable the first busy week.
That is the job of SagePigeon's Inbox, which every submission reaches whether or not you sync a sheet. Each request sits on a clock until someone replies, and you can see who has taken it on. Use the sheet for reporting and the Inbox for answering. Contact form leads lost in a shared inbox explains how the clock works.
Plans
Google Sheets sync is on Free, Pro and Scale; the Free plan lists it next to Slack. Free covers 500 submissions a month and 3 forms. Exporting older submissions as CSV needs Pro or Scale. The Google Sheets integration page has the full details and limits.
Questions people ask
Do I need Zapier to send form submissions to Google Sheets?
No. SagePigeon writes to Google Sheets directly with your Google account's permission, on every plan including Free.
Will my existing submissions be copied into the sheet?
No. Syncing starts with the next submission. On Pro and Scale you can export older submissions as CSV and paste them in.
Can two forms write to the same sheet?
Yes. Point both at the same spreadsheet and tab. The Form column tells their rows apart, and a field only one form has gets its own column.
What can SagePigeon see in my Google account?
The permission covers Google Sheets, not the rest of your Drive. SagePigeon reads and writes only the spreadsheet you name on each form.