Google Sheets Integration

Overview

Connect your forms to Google Sheets and automatically add a new row for every form submission. All responses are synced in real-time, making it easy to analyze data, create charts, and share results with your team.

Setting up Google Sheets

1. 1

   Upgrade to Pro

   Make sure you have an active Pro subscription. Visit /pricing to upgrade.

2. 2

   Connect your Google account

   In the Form Builder, go to Settings → Integrations → Google Sheets. Click Connect to Google.

3. 3

   Authorize SmarterForm

   You'll be redirected to Google to authorize SmarterForm to access your Google Sheets. Grant the necessary permissions.

4. 4

   Choose a spreadsheet

   Select an existing spreadsheet or create a new one. SmarterForm will create a new sheet within the spreadsheet for your form.

5. 5

   Configure column mapping

   Map your form questions to spreadsheet columns. SmarterForm will automatically suggest a mapping based on your question labels.

6. 6

   Enable sync

   Toggle Enable sync to start sending submissions to Google Sheets. New submissions will appear as rows in real-time.

Data Format

Each submission creates a new row in your spreadsheet with the following columns:

• Timestamp: When the form was submitted
• Submission ID: Unique identifier for the submission
• Question responses: One column per question
• Metadata: Additional data like referrer, device type (optional)

Features

• Real-time sync: Submissions appear instantly in your spreadsheet
• Automatic headers: Column headers are created based on question labels
• Multiple forms: Connect multiple forms to the same or different spreadsheets
• Historical data: Optionally sync existing submissions when first connecting

Troubleshooting

Submissions not syncing

• Verify your Pro subscription is active
• Check that sync is enabled in your form settings
• Ensure you haven't revoked Google Sheets permissions
• Verify the spreadsheet hasn't been deleted or moved

Reconnecting Google Sheets

If you need to reconnect your Google account, go to Settings → Integrations → Google Sheets and click Disconnect, then follow the setup steps again.