Connecting Google Sheets to your Formaloo forms allows you to automatically sync existing and new form submissions to Google Sheets, making data management easier.
Formaloo lets you connect your forms to Google Sheets in two different ways – using a one-way sync, or two-way sync.
ℹ️ What’s the difference between one-way and two-way Google Sheet sync?
➡️ With a standard, one-way Google Sheets sync, new submissions are automatically synced to your spreadsheet, and you can re-sync the form anytime to push updates made in Formaloo to Google Sheets.
↔️ With a two-way Google Sheets sync, you can also edit the data directly inside Google Sheets and sync those changes back to Formaloo.
A two-way sync can be useful if you:
Prefer reviewing or editing data in spreadsheets
Collaborate with teams inside Google Sheets
Want updates made in Google Sheets to reflect in Formaloo without manual copying
➡️ Connect your form to Google Sheets
Follow these simple steps to connect Google Sheets to your form:
Step 1: Enable Google Sheet integration
Click your Formaloo Profile icon in the top-right corner
Open Apps & Integrations
Find Google Sheets
If needed, click Add to enable the integration
Go to Add new integration to create a new Google Sheets connection
Step 2: Create a new connection
Under Add new integration, create a new connection:
Select the Form you want to sync (search for it by its title or ID),
Enter the Sheet title,
Paste the Sheet URL,
Click Connect
ℹ️️ Copy the URL of your Google Sheet directly from your browser’s address bar.
Make sure that when you copy the Sheet URL, you are in the target Sheet (if your spreadsheet has more than one),
It’s crucial that the Sheet title matches exactly between your spreadsheet and your connection settings in Formaloo:
Step 3: Sync your form data to the Sheet
Once the integration is created:
Open Active integrations,
Find the new connection,
Click Resync data:
This helps verify the connection and syncs any existing submissions to your sheet.
ℹ️ Under Active integrations, you can always:
Review existing connections (see the status, and whether two-way sync is enabled)
Edit any connection's settings
Delete any connection
Re-sync the data
🔗 Learn more about re-syncing, editing, or deleting your Google Sheets connections
⚠️ Essential requirements for Google Sheet sync ⚠️
For the Google Sheet sync to work, these requirements have to be met:
You must be the owner of the form,
A valid Google account must be connected under your Formaloo profile,
All required permissions (view, create, edit, and delete Google Sheets) must be granted to Formaloo upon connecting your Google account,
The connected Google account must have sufficient editor access to the target spreadsheet,
The correct Sheet title and Sheet URL must be used in the connection settings.
If you are facing any issues while creating a new connection, or your existing connection suddenly stopped syncing, check our troubleshooting guide: