Ninja Forms to Google Sheets Integration

SheetLink Forms sends every Ninja Forms submission to Google Sheets as a new row, from your own WordPress site. It works with the free Ninja Forms plugin, 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 Ninja Forms and Google Sheets are connected

Ninja Forms stores submissions in WordPress. SheetLink Forms listens for Ninja Forms finishing a submission and writes it to your Google Sheet: one row per submission, one column per field. Ninja Forms identifies fields by generated keys, which make poor column names, so SheetLink also carries each field's label and uses that 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 Ninja Forms to Google Sheets

Step-by-step setup guide

Before you start

  • A WordPress site with Ninja Forms (the free plugin is enough) 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 Ninja Forms

    Still on the Connect Google screen, use Create rule for this sheet and choose Ninja 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 [ninja_form id="2"]. Leave it blank and the rule covers every Ninja 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 Ninja Forms each heading is the field's label, so a field labelled "Email" gets a column headed "Email". The Submit button is not written.

  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 Ninja form creates

On an empty tab the first submission writes the header row from the form. Ninja Forms sends each value under the field's key and SheetLink adds the label, which becomes the heading.

In Ninja FormsColumn headingNotes
A field labelled "Name"NameThe label, as you wrote it.
A field labelled "Email"Email
A field with no labelThe field keyGive the field a label for a readable heading.
The Submit buttonNoneSkipped.
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 label or key, ignoring capitals, spaces and punctuation. Two fields with the same label would compete for one column, so give each field its own label.

What the free plugin does for Ninja Forms

Works with free Ninja Forms

SheetLink uses the action Ninja Forms fires after every submission. No Ninja Forms add-on or membership is needed.

Readable column names

Columns are named after your field labels, not after the generated keys Ninja Forms uses internally.

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 submission 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 submissions 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 column is headed with something like a word and a long number.
That field has no label in Ninja Forms, so its generated key was used. Add a label to the field, rename the column heading to match it, and later submissions fill the column.
Rows arrive but one column stays empty.
The heading does not match the field's label any more, usually because the label was edited. Rename the heading to the current label, 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

Does this work with the free version of Ninja Forms?

Yes. SheetLink Forms listens for the action Ninja Forms fires after each submission, which is part of the free plugin. No Ninja Forms add-on is required.

Will my columns be named after field keys or labels?

Labels. Ninja Forms sends values under field keys, which are often generated, so SheetLink also sends each field's label and writes that as the column heading. A field with no label falls back to its key.

Is the Ninja Forms to Google Sheets connection free?

Yes. Capturing Ninja 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 submissions from before I installed SheetLink?

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

Connect Ninja Forms to Google Sheets today

Free plugin, one Google sign-in, works with free Ninja Forms. Your next submission lands in the sheet.