Home/Connectors/Google Sheets

Log Framer Form Submissions in Google Sheets

Spreadsheets & DB • Native Edge Sync

Append form submissions as rows in Google Sheets. Connect your native Framer forms to Google Sheets in 30 seconds with zero client-side API key leaks.

Visual Field Mapping Pipeline
0 Code Required
Framer Form Inputs
name"Alex Rivera"
email"alex@co.com"
message"Inquiry..."
FramerSend VaultAPI Keys EncryptedZero-Retention • Spam Filter
Google Sheets Destination
contact.email
sync_attributes
status200 OK
Ready to route • Copy 1 URL to your Framer form

Framer forms to Google Sheets: what it does

A spreadsheet is the lightest possible lead log: no CRM to configure, easy to share with a client, and simple to filter or chart. FramerSend appends one new row to the tab you choose for every Framer form submission, using the Google Sheets API from its server. Numbers and dates are entered as if someone typed them, so Sheets formats them the usual way.

FramerSend is useful when a form collects files (each upload becomes a link in its cell), when you want every delivery logged with a retry button and an alert email if Google refuses it, or when the same form may later move to a CRM: you switch the connection in the dashboard and the URL in Framer stays the same. The service account only reaches the spreadsheets you share with it.

What gets created: One new row appended at the end of the data on your sheet tab, with each value under the column header of the same name.

What FramerSend sends to Google Sheets

