Skip to content
Forminit Forminit

Google Sheets Integration

Send form submissions to Google Sheets automatically. Connect your Google account, choose a spreadsheet, map your form fields to columns, and every new submission appears as a new row.

Use Cases: Shared lead lists, lightweight reporting, handing data to non-technical teammates, feeding dashboards built on top of Sheets.

Manage Google Sheets panel in Forminit

Overview

Section titled “Overview”

The Google Sheets integration writes each new submission to a spreadsheet you choose, using a column mapping you control. Setup happens entirely inside the Forminit panel: connect a Google account, select or create a spreadsheet and sheet tab, map submission values to columns, send a test row, and activate.

Connected Google accounts are workspace-based: once an account is connected, any form in the workspace can use it.

The Google Sheets integration is available on the Pro plan and higher. See pricing for plan details.

Setup Guide

Section titled “Setup Guide”

Step 1: Open the Google Sheets panel

Section titled “Step 1: Open the Google Sheets panel”
  1. In your Forminit dashboard, open your form
  2. Go to Settings → Actions tab
  3. Find Google Sheets and click Activate to open the configuration panel

Step 2: Connect your Google account

Section titled “Step 2: Connect your Google account”
  1. Click Connect new account
  2. Sign in with Google and approve the requested permissions
  3. Back in the panel, your account appears in the Google account dropdown

If your workspace already has connected accounts, pick one from the dropdown instead.

Step 3: Choose a spreadsheet

Section titled “Step 3: Choose a spreadsheet”
  1. Select an existing spreadsheet from the Spreadsheet dropdown, or create a new one from the panel
  2. Use the refresh button if a recently created spreadsheet isn’t listed yet
  3. The Open link next to the selected spreadsheet takes you straight to it in Google Sheets

Step 4: Choose a sheet tab

Section titled “Step 4: Choose a sheet tab”

Select the Sheet tab the rows should be written to, or create a new tab. This lets several forms share one spreadsheet with a tab per form.

Step 5: Map your columns

Section titled “Step 5: Map your columns”

Each mapping row writes one submission value into one sheet column:

  1. Sheet column: the header name in your spreadsheet. Edit it freely; it doesn’t have to match the form field name
  2. Submission value: pick a form field or a metadata value (see the table below)
  3. Use + Add to map more values, the trash icon to remove a row, and the drag handle to reorder columns
  4. Reset restores the default mapping

Step 6: Send a test row

Section titled “Step 6: Send a test row”

Click Send test row to write a sample row into the selected sheet tab. Open the spreadsheet and confirm the columns land where you expect before going live.

Step 7: Name it and activate

Section titled “Step 7: Name it and activate”
  1. Give the connection a Connection name (e.g., “Leads sheet”) so it’s easy to recognize later
  2. Turn on the Activate Google Sheets toggle and save

From this point on, every new submission is written to the spreadsheet as a new row.

Column Mapping Values

Section titled “Column Mapping Values”

Besides your form fields, these metadata values are available:

ValueDescription
{{@submission_id}}Unique ID of the submission
{{@submitted_at}}Date and time the submission was received
{{@form_id}}ID of the form that received the submission

Form fields are available as placeholders based on their block names, such as {{sender.email}} for the sender email block. A typical mapping looks like: column “Email” ← {{sender.email}}, column “Message” ← your message field, column “Received” ← {{@submitted_at}}.

Managing Connected Accounts

Section titled “Managing Connected Accounts”

Connected Google accounts live at the workspace level and are managed from Account & Settings → Integrations:

  • Add a new Google account to make it available to all forms in the workspace
  • Revoke an account to disconnect it; connections using that account stop writing to their spreadsheets

You can also revoke Forminit’s access from your Google account’s security settings at any time.

Tips

Section titled “Tips”
  • Test after changing the mapping: Send a test row whenever you add, rename, or reorder columns to confirm the sheet matches
  • One tab per form: Sharing a spreadsheet across forms works best with a dedicated tab for each form
  • Keep history with CSV: The integration writes new submissions only; use CSV export to backfill older submissions into the same sheet

Troubleshooting

Section titled “Troubleshooting”
IssueSolution
Rows aren’t appearingCheck that the Activate Google Sheets toggle is on and the connection’s Google account hasn’t been revoked
Test row works but submissions don’tThe connection was never activated; turn the toggle on and save
Spreadsheet list won’t loadUse the refresh button, or create a new spreadsheet from the panel; if browsing Google Drive is temporarily unavailable, the panel will tell you
Account was revokedReconnect it from Account & Settings → Integrations, or switch the connection to another account
Sheet tab was deleted or renamedRe-select the tab in the panel and save the connection again

FAQ

Section titled “FAQ”

Which plans include the Google Sheets integration?

Section titled “Which plans include the Google Sheets integration?”

The Google Sheets integration is available on the Pro plan and higher. It is not included on the Free plan.

Can I connect more than one Google account?

Section titled “Can I connect more than one Google account?”

Yes. Click Connect new account in the integration panel, or add accounts from Account & Settings → Integrations tab. Connected accounts are workspace-based, so every form in the workspace can use them.

Are existing submissions sent to the spreadsheet?

Section titled “Are existing submissions sent to the spreadsheet?”

No. Only submissions received while the integration is active are written to the sheet. For historical data, download a CSV export and paste it into your spreadsheet.

Can multiple forms write to the same spreadsheet?

Section titled “Can multiple forms write to the same spreadsheet?”

Yes. Point each form’s connection at the same spreadsheet and choose a different sheet tab per form, or share one tab if the forms use the same column mapping.

Can I rename the spreadsheet columns?

Section titled “Can I rename the spreadsheet columns?”

Yes. Each mapping row has an editable sheet column name, so your spreadsheet headers don’t have to match your form field names.

What happens if I revoke a Google account?

Section titled “What happens if I revoke a Google account?”

Connections that use the revoked account stop writing to their spreadsheets. Reconnect the account or switch the connection to a different account to resume.

Section titled “Related”