Skip to main content

On Submit Actions

Google Sheets

Automatically append each form submission as a new row in a Google Sheet. This is a free action — no premium credits required.

Setup

  1. Open your form in the dashboard and go to the On Submit tab
  2. Click Add Action → Google Sheets
  3. Enter the Spreadsheet ID from your Google Sheet URL — it's the long string between /d/ and /edit
  4. Optionally set a Sheet name if you want to target a specific tab (defaults to "Sheet1")
  5. Share your spreadsheet with the Formcore service account email (shown in the action config) — give it Editor access
  6. Click Save

How it works

  • Automatic headers — submission field names become column headers in the first row. New fields are added as new columns automatically.
  • Deduplication — each delivery has a unique key tracked in a hidden column, so retries never create duplicate rows.

Troubleshooting

Error Fix
Access denied Share the spreadsheet with the service account email as an Editor
Spreadsheet not found Double-check the spreadsheet ID and sheet tab name