Google Sheets form integration
SagePigeon appends each website form submission as a new row in a Google Sheet you own. The sheet keeps its shape as your form changes: a new field becomes a new column on the right, and rows from last year stay under the right headings. It is available on every plan, including Free.
What the sheet looks like
The first row is written for you when the sheet is empty. It starts with three fixed columns and then one column per field, in the order the first submission sent them:
| Submitted at | Form | Submission ID | Name | Message | |
|---|---|---|---|---|---|
| 2026-10-11T09:14:22.000Z | Website contact form | 5f1c2e6a-… | Priya Raman | priya@example.com | Could you cater a weekday lunch for 40? |
Column names come from field names: phone_number becomes "Phone number". "Submitted at" is the UTC time SagePigeon received the submission.
A few rules keep the sheet trustworthy:
- New fields go on the right. Add a "Budget" field in six months and SagePigeon adds a Budget column at the end. Nothing already there moves.
- Your own header order wins. SagePigeon reads row 1 before every append, so if you drag columns around, new rows follow your order.
- Answers never run as formulas. A value starting with
=,+or@is written with a leading apostrophe, so a visitor cannot plant a formula in your spreadsheet. - Values are written as typed. SagePigeon writes raw text, so Sheets does not reformat a phone number or a date.
Set it up
Connecting Google is done once for the workspace by an owner or admin. Choosing the sheet is done on each form.
- Open Settings in the sidebar, then Integrations. Under Google Sheets, press Connect Google and approve access in the Google window.
- Open the form you want to sync, go to its Settings tab, then Integrations, and find Google Sheets.
- Paste the spreadsheet's URL from your browser into Spreadsheet (the id alone also works).
- Type the tab name into Tab, or leave it empty to use the first tab.
- Press Start syncing. SagePigeon opens the spreadsheet straight away and tells you if it cannot, so a typo shows up now and not at the next submission.
The next submission adds a row. Send one from the Setup tab with Send a test submission to see it.
Plans
Google Sheets sync works on Free, Pro and Scale. Free includes 500 submissions a month, 3 forms and Slack alerts alongside the sheet. See pricing.
Limits and gotchas
- SagePigeon asks for spreadsheets access only, never your whole Drive. Revoking it in your Google account stops the sync.
- It writes as the person who connected. That Google account must be able to edit the spreadsheet. If it cannot, saving fails with "The connected Google account cannot edit that spreadsheet".
- Lasting problems switch the sync off and say why. If the access is revoked, the spreadsheet is deleted, or the account loses edit rights, SagePigeon turns off syncing on that form and records the reason in the submission's delivery log. Fix the cause and press Start syncing again.
- Passing problems are retried. If Google refuses a row for any other reason, or times out, SagePigeon tries again after 30 seconds, 2 minutes, 10 minutes and 15 minutes. Only the row is retried, so the email is not sent twice and a row that went in is never written again. If all 5 attempts fail, the form's Health tab counts it under "Not accepted on delivery".
- Disconnecting Google stops every form. Rows already written stay in the spreadsheets, and connecting again picks up from the next submission. Missed submissions are not back-filled.
- New rows only. Turning sync on does not copy older submissions into the sheet. On Pro and Scale, use the CSV export for those.
- Spam stays out of the sheet. Submissions caught by the honeypot or a captcha wait in SagePigeon's Spam list for seven days. Release one and it is delivered like any other submission, row included.
Related
- Send form submissions to Google Sheets: the walkthrough, and when a sheet stops being enough.
- Sheets and hooks in the docs
- All integrations