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.comBack 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/editPaste 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 submissionsCheck 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 secondsYou 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
---