---
title: "Google Sheets Integration"
description: "Send form submissions to Google Sheets automatically. Connect your Google account, map fields to columns, and every new submission appears as a row."
url: https://forminit.com/docs/google-sheets/
---

# 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](https://forminit.com/docs/google-sheets-ss.png)

## Overview

The Google Sheets integration writes each new submission to a spreadsheet you choose, using a column mapping you control. Setup happens in your form's [Workflow](https://forminit.com/docs/workflow/): add a **Send to Google Sheets** step, connect a Google account, select or create a spreadsheet and sheet tab, map submission values to columns, send a test row, and publish.

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](https://forminit.com/pricing/) for plan details.

---

## Setup Guide

### Step 1: Add a Google Sheets step

1. In your Forminit dashboard, open your form
2. Select **Workflow** in the form header
3. Select **+** where the step should run (beneath **Submission received** to record every submission, or on an **If / else** branch to record only matching ones), then choose **Send to Google Sheets**
4. Select the step to open its settings

### 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 step settings, 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

1. Select an existing spreadsheet from the **Spreadsheet** dropdown, or create a new one from the step settings
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

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

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

Click **Send test row** to write a sample row into the selected sheet tab. This adds a real row straight away, before you publish. Open the spreadsheet and confirm the columns land where you expect before going live.

### Step 7: Publish

Select **Publish** to make the step live. Publishing also updates the sheet's header row to match your column labels.

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

---

## Column Mapping Values

Besides your form fields, these metadata values are available:

| Value | Description |
|-------|-------------|
| `{{@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

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

- **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

| Issue | Solution |
|-------|----------|
| Rows aren't appearing | Check that the workflow is published, that the submission reached the **Send to Google Sheets** step (it may be on a different **If / else** branch), and that the step's Google account hasn't been revoked |
| Test row works but submissions don't | Test rows are written before you publish. Select **Publish** so the step runs for new submissions |
| Spreadsheet list won't load | Use the refresh button, or create a new spreadsheet from the step settings; if browsing Google Drive is temporarily unavailable, the step settings will tell you |
| Account was revoked | Reconnect it from **Account & Settings** → **Integrations**, or switch the step to another account, then publish again |
| Sheet tab was deleted or renamed | Re-select the tab in the step settings and publish again |
| A row failed to write | Open the submission's **Workflow** section to see the error and retry the step. A retry adds a new row, so check the sheet first |

---

## FAQ

### 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?

Yes. Click **Connect new account** in the **Send to Google Sheets** step settings, 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?

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?

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?

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?

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

---

## Related

- [Webhooks](https://forminit.com/docs/webhooks/) - Send submission data to any external URL
- [Zapier](https://forminit.com/docs/zapier/) - Connect submissions to thousands of other apps
- [Email Notifications](https://forminit.com/docs/email-notifications/) - Receive submissions via email