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
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
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
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
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
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
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 Forms | Column heading | Notes |
|---|---|---|
| A field labelled "Name" | Name | The label, as you wrote it. |
| A field labelled "Email" | ||
| A field with no label | The field key | Give the field a label for a readable heading. |
| The Submit button | None | Skipped. |
| A submission from an ad click | utm_source, gclid and similar | Added 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 do | Sign in with Google and pick or create a spreadsheet | Deploy a small script in your own sheet and paste its web-app URL into the rule |
| Access Google grants | Only the spreadsheets you pick or create (the drive.file permission) | None to SheetLink: the script runs under your own Google account |
| SheetLink service involved | A sign-in service sets up the connection and refreshes its token. It never receives form data | None |
| Column headings | Written from the form on the first submission | Written by the script from the field keys |
| Several forms | Each rule gets its own tab in the connected spreadsheet | One 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.
Other Supported Integrations
Gravity Forms
SheetLink Forms sends every Gravity Forms entry to Google Sheets as a new row, from your own WordPress site, as soon as the entry is saved.
WPForms
SheetLink Forms sends every WPForms entry to Google Sheets as a new row, from your own WordPress site, as soon as WPForms has processed it.
Ninja Forms
SheetLink Forms adds every Ninja Forms submission as a row in an Excel Online table, sent from your WordPress site through Microsoft Graph.
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.
