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. 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 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 the id in 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. 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 headed your-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 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 tagColumn headingNotes
<code>[text* your-name]</code>your-nameThe name in the tag. The field type and the asterisk are not part of it.
<code>[checkbox interests "News" "Offers"]</code>interestsOne column with the ticked options, separated by commas. A menu that allows several choices is written the same way.
A field the visitor left emptyIts column, left empty
The rule's timestampTimestampThe first column, when Include timestamp column is ticked on the rule. It is ticked by default.
A submission from an ad clickutm_source, gclid and similarAdded 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 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 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.

Connect Contact Form 7 to Google Sheets today

Free plugin, one Google sign-in, no add-on. Your next submission lands in the sheet.