Search Over 30,000 FREE Plugins from the Official WordPress Plugin Directory Repository

NS Google Sheets Connector

This is a painless way to integrate and automatically send WordPress data to Google Sheets.

NOW Supports Connecting to Google via OATH! This plugin currently supports connecting the Contact Form 7 plugin to Google Sheets, but let us know what other kinds of data you'd like this to capture!

The PRO Version is now available, and provides connections between unlimited CF7 forms and Google Spreadsheets! We also just added basic integration and support for automatically sending basic WooCommerce data to Google Sheets!

How to Use this Plugin

(Take a look at the screenshot to see how it all ties together and what settings need to go where!)

  1. Install the Contact Form 7 (CF7) plugin if you haven't already.
  2. Create the CF7 Form that you want to use to capture data. You will need the ID and field names from the form.
  3. Log in to your Google Account and create a new Sheet and give it a simple name.
  4. Rename Sheet 1 (tab 1 of the spreadhseet) to something simple that makes sense (maybe the name of your form).
  5. Add a column name in Row 1 for "date" and each form field you will have in your form (default CF7 form field names are "your-name", "your-email", "your-subject", "your-message").
  6. Install this plugin.
  7. Go to Settings > NS Sheets to configure the plugin and click the link to generate a Google Code to paste in the Google Access Code box.
  8. Copy / paste the name of your spreadsheet and worksheet into the Google Sheet Name setting.
  9. Add the spreadsheet tab name and ID of the form you want to use in the settings.
  10. Save your settings.
  11. Test your form submit and verify that the data shows up in your Google Sheet.
  12. Have a beer and celebrate!

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 plugin / form settings.
  • Feedback is really important to us. Let us know if there are other creative ways you want to use this.

Enjoy!

Author Never Settle
Profile
Contributors neversettle
Tags cf7, connector, contact form 7, data, db, form, form data, google, Google Sheets, integration, sheets
  1. ns-google-sheets-connector screenshot 1

    Plugin Settings and How to Configure your Google Spreadsheet and your Contact Form

  1. Log in to your WordPress site as an administrator
  2. Use the built-in Plugins tools to install from the repository or unzip and Upload the plugin directory to /wp-content/plugins/
  3. Activate the plugin through the 'Plugins' menu in WordPress
  4. The current output of the plugin teamplate can be seen by going to Settings > NS Plugin Template

1.2.2

  • Improved conflict checking for other plugins that also use the Google API

1.2.1

  • Added token to database for better handling

1.2.0

  • Completely rewrote plugin and token functions for better compatibility

1.1.0

  • Completely rewrote Google authentication mechanism to use OATH and get get off deprecated Google APIs

1.0.3

  • Added Pro Version Notification

1.0.2

  • Added additional error handling to fix some google connection issues with custom domains

1.0.1

  • Added support for CF7 checkbox fields

1.0.0

  • First public release

Is this plugin supported?

We'll try to answer any questions that come up in the support forum here on WP.org, but can't promise support.

Why isn't the data sending? 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 username / password for google account (not likely - I'm sure you thought of this and made sure, but just thought I'd mention)
  2. Wrong Sheet filename or tab name
  3. Wrong Column name mapping
  4. You might have to tweak your security settings in your google account here: https://security.google.com/settings/security/secureaccount?pli=1 (This plugin uses an older Google API which requires the setting for allowing less secure apps to be Enabled)

Please double-check those things and hopefully one of them is the cause.

Share  
Download
Version 1.2.2

Requires WordPress version: 3.5 or higher

Compatible up to: 4.7.2

Last Updated 15 Feb 2017

Date Added: 02 Oct 2014

Plugin Homepage

Evaluation
star1
star2
star3
star4
star5

4 stars
9 ratings
4,344 downloads

Compatibility

Not Enough Data

Reports:
Works: 0
Broken: 0