Google Sheets
Connect a FormDB form to Google Sheets so each new submission is added as a row in a spreadsheet that FormDB creates for that form.
This page shows how to connect a form to Google Sheets. Once connected, every new submission is added as a new row in a spreadsheet that FormDB creates for the form.
Paid plans: Integrations are available on Starter, Growth and Business.
Connect
You need the admin or owner role.
- Open the form and go to the Integrations tab.
- In the Google Sheets card, click Connect.
- Sign in to Google and approve the request.
- You return to FormDB and see the message "Google Sheets connected".
Finish the Google step within 10 minutes, signed in to FormDB with the same account. Otherwise the connection link expires and you need to click Connect again.
The integration is switched on as soon as you connect. Click Open spreadsheet in the card to see the new sheet.
What FormDB can access
FormDB asks Google for access only to the files it creates or opens itself. It cannot see the rest of your Google Drive.
The spreadsheet
On connect, FormDB creates a new spreadsheet in your Google Drive, named after your form. It has one tab called Submissions with a bold, frozen header row:
Column | Content |
|---|---|
| The date and time of the submission, in ISO format (UTC) |
| The submission's ID |
One column per builder field | Named with the field's name, for example |
FormDB always creates a new spreadsheet. You cannot choose an existing spreadsheet or a different tab.
How rows are written
- Each new submission adds one row at the bottom.
- If a submission contains a field that has no column yet, FormDB adds a new column for it at the end of the header row. You do not need to define fields in advance.
- Fields with several values, such as checkboxes, are written as one cell separated by commas.
- File fields contain download links, one per line. These links expire after 7 days. To get a file later, open the submission in FormDB. See File uploads.
- Values are written as plain text. A submitted value that looks like a formula is not run as one.
Only new submissions are sent. Submissions that arrived before you connected are not added. To get older data, use Export CSV and import the file into your sheet.
Spam-flagged submissions are not sent to the sheet.
Editing the spreadsheet
You can format the sheet, reorder rows, add your own columns and add other tabs. Two things to avoid:
- Do not rename the header cells FormDB created. Columns are matched by their exact header text. If you rename
emailtoEmail address, FormDB adds a newemailcolumn and writes there. - Do not rename or delete the
Submissionstab. FormDB finds the tab by that name.
If you want friendlier headings, add a second tab that references the first one.
Pause, test and disconnect
- Pause: use the switch at the top of the card. While paused, new submissions are not sent to the sheet, and they are not added later when you switch it back on.
- Send latest submission: writes the form's most recent submission to the sheet again as a test. The form needs at least one submission.
- Disconnect: removes the integration and revokes FormDB's access to your Google account. The spreadsheet and the rows already in it stay in your Drive.
If you disconnect and connect again, FormDB creates a new spreadsheet.
When a row does not appear
Check the Recent deliveries card at the bottom of the Integrations tab. Each submission has a row with its status.
- Retrying: a temporary problem. FormDB tries up to 6 times over about 15 minutes.
- Failed: hover over the status to see the reason.
If the reason is "Google access expired. Reconnect Google Sheets.", click Disconnect, then Connect again. Reconnecting creates a new spreadsheet, so copy any rows you need from the old one.
A failed delivery never affects the submission itself. It remains in your FormDB inbox.
Next steps
- Webhooks: retries and the delivery log in detail.
- Airtable: send submissions to an Airtable table.
- Submissions inbox: export older submissions as CSV.
Ready to try it? Create a free account and send your first submission.