Formidable Forms to Google Sheets Integration

SheetLink Forms sends every Formidable Forms entry to Google Sheets as a new row, from your own WordPress site, as soon as the entry is created. The connection is free, takes one Google sign-in, and names the columns after your field labels.

Last reviewed November 12, 2026, against SheetLink Forms on WordPress.org.

How Formidable Forms and Google Sheets are connected

Formidable Forms stores each entry in WordPress and identifies every field by a short generated key, such as kzn0j. SheetLink Forms acts when Formidable creates an entry and writes it to your Google Sheet: one row per entry, one column per field. Because those keys mean nothing as column names, SheetLink sends each field's label as well and uses it for the heading. This page is the full setup, what the columns will be called, and the fixes for the usual problems.

How to Connect Formidable Forms to Google Sheets

Step-by-step setup guide

Before you start

  • A WordPress site with Formidable Forms and at least one form.
  • A Google account that can open or create the spreadsheet you want to fill.
  • The free SheetLink Forms plugin. Google Sheets delivery, the retry queue and the logs are all in the free plugin, on any number of sites.
  1. 1

    Install SheetLink Forms

    In WordPress go to Plugins → Add New, search for "SheetLink Forms", then install and activate it. It is free and needs no licence key.

  2. 2

    Connect Google

    Open SheetLink → Connect Google and click Connect Google. On the screen where Google lists what SheetLink Forms may access, tick the checkbox for "See, edit, create, and delete only the specific Google Drive files you use with this app", then choose Continue. Google leaves that box unticked, and without it SheetLink cannot write to your sheet. It covers only the sheets you pick or create here.

  3. 3

    Pick or create the spreadsheet

    The Google file picker opens. Choose an existing spreadsheet or create a new one. SheetLink can see that spreadsheet and nothing else in your Drive.

  4. 4

    Create the rule for Formidable Forms

    Still on the Connect Google screen, use Create rule for this sheet and choose Formidable Forms as the form plugin. You can also add it under SheetLink → Sync Rules → + Add Rule. To send only one form, enter its ID in Form ID; it is the number in the form's shortcode, for example [formidable id=5]. Leave it blank and the rule covers every Formidable form.

  5. 5

    Submit the form once

    Fill in the form on your site and submit it. On an empty tab the first submission writes the header row from the form's own fields and adds the submission underneath. For Formidable each heading is the field's name as you typed it in the form builder, so a field named "Email" gets a column headed "Email".

  6. 6

    Check the Sync Log

    The Sync Log on the Sync Rules screen lists every delivery with the fields that were sent and Google's answer. If you prefer to keep everything in your own Google account, the classic Apps Script method does the same job without a sign-in: see the Google Sheets setup guide.

The columns a Formidable form creates

On an empty tab the first entry writes the header row from the form. Formidable sends each value under the field's generated key and SheetLink adds the field's name, which becomes the heading.

In FormidableColumn headingNotes
A field named "Email" with key kzn0jEmailThe name you typed, not the key.
A checkbox fieldOne columnThe selected options, separated by commas.
A field the visitor left emptyIts column, left emptyEmpty values are not sent.
A submission from an ad clickutm_source, gclid and similarAdded to the right of your columns the first time a submission carries them.

If the tab already has a header row, SheetLink leaves it alone and fills each column whose heading matches a field's name or key, ignoring capitals, spaces and punctuation. If the very first entry leaves some fields empty, add headings for those fields by hand so later entries can fill them.

What the free plugin does for Formidable Forms

Acts when the entry is created

SheetLink runs on the action Formidable fires after creating an entry, so the row matches what is stored in WordPress.

Readable column names

Columns are named after your field names, not after Formidable's generated field keys.

A tab per rule

Each rule writes to its own tab in the connected spreadsheet, so forms with different fields never share a header row.

Ad attribution

UTM parameters and click IDs (gclid, wbraid, gbraid, fbclid, msclkid) are captured with each entry and written to their own columns.

Retry queue and log

A failed write is retried about 5 minutes, 30 minutes and 2 hours later, then kept for a one-click re-send. Every attempt is in the Sync Log.

Conditional routing

