Google Sheets Integration

Google Sheets is the most popular destination for form data. BttrForm's native integration sends every submission to a Google Sheet in real time, mapping form fields to spreadsheet columns automatically. No manual exports, no scheduled syncs, no copy-pasting. Your data arrives the moment it is submitted, ready for analysis, sharing, and reporting.

Connecting Google Sheets

Step 1: Open the Integrations Tab

In the BttrForm dashboard, open the form you want to connect. Navigate to the "Integrations" tab and click "Google Sheets" from the list of available integrations.

Step 2: Authorize Google

Click "Connect Google Account". A Google authorization window opens, requesting permission to create and edit spreadsheets on your behalf. Select your Google account and click "Allow".

Step 3: Choose a Spreadsheet

You have two options:

• Create new spreadsheet — BttrForm creates a fresh Google Sheet in your Drive, named after your form. Columns are automatically set up based on your form fields.
• Use existing spreadsheet — Select a spreadsheet from your Drive. BttrForm will display the available worksheets for you to choose from.

Step 4: Map Columns

If you selected an existing spreadsheet, you need to map your form fields to the spreadsheet columns. BttrForm shows a mapping interface with:

• Left column — your form field names
• Right column — dropdown of spreadsheet column headers

For new spreadsheets, columns are automatically created and mapped. The first row becomes the header row, and subsequent submissions fill in rows below.

Step 5: Test and Activate

Click "Send Test Row" to push a sample submission into the spreadsheet. Open the sheet and verify the data appears in the correct columns. Once confirmed, click "Save & Activate" to start the real-time sync.

Auto-Sync Behavior

Once activated, the integration operates as follows:

• New submissions — each submission creates a new row in the spreadsheet, appended at the bottom
• Order — rows are added in the order submissions are received
• Near real-time — submissions typically appear in the sheet within 2 to 5 seconds
• Retries — if Google's API is temporarily unavailable, BttrForm retries delivery up to 5 times with exponential backoff

What Gets Synced

Column Mapping in Detail

Automatic Mapping

When BttrForm creates a new spreadsheet, it maps fields using these column headers:

• Short text / Email / URL — the field label becomes the column header
• Multiple choice / Dropdown — the selected option's label is written as text
• Checkboxes — selected options are joined with commas (e.g., "Red, Blue, Green")
• Ratings / Numbers — numeric value
• Date / Time — formatted as ISO 8601 string, parseable by Google Sheets date functions
• File uploads — URL to the hosted file

Updating Mappings

If you add new fields to your form after setting up the integration, they are not automatically added to the spreadsheet. To include them:

1. Open the form's Integrations tab
2. Click "Edit" on the Google Sheets integration
3. The new fields appear as unmapped entries
4. Map them to new or existing columns
5. Click "Save"

New columns will only be populated for submissions received after the mapping update. Older rows will have empty cells for the new columns.

Working with Form Data in Sheets

Once your data is flowing into Google Sheets, you can leverage the full power of spreadsheet functions for analysis.

Useful Formulas

// Count total submissions
=COUNTA(A2:A)

// Average rating
=AVERAGE(E2:E)

// Count submissions from a specific country
=COUNTIF(D2:D, "United States")

// Most recent submission timestamp
=MAX(B2:B)

// Percentage of respondents who selected "Yes"
=COUNTIF(F2:F, "Yes") / COUNTA(F2:F) * 100

Creating Charts and Dashboards

Select your data range and insert a chart directly in Google Sheets. Common visualizations for form data include:

• Pie chart — distribution of multiple-choice answers
• Bar chart — comparison of ratings or categorical responses
• Line chart — submission volume over time (requires a date column)
• Pivot table — cross-tabulate two fields (e.g., satisfaction rating by department)

Sharing and Collaboration

Google Sheets makes it easy to share form data with your team:

• Share the sheet — grant view or edit access to specific people or your entire organization
• Publish to web — create a read-only published version for stakeholders
• Set up email alerts — use Google Sheets' built-in notification rules to email collaborators when new rows are added

Handling Multiple Forms

Each form has its own Google Sheets integration configured independently. You can:

• Separate spreadsheets — one spreadsheet per form for clean separation
• Shared spreadsheet, separate worksheets — send multiple forms to the same spreadsheet but different tabs. Select the target worksheet during column mapping.
• Shared spreadsheet, shared worksheet — if forms have identical fields, you can point them to the same sheet and worksheet. Add a "Form Name" column (auto-populated by BttrForm) to distinguish the source.

Disconnecting and Reconnecting

Pausing the Sync

To temporarily stop sending data to Google Sheets without removing the configuration, toggle the integration to "Paused" in the Integrations tab. Submissions received while paused are not queued — they are simply not sent to the sheet.

Disconnecting Entirely

Click "Disconnect" to remove the Google Sheets integration. This does not delete any data already in the spreadsheet. You can reconnect at any time and point to the same or a different spreadsheet.

Reconnecting After Token Expiry

Google OAuth tokens can expire if you change your Google password, revoke access, or after extended periods of inactivity. If the token expires, BttrForm shows a warning on the Integrations tab. Click "Reconnect" to re-authorize without losing your column mapping configuration.

Troubleshooting

Rows not appearing: Check the integration status in the Integrations tab. A red indicator means the Google auth token has expired — click "Reconnect." Also verify you are looking at the correct worksheet tab.

Data in wrong columns: Open the column mapping and verify each form field is mapped to the intended column. If columns were reordered in Google Sheets, the mapping still uses column headers, not positions — ensure headers were not renamed.

Duplicate rows: This can occur if a retry was triggered during a transient Google API error. BttrForm includes the submission ID in each row — use Google Sheets' "Remove Duplicates" feature (Data > Data cleanup > Remove duplicates) filtering on the submission ID column.

Formulas breaking: If your formulas reference a fixed range (e.g., A2:A100), they will stop working once you exceed row 100. Use open-ended ranges (e.g., A2:A) to automatically include new rows.