Framer form fieldGoogle Sheets
Every form fieldThe column whose header has the same nameMatching ignores case, spaces and punctuation, and common variants count ("E-mail" fills "Email"). A field with no matching column gets a new header at the end of row 1.
Field namesHeader rowOn an empty tab the first submission writes the field names as the header row. Field Mapping renames keys, which renames the column they go to. A header row that shares no name with the form is treated as positional: values are written in form order, as older versions did.
Lists and checkbox groupsOne cell, comma-separatedText starting with =, +, @ or - is kept as text (not run as a formula), so phone numbers keep their +.
File upload fieldsA link to the uploaded fileFiles are stored first (in your connected storage, or FramerSend's managed storage) and the URL replaces the file in the row.
Numbers, dates, "=…" textParsed by SheetsRows are written with valueInputOption=USER_ENTERED.
Submission timeNot addedFramerSend does not add a timestamp column. The time of each submission is shown in Dashboard → 4. Logs.

Set up Framer to Google Sheets step by step

  1. 1

    Create a service account and key

    In Google Cloud Console create (or pick) a project, enable the Google Sheets API, then go to IAM & Admin → Service Accounts, create one and add a JSON key. The JSON file downloads once; keep it safe.

  2. 2

    Share the spreadsheet with it

    Open the JSON, copy client_email (it ends in .iam.gserviceaccount.com), and share your spreadsheet with that address as an Editor, just like sharing with a colleague.

  3. 3

    Prepare the tab

    Note the exact tab name (default Sheet1). Either leave the tab empty (the first submission writes the header row) or type headers that use your Framer field names; their order does not matter.

  4. 4

    Add the connection in the dashboard

    Google Sheets is set up in Dashboard → 2. Connect CRM, not in the Framer plugin. Paste the whole JSON into Service Account JSON, paste the spreadsheet URL or ID (FramerSend extracts the ID from a full URL) and the tab name. Test signs in, opens the spreadsheet and checks that the tab exists (read-only, nothing is written).

  5. 5

    Create the form, paste the URL, send a test

    In Framer, select the form, open Form → Send to → Add… → Webhook, paste the FramerSend webhook URL (https://www.framersend.com/api/submit/ followed by your form ID) and publish the site. Then submit the live form once and check that a row appears in the right place.

Troubleshooting Framer to Google Sheets

Google Auth: Invalid Service Account JSON format. Paste the full JSON file downloaded from Google Cloud Console.

Cause: Only part of the file was pasted, or it was edited and is no longer valid JSON.

Fix: Open the downloaded .json file in a text editor, copy everything from { to } and paste it again.

Google Service Account Auth failed: …

Cause: Google did not issue a token for this key. Google's message follows the colon; a deleted or disabled key or service account is the usual reason.

Fix: Check the service account in Google Cloud Console, create a new JSON key if needed and paste it into the connection.

Google Sheets: …

Cause: Google refused the row. Google's own message follows the colon. The usual causes are: the spreadsheet is not shared with the service account (or only as Viewer), the Google Sheets API is not enabled in the Cloud project that owns the key, the Sheet Name does not match a tab exactly, or the spreadsheet ID is wrong.

Fix: Share the file with the client_email as Editor, enable the Sheets API for that project, copy the tab name exactly (watch for trailing spaces) and paste the full spreadsheet URL again. Then click Retry on the row in Dashboard → 4. Logs.

Google Sheets: spreadsheetId is required

Cause: The connection was saved without a spreadsheet ID or URL.

Fix: Edit the connection and paste the spreadsheet URL from your browser; FramerSend extracts the ID.

Google Sheets without Zapier vs with Zapier or Make

  • Fewer moving parts. Zapier and Make tutorials chain Framer webhook → Catch Hook → Google Sheets "Create Spreadsheet Row". FramerSend writes the row directly, so there is no Zap to keep switched on.

  • Header-matched without mapping. A Zapier Sheets action needs each value mapped to a column by hand. FramerSend matches field names to headers and adds a column for any new field, so nothing is dropped when the form changes.

  • Usage is not metered. Each new row is a Zapier task. FramerSend has no submission limit, which matters for event signups and giveaways.

  • Credentials stay with you. The row is written by your own service account, which can only reach the files you shared with it, and the JSON key is stored on FramerSend's server, never in Framer.

Full comparison: FramerSend vs Zapier

How it works in 3 simple steps

Zero code or third-party plugins required

1

Connect

Authenticate Google Sheets credentials in the FramerSend dashboard. We encrypt and store them securely.

2

Map Fields

Map your Framer form fields to Google Sheets properties using our visual dropdown UI.

3

Go Live

Paste your webhook URL into your Framer form under Send to → Webhook and publish. Submissions flow automatically.

Every plan includes every connector

Get Google Sheets Integration

Every plan includes Google Sheets and 100+ other connectors. Pay monthly, yearly, or once. Try it free for 14 days, no card needed.

1 Site

For one Framer site

$5/ month
  • Google Sheets and every other connector (100+)
  • 1 Framer site
  • Unlimited submissions & file uploads
  • API keys stay on our server, never in your site
  • Cancel anytime
Get 1 Site — $5/mo →

5 Sites

Popular

For freelancers and small studios

$12/ month
  • Google Sheets and every other connector (100+)
  • 5 Framer sites
  • Unlimited submissions & file uploads
  • API keys stay on our server, never in your site
  • Cancel anytime
Get 5 Sites — $12/mo →

Unlimited Sites

For agencies with many client sites

$25/ month
  • Google Sheets and every other connector (100+)
  • Unlimited Framer sites
  • Unlimited submissions & file uploads
  • API keys stay on our server, never in your site
  • Cancel anytime
Get Unlimited Sites — $25/mo →

14-day free trial of every connector, no card needed. Form fields and FramerSend file uploads stay free forever with a free account.

Start free
14-day refund guarantee Instant license key by email

Why teams use FramerSend for Google Sheets

Encrypted API vault, real-time delivery, and unlimited submissions

Lead Capture

Automatically capture and route leads from your Framer forms.

Workflow Automation

Trigger automated workflows when form submissions arrive.

Data Centralization

Keep all your form data in one place, synced in real-time.

Frequently asked questions

Does FramerSend match Framer fields to my column headers?

Yes. Each value goes under the header with the same name (case, spaces and punctuation ignored). A new form field gets a new column at the end of the header row. Only a header row that shares no name with the form is filled by position.

Can I add a timestamp column?

Not automatically. FramerSend sends only the form values, and the submission time is kept in Dashboard → 4. Logs. If the form itself sends a date or time value, it is written like any other field.

Can I connect with my Google account instead of a service account?

The connection form has an optional OAuth Refresh Token field as an advanced alternative, but there is no Google sign-in button for Sheets. The service account is the documented route.

Can I set this up from the Framer plugin?

No. Google Sheets needs the JSON key and is configured in the FramerSend dashboard. Once the form exists, the plugin's Your forms list shows its webhook URL to copy.

What happens if Google rejects a row?

The submission is logged as failed with Google's message, you get an alert email (at most one per form every 15 minutes), and you can retry it from Logs after fixing the cause.

How do I connect Framer to Google Sheets?

Sign up for a FramerSend account (or log in). Go to Connections → Add Connection → Google Sheets and add your credentials. They are stored server-side and never exposed in your Framer site, which only gets a public form URL.

Are my API keys safe?

Yes, all API credentials are encrypted at rest. The client-side code in Framer only exposes a public Form ID, keeping your private keys entirely secure.

Are there monthly submission limits?

No. FramerSend provides unlimited form submissions across all license tiers so your live website forms never get blocked during high-traffic spikes.