Send entries to a different tab when a field matches a condition. Included in the free plugin.

Two ways to connect Google Sheets, both free

One-click Google (recommended)Classic Apps Script
What you doSign in with Google and pick or create a spreadsheetDeploy a small script in your own sheet and paste its web-app URL into the rule
Access Google grantsOnly the spreadsheets you pick or create (the drive.file permission)None to SheetLink: the script runs under your own Google account
SheetLink service involvedA sign-in service sets up the connection and refreshes its token. It never receives form dataNone
Column headingsWritten from the form on the first submissionWritten by the script from the field keys
Several formsEach rule gets its own tab in the connected spreadsheetOne script and URL per sheet

Troubleshooting

A field is missing from the header row.
It was empty in the first entry, and empty values are not sent, so no column was created for it. Add a heading with the field's name and the next entry that has a value fills it.
Rows arrive but one column stays empty.
The heading no longer matches the field's name, usually because the field was renamed. Rename the heading to the current name, or map the field to the column on the Connect Google screen.
After signing in, a page says "Google Sheets access was not granted".
The Drive checkbox on Google's permission screen was left unticked. Click Try again and tick "See, edit, create, and delete only the specific Google Drive files you use with this app" before choosing Continue.
The Sync Log says "No form fields are mapped to the sheet columns for this rule".
The tab already has a header row and none of its headings match a field in the form. Open SheetLink → Connect Google and map the fields to columns, or rename the headings to match the form's field labels. Matching ignores capitals, spaces and punctuation.
The Sync Log says "No sheet is connected yet".
Google is connected but no spreadsheet was chosen. Open SheetLink → Connect Google and pick or create one.
A second form's rows are not in the first form's tab.
That is by design. The first rule uses the tab you picked when connecting, and every further rule gets its own tab, named after the rule and created on that form's first submission, so forms with different fields do not share one header row. Look for the new tab at the bottom of the spreadsheet.

Frequently Asked Questions

Will my columns be named kzn0j and the like?

No. Formidable identifies fields by generated keys, but SheetLink sends each field's name too and writes that as the column heading. The key is only used when a field has no name.

Does this need a paid Formidable Forms plan?

SheetLink Forms does not use a Formidable add-on. It acts on the entry-created action in Formidable Forms itself, so the Google Sheets connection does not depend on a Formidable add-on being installed.

Is the Formidable Forms to Google Sheets connection free?

Yes. Capturing Formidable Forms submissions and writing them to Google Sheets is part of the free SheetLink Forms plugin, with no submission limit and no site limit. Paid plans add other features, such as Two-Way Sync and extra form builders; they are not needed for this.

What happens if Google Sheets is unavailable when someone submits?

The submission is queued in WordPress and retried three times, about 5 minutes, 30 minutes and 2 hours after each failure. If the third retry also fails it is marked Failed permanently and kept in the Retry Queue with its full contents, where one click re-sends it. Every attempt is in the Sync Log.

Does the form data pass through SheetLink's servers?

No. Submissions go from your WordPress server to Google. With one-click Google, a SheetLink-hosted sign-in service sets up the connection and refreshes its access token, and that is all it does; the refresh token is stored encrypted in your own WordPress database. The classic Apps Script method involves no SheetLink service at all.

I added a field to the form. Why is there no new column?

SheetLink does not widen a sheet that already has a header row. Add a column heading that matches the new field's label and the next submission fills it. Columns for ad attribution, such as utm_source and gclid, are the exception: they are added automatically when a submission carries them.

Can the same submission go to Excel as well?

Yes. Excel alongside Google Sheets is free; Excel as the only destination requires SheetLink Plus. Tick "Mirror this rule to Excel" on the Excel Online screen and each row is copied into your Excel table after it reaches the sheet.

Can I send entries from before I installed SheetLink?

Yes, with Import past entries, which is included in Pro, Agency and SheetLink Plus. It reads the entries Formidable already stored and sends them through a rule to your sheet, oldest first, and never sends the same entry twice.

Connect Formidable Forms to Google Sheets today

Free plugin, one Google sign-in, columns named after your fields. Your next entry lands in the sheet.