Contact Form 7 to Google Sheets Integration
SheetLink Forms sends every Contact Form 7 submission to Google Sheets as a new row, from your own WordPress site. Contact Form 7 keeps no entries of its own, so the sheet becomes your record of them. The connection is free, takes one Google sign-in, and needs no Contact Form 7 add-on.
Last reviewed November 12, 2026, against SheetLink Forms on WordPress.org.
How Contact Form 7 and Google Sheets are connected
Contact Form 7 emails each submission and stores nothing in WordPress. SheetLink Forms acts once Contact Form 7 has validated a submission and passed it through its spam checks, just before the notification email is sent, and writes it to your Google Sheet: one row per submission, one column per form tag. The row does not depend on the email, so a mail problem on your server does not cost you the lead. This page is the full setup, the column names you will get, and the answers to the problems people run into.
How to Connect Contact Form 7 to Google Sheets
Step-by-step setup guide
Before you start
- A WordPress site with Contact Form 7 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 Contact Form 7
Still on the Connect Google screen, use Create rule for this sheet and choose Contact Form 7 as the form plugin. You can also add it under SheetLink → Sync Rules → + Add Rule. To send only one form, enter its number in Form ID: open the form under Contact → Contact Forms and read the number after
post=in the browser's address bar. Recent versions of Contact Form 7 print a short code of letters and digits as theidin the shortcode; that code is not the number the rule needs. Leave Form ID blank and the rule covers every Contact Form 7 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 Contact Form 7 each heading is the name in the form tag, so
[email* your-email]gives a column headedyour-email. - 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 Contact Form 7 form creates
On an empty tab the first submission writes the header row. Each heading is the name you gave the form tag, exactly as it appears in the form editor.
| Contact Form 7 tag | Column heading | Notes |
|---|---|---|
| <code>[text* your-name]</code> | your-name | The name in the tag. The field type and the asterisk are not part of it. |
| <code>[checkbox interests "News" "Offers"]</code> | interests | One column with the ticked options, separated by commas. A menu that allows several choices is written the same way. |
| A field the visitor left empty | Its column, left empty | |
| The rule's timestamp | Timestamp | The first column, when Include timestamp column is ticked on the rule. It is ticked by default. |
| 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. |
You can rename a heading as long as it still reads the same without capitals, spaces and punctuation: your-name can become "Your Name". For anything else, map the field to the column on the Connect Google screen. If the tab already has a header row, SheetLink leaves it alone and fills the columns whose headings match.
What the free plugin does for Contact Form 7
Not tied to the email
SheetLink acts before Contact Form 7 sends its notification, so a submission still reaches the sheet when the email fails or no mail is set up. Submissions that fail validation or are stopped as spam are not written.
Columns from your form tags
You do not type column names. The first submission writes the header row from the names in your form tags.
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, for example by department or budget. 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 rule with a Form ID never delivers anything.
- The Form ID is probably the code from the shortcode. The rule needs the form's number, which is the value after
post=in the address bar when you edit the form. Or clear the Form ID so the rule covers every Contact Form 7 form. - A column stopped filling after the form was edited.
- Renaming a form tag changes the name SheetLink matches on. Rename the column heading to match the new tag name, or map it on the Connect Google screen.
- A spam submission is not in the sheet.
- That is by design. SheetLink receives only the submissions Contact Form 7 accepts, so anything stopped by validation or by a spam check is not written.
- 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 need Flamingo or a Contact Form 7 add-on?
No. SheetLink Forms is a separate free plugin that acts when Contact Form 7 accepts a submission. It does not need Flamingo or any Contact Form 7 add-on, and you can keep using them if you already do.
Does the row still arrive if the notification email fails?
Yes. SheetLink acts just before Contact Form 7 sends its notification email, after validation and spam checks have passed. A mail server problem, or a form with no working mail setup, does not stop the row.
Is the Contact Form 7 to Google Sheets connection free?
Yes. Capturing Contact Form 7 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 tag's name 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?
Contact Form 7 does not keep submissions, so there is nothing to import from it alone. If Flamingo or CFDB7 has been saving them, Import past entries, which is included in Pro, Agency and SheetLink Plus, reads those 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.
Contact Form 7
Send every Contact Form 7 submission straight into a live Excel Online workbook on OneDrive.
Connect Contact Form 7 to Google Sheets today
Free plugin, one Google sign-in, no add-on. Your next submission lands in the sheet.
