How to Connect Your Form to Google Sheets
Automatically sync form submissions to a Google Sheet in real-time. One-click setup, no Zapier needed.
Before you start
- A Formet form
- A Google account
Open form settings
Go to your form in the Formet dashboard. Click Settings → Integrations → Google Sheets.
Connect your Google account
Click "Connect Google Account". Authorize Formet to access your Google Sheets. This is a one-time setup — all your forms can use the same connection.
Choose your destination
Select an existing Google Sheet or let Formet create a new one. If using an existing sheet, select the specific sheet tab where data should go.
Map fields to columns
Formet automatically maps form fields to spreadsheet columns. Review the mapping and adjust if needed. New columns are created for any unmapped fields.
Test the sync
Submit a test response through your form. Check your Google Sheet — the submission should appear as a new row within seconds. Each submission becomes a new row with timestamps.
Frequently Asked Questions
Is the sync real-time?
Yes. Submissions appear in your Google Sheet within seconds of being submitted, with no delay or manual intervention.
Can I use an existing sheet?
Yes. You can connect to any Google Sheet in your Google Drive. Choose an existing sheet and tab, or create a new one.
What happens if I add new fields?
New fields are automatically added as new columns in your sheet the next time a submission comes in.
Do I need Zapier for this?
No. Formet has a native Google Sheets integration. No third-party tools, no extra cost, and no setup complexity.