Skip to main content

Productivity & workspace

Google Sheets in Core Forms

Append submissions to Google Sheets through a maintained Apps Script receiver.

Bundled with Core Forms, the WordPress forms plugin with every premium feature in the box. No add-on tax.

Bundled, no add-on tax Unlimited sites Use code BLACKFRIDAY for 40% off either plan. Ends December 2 (IST).

The WordPress form to Google Sheets action appends a row for each submission by posting JSON to an Apps Script web app you deploy from your own Google account. There is no OAuth or service account. You paste the maintained receiver script, set a shared secret, and match your sheet's header row to the form's field names.

Core Forms sends JSON to a Google Apps Script web app. The maintained receiver uses a shared secret and appends values according to the sheet’s header row. No service-account upload or OAuth connection is provided.

Google Sheets at a glance

Connection
Apps Script web app URL (/exec)
Auth
Shared secret in Script Properties
Column match
Header row, case-sensitive
Metadata columns
_form_title, _submitted_at
Request timeout
30 seconds
Background run
Optional, needs saved submissions

Full reference: Google Sheets action reference

What you get

How Google Sheets works in Core Forms

Apps Script connection

Deploy the provided script using your Google account and configure the spreadsheet ID.

Shared secret

Set the same secret in the script properties and the Core Forms action.

Header mapping

Select fields to send. Header order may change; numeric zero and false values are retained.

Use cases

What people build with Google Sheets and Core Forms

Shared lead sheet

Give sales a live spreadsheet of contact requests without handing out WordPress logins.

Event registration list

Append each registrant to a sheet with _submitted_at so the organizer can sort by signup time.

Send only safe fields

List just the fields you want in the Fields setting so sensitive answers never leave your site.

Set it up

Connect Google Sheets in 3 minutes

  1. 1

    Install the receiver

    Copy the downloadable script into Apps Script. Set CF_SHARED_SECRET, SPREADSHEET_ID, and optionally SHEET_NAME in Script Properties.

  2. 2

    Deploy the web app

    Execute as yourself and allow anyone to access the URL. The shared secret protects the receiver.

  3. 3

    Configure Core Forms

    Enter the deployment URL and shared secret in the Google Sheets action. Match sheet headers to the form field names.

Want the long version? Read the step-by-step guide with screenshots of every setting.

Every setting, filter, and error message is documented in the Google Sheets action reference.

Sample code

Download a starter for your stack

Working examples — sanitized, ready to drop in. Replace the placeholder values at the top of each file (form ID, upstream URL, allowed origins, API key) and ship. No private data inside; nothing tracks back to anyone’s production site.

Inside Core Forms

The action in WP-Admin

The Add to Google Sheet action with the Apps Script web app URL, a field list and the shared secret
The Fields box limits what leaves the site. The secret is checked by the receiver before a row is written.
Good to know

Requirements and limits

  • Delivery is at least once, not exactly once: if a response is lost after the row is written, a retry can add a duplicate row.
  • Header matching is case-sensitive, so a column named "email" will not receive a field named EMAIL.
  • Use the deployed /exec URL; the Apps Script editor URL or a Google login page is logged as a failure.
  • Values that start with =, +, @, or - are stored as text, so visitors cannot inject spreadsheet formulas.
FAQ

Google Sheets integration questions

Do I need a Google service account or OAuth to send form data to Google Sheets?
No. The action posts JSON to an Apps Script web app that runs as your Google account. A shared secret stored in Script Properties and in the action authenticates each request.
How do I control which columns get filled?
Put the form's field names in the first row of the sheet. Column order doesn't matter, but matching is case-sensitive. Add _form_title and _submitted_at headers if you want that metadata.
Why do I get an unauthorized error?
The secret in the Core Forms action doesn't match CF_SHARED_SECRET in the script's properties. Copy the same random value into both. The Google Sheets troubleshooting list covers the other common errors.
Can I write to a specific tab instead of the first sheet?
Yes. Set SHEET_NAME in Script Properties. Without it, the receiver writes to the first sheet in the spreadsheet.
Will my old Apps Script receiver still work?
Yes. Older receivers that return a plain OK keep working; leave the shared secret empty for those legacy scripts. Switching to the maintained receiver gives you the secret check and formula protection.

Bundled with every Core Forms license.

Google Sheets and every Core Forms-built integration on this site are included with your license. Use code BLACKFRIDAY for 40% off either plan. Ends December 2 (IST).

Black Friday Sale

40% off Core Forms

Forms, polls, surveys, payments, and licensing — every feature, unlimited sites, one plugin.

Copy your code

Those are the after-discount prices. Paste BLACKFRIDAY at checkout to apply it. BLACKFRIDAY40 works too.

Ends December 2 (IST)