Integration Overview
The Google Sheets integration adds each form submission to a spreadsheet as a new row. You can then sort, filter, and share your leads or responses with anyone on your team.
You do not need Google Apps Script, Google Forms, or a server. You sign in with Google once, pick a sheet, and FormBold handles the rest.
It works with any form that posts to your FormBold endpoint, including plain HTML forms, static sites, and apps built with Next.js, React, Vue, or Angular.
⚡ Connecting Google Sheet with Your Forms (Video)
What You Get
- Column headers from your form: FormBold creates headers that match the name attribute of each input, such as name, email, and message.
- A timestamp on every row: Each entry records when it was submitted.
- New rows in under 2 seconds: Submissions reach your sheet shortly after the visitor clicks submit.
- New or existing sheet: Let FormBold create a spreadsheet for you, or send data to one you already use.
How It Works
- A visitor submits your form.
- FormBold runs its spam checks and allowed-domain rules.
- If the submission passes, FormBold saves it to your dashboard and adds a row to your Google Sheet.
If Google Sheets does not accept a delivery, FormBold retries it automatically. Email notifications and other integrations on the same form keep working either way.
How to Connect Your Form to Google Sheets
- Open your form in FormBold and go to the Integrations tab.
- Click the Google Sheets card.
- Click Sign in with Google and allow FormBold to access Google Drive and Sheets.
- Choose to create a new spreadsheet or select an existing one.
- Click Save and Activate.
To test it, open the sheet in your browser and submit an entry from your form. A new row should appear with the values you entered.
Make sure every input in your HTML form has a name attribute. FormBold uses that name as the column header.
This form creates three columns in your sheet: name, email, and message, plus the timestamp.
Common Uses
- Lead lists: Collect contact form leads in one sheet your sales team can filter and assign.
- Event and waitlist signups: Track who registered and when.
- Order and quote requests: Log each request with the details the customer entered.
- Survey and feedback responses: Analyze answers with formulas, charts, or pivot tables.
Frequently Asked Questions
Do I need Google Apps Script?
No. FormBold connects to Google Sheets through your Google account. You do not write or deploy any script.
Do I need to use Google Forms?
No. You keep your own form design on your own site. FormBold sends the data to Sheets.
How are form fields matched to columns?
FormBold creates a column for each input, named after its name attribute.
Does each submission add a new row?
Yes. Every valid submission is added as a new row with a timestamp.
Can I use a spreadsheet I already have?
Yes. During setup, choose an existing sheet instead of creating a new one.
Do spam submissions go to my sheet?
No. FormBold checks each submission for spam before it sends anything to Google Sheets.
Can I export submissions another way?
Yes. The FormBold dashboard also lets you export all submissions as CSV or JSON.