CraftFormConnect to Google Sheets
Automatically send every new form submission to a Google Sheets spreadsheet the moment it arrives. No coding or Zapier required — connect once and responses flow in forever.
How it works
When you connect Google Sheets, CraftForm creates a new sheet in the spreadsheet you choose (or uses an existing one). Each form field becomes a column header. Every time someone submits your form, a new row is appended with that submission's answers in real time — typically within 1–2 seconds.
Setting up the integration
Open Settings → Integrations
In the form builder, click "Settings" in the top navigation, then click "Integrations" in the sidebar.
Click "Connect" next to Google Sheets
Find the Google Sheets card and click the "Connect" button.
Authorize Google OAuth
A Google sign-in popup opens. Select the Google account that owns the spreadsheet you want to use, then click "Allow" to grant CraftForm permission to read and write your spreadsheets.
Select or create a spreadsheet
After authorizing, you'll see a dropdown with all spreadsheets in your Google Drive. Select an existing one, or type a new name to create a fresh spreadsheet automatically.
Map your form fields to columns
CraftForm auto-maps each question to a column using the question title. You can rename any column header here — the original question title doesn't change in your form. Add a "Submitted At" timestamp column if needed.
Save and test
Click "Save Integration". Submit a test response to your form (use the Preview mode or share the link to yourself) and verify the row appears in your spreadsheet.
Real-time sync details
Troubleshooting common issues
Submissions aren't appearing in my sheet
Check that the Google account you authorized still has edit access to the spreadsheet. If the spreadsheet was moved to trash or deleted, reconnect and select a new one.
OAuth authorization fails
Make sure you're not using a Google Workspace account with third-party app restrictions. Ask your Google admin to allow OAuth for CraftForm, or use a personal Google account.
Columns are in the wrong order
Column order is determined by the order of questions in your form at the time you set up the integration. To fix column order, disconnect and reconnect the integration after reordering your questions.
New questions aren't showing up as columns
When you add new questions to your form after the integration is set up, click "Sync columns" in the integration settings to update the spreadsheet headers.
The integration disconnected after a few weeks
Google OAuth tokens expire if unused for 6+ months or if you revoke access in your Google account settings. Reconnect from Settings → Integrations.