CF7 Google Sheets Connector

Description

This plugin is a bridge between your WordPress Contact Form 7 forms and Google Sheets.

When a visitor submits his/her data on your website via a Contact Form 7 form, upon form submission, such data are also sent to Google Sheets.

How to Use this Plugin

In Google Sheets
* Log into your Google Account and visit Google Sheets.
* Create a new Sheet and name it.
* Rename the tab on which you want to capture the data.

In WordPress Admin
* Create or Edit the Contact Form 7 form from which you want to capture the data. Set up the form as usual in the Form and Mail etc tabs. Thereafter, go to the new “Google Sheets” tab.
* On the “Google Sheets” tab, copy-paste the Google Sheets sheet name and tab name into respective positions, and hit “Save”.

In Google Sheets
* In the Google sheets tab, provide column names in row 1. The first column should be “date”. For each further column, copy paste mail tags from the Contact Form 7 form (e.g. “your-name”, “your-email”, “your-subject”, “your-message”, etc).
* Test your form submit and verify that the data shows up in your Google Sheet.

Important Notes

  • You must pay very careful attention to your naming. This plugin will have unpredictable results if names and spellings do not match between your Google Sheets and form settings.

Screenshots

  • Installation step 3 - Google Sheets Connect Page.
  • Edit form - Google Sheets tab.

FAQ

Why isn’t the data send to spreadsheet? CF7 Submit is just Spinning.

Sometimes it can take a while of spinning before it goes through. But if the entries never show up in your Sheet then one of these things might be the reason:

  1. Wrong access code ( Check debug log )
  2. Wrong Sheet name or tab name
  3. Wrong Column name mapping ( Column names are the contact form mail-tags. It cannot have underscore or any special characters )

Please double-check those items and hopefully getting them right will fix the issue.

How do I get the Google Access Code required in step 3 of Installation?
  • On the Admin Panel > Contact form 7 > Google Sheets screen, click the “Get Code” button.
  • In a popup Google will ask you to authorize the plugin to connect to your Google Sheets. Authorize it – you may have to log in to your Google account if you aren’t already logged in.
  • On the next screen, you should receive the Access Code. Copy it.
  • Now you can paste this code back on the Admin Panel > Contact form 7 > Google Sheets screen.

Reviews

Read all 10 reviews

Changelog

1.4

  • Fixed 500 Internal Server Error if sheet name or tab name is not set

1.3

  • Added .pot file for easier translation.

1.2

  • Updated plugin description etc.

1.1

  • Fixed date format and display issues related to non-English dates.
  • Fixed the class name due to conflict with other plugins.

1.0

  • First public release
  • Integrated Contact form 7 with Google sheets

Contributors & Developers

This is open source software. The following people have contributed to this plugin.

Browse the code