Google Sheets Integration

Google Sheets is a destination in Formboost, alongside Slack, Discord and Telegram. Connect it once and every submission is appended to a spreadsheet as a new row.

Formboost creates the spreadsheet for you. There is nothing to make first and no URL to paste — you sign in with Google, choose a name, and Formboost makes the sheet and links it from the dashboard.

Google Sheets is available on the Starter plan and above.

Setup

1. In Formboost, open your form → Integrations tab → Google Sheets → Connect
2. Press Connect Google account
3. Pick the Google account the spreadsheet should live in
4. Approve the permission Google asks for
5. You land back in Formboost, which asks you to name your spreadsheet — a name is suggested, so press Create spreadsheet to accept it or type your own
6. Submit your form once; the first row appears within a few seconds

You can rename the spreadsheet in Google Drive afterwards at any time. Formboost tracks it by ID, so renaming never breaks delivery.

If you untick the Drive permission

Google's consent screen shows the permission as a checkbox you can clear while still pressing Continue. If you do, Formboost cannot create anything, so the connection is rejected outright — the access is handed straight back to Google, nothing is saved, and you return to Formboost with a message asking you to try again with the box ticked.

You will not reach the naming step in that case. If a spreadsheet name was ever asked for, the permission was granted.

If you close the naming step

The connection is saved before you are asked for a name, so closing that dialog does not lose your Google sign-in — but no spreadsheet exists yet and nothing is delivered. The integration shows Setup incomplete with a Finish setup button that reopens the naming step exactly where you left it.

Connecting a second form

Once you have connected Google to one form, connecting another offers your existing account in a dropdown. Choosing it skips the Google sign-in entirely and goes straight to naming the new sheet. Each form gets its own spreadsheet.

What the sheet looks like

The first two columns are always the same, and the rest are your form's fields in the order Formboost first saw them:

Values are written exactly as submitted. A field holding structured data is written as JSON in its cell.

New form fields become new columns

If a submission arrives carrying a field the sheet has no column for — because you added an input to your form — Formboost adds the column and then writes the row. You do not have to reconnect anything or edit the sheet yourself.

Rows submitted before the field existed keep an empty cell in that column, which is the honest answer: those submissions genuinely did not carry that value.

Renaming a field in your form is treated as a new field, because that is all Formboost can see from the submission. You get a new column beside the old one. If you want them merged, rename the column in the sheet to match before the next submission arrives.

What Formboost can and cannot see

Formboost asks Google for one narrow permission: access to files this app created. That is the whole grant.

• ✅ It can write to the spreadsheets it made for your forms
• ❌ It cannot read, edit or list anything else in your Google Drive
• ❌ It cannot open a spreadsheet you made yourself, even if you share it

This is why Formboost creates the sheet rather than letting you point it at an existing one — asking for access to your own files would mean asking for your entire Drive, and that is a far larger permission than sending form submissions justifies.

You can revoke the access at any time from your Google account permissions. Doing so stops delivery to every form using that account; the integration will show as needing reconnection.

Editing the sheet

The spreadsheet is yours — it lives in your Drive, under your account. Move it, rename it, share it, add tabs, and build charts and formulas off it freely.

Two things to leave alone on the Submissions tab:

• Row 1 is the header row. Formboost reads it to work out which column each field goes in. Renaming a header re-points that column; deleting one makes Formboost re-add it on the next submission.
• Do not sort or delete rows while expecting them to stay put — new rows are always appended to the bottom, so a sort is a snapshot rather than a permanent arrangement.

Adding your own columns to the right is safe. Formboost only writes to the columns named in the header row and leaves everything else untouched.

Delivery and failures

Deliveries are logged like every other destination — open Log on the integration row to see what was written and when.

Common failures and what they mean:

A failed delivery never loses the submission. It is always stored in Formboost and visible in the Submissions tab, whatever the sheet does.

Disconnecting

Disconnecting removes the integration and its delivery history from Formboost. Your spreadsheet is not deleted — it stays in your Drive with everything written to it so far.

If no other form is still using that Google account, Formboost also revokes its own access on the way out, so nothing is left holding a permission it no longer needs.