Most form tools make this harder than it needs to be.
Formspree charges $90/month for Google Sheets integration. Other tools send you to the Google Cloud Console to set up OAuth
credentials, create a project, enable APIs,
and configure consent screens.
For a non-technical user who just wants their form submissions in a spreadsheet, that process is a nightmare.
Formgrid does it differently.
No Zapier. No Google Cloud Console.
No OAuth setup. Just share a Google Sheet with one email address and paste the URL. Every new submission appears as a new row
automatically.
This guide shows you exactly how to set
it up in under 3 minutes.
Who This Is For
This guide is for anyone who collects
form submissions and wants them organized
in a Google Sheet automatically:
Event organizers collecting registrations
for workshops, rides, conferences, or community events who need submissions in a spreadsheet for their team to review.
Small business owners collecting client
inquiries, booking requests, or service
applications that manage everything in Google Sheets.
HR teams and hiring managers are collecting
job applications and want every submission in a shared spreadsheet for the team to review together.
Course creators and coaches collecting student inquiries or enrollment requests who track leads in Google Sheets.
Nonprofits collecting volunteer applications, membership forms, or donation inquiries who need a simple, organized record of every submission.
If you collect forms and live in Google
Sheets, this integration was built for you.
What You Get
When Google Sheets is connected to your
Formgrid form:
Every new submission appears as a new row in your spreadsheet automatically.
No manual export. No copy and paste.
No checking a dashboard every day.
Column headers are created automatically from your form field names on the first submission. You do not need to set up
the spreadsheet yourself.
Existing submissions can be synced to your sheet on connection, so your entire submission history appears immediately.
The integration works in real time. The moment someone submits your form the row appears in Google Sheets.
Before You Start
Google Sheets integration is available
on the Formgrid Business plan at
$29/month.
If you are on the Free or Premium plan you will see a prompt to upgrade when you open the Integrations tab.
Step by Step: Connect Google Sheets
to Your Form
Step 1: Open Your Form and Go to
the Integrations Tab
Log in to your Formgrid dashboard at
formgrid.dev.
Click on the form you want to connect
to Google Sheets.
Click the Integrations tab at the
top of your form page.
You will see the Google Sheets integration section. If you are on the Business plan the connect interface is ready to use.
Step 2: Create a Blank Google Sheet
Click the Create blank Google Sheet
button. This opens Google Sheets in a
new tab with a fresh blank spreadsheet.
Give your sheet a name that makes it easy to identify. Something like
"Formgrid: Contact Form Submissions"
or "Event Registrations 2026."
You do not need to create any columns or set up any structure. Formgrid will create the column headers automatically
from your form fields on the first
submission.
Step 3: Share the Sheet with Formgrid
In your Google Sheet click the Share
button in the top right corner.
In the Share dialog add this email
address as an Editor:
formgrid@sheetrocket.iam.gserviceaccount.com
Back in your Formgrid dashboard the
service account email is shown with a
Copy button so you can copy it
with one click and paste it directly
into Google Sheets.
Make sure you select Editor, not Viewer. Formgrid needs an Editor
access to write new rows to your sheet.
Click Send or Done in the
Google Sheets share dialog.
Step 4: Paste Your Sheet URL
into Formgrid
Go back to your Formgrid dashboard.
Copy the URL of your Google Sheet from your browser address bar.
It will look something like this:
https://docs.google.com/spreadsheets/d/
1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms/edit
Paste the full URL into the sheet
URL field in Formgrid.
Step 5: Choose Whether to Sync
Existing Submissions
Before clicking Connect you will see
this option:
Sync existing submissions to this sheet?
If you already have submissions, Formgrid can add them all to your
Google Sheet now so your entire
history is in one place.
[ ] Yes, sync my existing submissions
Check this box if you want your
existing submission history to appear in the sheet immediately after connecting.
Formgrid will write all past submissions to the sheet in chronological order
before adding new ones.
Leave it unchecked if you only want
new submissions going forward.
Step 6: Click Connect
Click the Connect Google Sheets
button.
Formgrid will:
- Verify it can access your sheet
- Confirm the service account has Editor access
- Save the connection
- Sync existing submissions if you selected that option
If everything is set up correctly
you will see this success message:
Connected successfully
Your sheet is ready. Every new
submission will appear as a new row
automatically.
Step 7: Submit a Test Entry
Go to your form and submit a test
entry with dummy data.
Open your Google Sheet. Within seconds
you will see:
Row 1 contains the column headers
created automatically from your form
field names.
Row 2 contains the test submission
data with a timestamp in the last column.
Every subsequent submission will
appear as a new row below this one
automatically. You never need to
log in to Formgrid to get your data.
It goes straight to Google Sheets.
What Happens For Every New Submission
When someone fills out your form:
Visitor fills out your form
↓
Formgrid receives the submission
↓
Submission saved to Formgrid dashboard
↓
Email notification sent to you
↓
New row added to your Google Sheet
↓
All of this happens in seconds
You get the submission in three places
simultaneously: your email inbox, your
Formgrid dashboard, and your Google Sheet.
Managing Your Connection
Once connected the Integrations tab
shows your connection status:
Pause the integration using the
Active toggle. When paused new
submissions are saved to Formgrid
but not sent to Google Sheets.
Toggle it back on to resume.
Disconnect removes the connection
entirely. Your existing sheet data
stays in Google Sheets but new
submissions will no longer be synced.
Open Sheet takes you directly to
your Google Sheet with one click.
Troubleshooting
"Could not access this sheet"
This means Formgrid does not have
Editor access to your sheet. Go back
to Google Sheets, click Share, and
make sure the Formgrid service account
email is added as an Editor not a Viewer.
"Invalid Google Sheets URL"
Make sure you copied the full URL
from your browser address bar
including the spreadsheet ID.
The URL should contain
/spreadsheets/d/ followed by
a long string of characters.
Submissions not appearing in sheet
Check that the integration is Active
in your Integrations tab. If it shows
Paused click the toggle to resume.
How This Compares to Zapier
| Zapier Route | Formgrid Native | |
|---|---|---|
| Setup time | 20 to 40 minutes | Under 3 minutes |
| Extra cost | $19.99/month for Zapier | Included in $29/month |
| Steps required | 6 to 8 steps | 3 steps |
| Real time | Depends on Zap frequency | Instant |
| Technical knowledge | Medium | None |
How This Compares to Formspree
Formspree charges $90/month for
Google Sheets integration as part
of their Business plan.
Formgrid includes Google Sheets
integration in the Business plan
at $29/month. Along with:
Custom HTML email templates
Auto-responder emails to submitters
Webhooks for connecting to 5,000+ tools
Multiple notification recipients
15,000 submissions per month
Priority support
The same feature. A third of the price.
What the Formgrid Business Plan Includes
At $29/month the Business plan gives you:
Google Sheets native integration (this guide)
Custom HTML email templates
Auto-responder emails to form submitters
Webhooks: connect to Zapier, Make,
Slack, Notion, Airtable and 5,000+ more
Multiple email notification recipients
Custom email subject lines
15,000 submissions per month
Priority support: direct access to
the founder
No contracts. Cancel anytime.
Start your Business plan at formgrid.dev
Real World Example
Annie manages endurance horse riding
events in San Diego.
Every time someone registered for her
ride she received an email with all
the registration details in one long
unformatted block. No labels.
No sections. No structure.
Her event manager had to manually
scan through every registration to
find the information she needed.
For a 200 person event that was
hours of unnecessary work.
She now uses Formgrid with Google
Sheets connected. Every registration
appears instantly in a shared Google
Sheet her entire team can see.
Rider name, horse details, session
selection, payment status. All
organized. All automatic.
She is on the Business plan at
$29/month and has not looked back.
"The level of personal support
was impressive."
Annie Libby
Event Manager, San Diego Endurance Riders
Final Thoughts
Google Sheets integration should not
cost $90/month or require 40 minutes
of technical setup. It should just work.
Three steps. Under 3 minutes.
Every submission in your spreadsheet
automatically.
That is what Formgrid delivers.
👉 Try Formgrid free at formgrid.dev
Upgrade to Business when you are
ready for Google Sheets integration.
Full disclosure: I built Formgrid.
Written as honestly as I could.
Let me know in the comments if
anything looks off.
Tags: #webdev #nocode #googlesheets
tutorial #productivity #smallbusiness
---
Top comments (0)