Google Sheets

Google Sheets

FormFlow can automatically add a new row to a Google Sheets spreadsheet every time a customer submits a form. Each form can write to its own spreadsheet and sheet tab.

Connecting Google Sheets

1. Go to Settings and open the Google Sheets tab
2. Click Connect with Google
3. Sign in with the Google account that owns the spreadsheet(s) you want to write to
4. Grant FormFlow permission to view and edit your spreadsheets

Your connected Google account email is shown once the connection is established.

To disconnect: click Disconnect Google account. This will stop all active Google Sheets syncs until you reconnect.

Configuring a Form to Use Google Sheets

Connecting Google Sheets in Settings only links your account. You choose which spreadsheet each form writes to in the form itself:

1. Open the form in the Form Builder
2. Go to the Integrations tab
3. Find Google Sheets and toggle it on
4. Select the Spreadsheet from your Google Drive
5. Select the Sheet tab within that spreadsheet

Each form writes to its own configured sheet. Multiple forms can write to different sheets within the same spreadsheet.

What Gets Written

When a submission is received, FormFlow appends a new row with all submitted field values. Column headers are written automatically on the first submission based on your form’s field names.