NS Google Sheets Connector

Description

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!

Screenshots

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

Installation

  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

FAQ

Installation Instructions
  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
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.

Reviews

Excellent!

Works perfectly! Pretty straightforward to setup and get going. Great job team! Thank you 🙂

Works

So I finally got it working, it was pain in the ass with google apps. Anyway, I would go for premium, but you are just too expensive. I incline to pay you, but your pricing just does not seem competitive for me :/ I can buy gravity forms with free zapier integration and it would be even less expensive than your plugin. I think you would gather tons of sales on codecanyon with price around 20USD, as for me anything between 20-40 bucks a year is competitive. If we are talking monthly, I think 5-10 bucks tops. I think you are loosing money, but that is just my opinion 🙂

Anyway, why 4 stars, “date” only displays date, what is also important is time, but that is probably not important for everyone.

Made my day!

Well, it is sort of tricky to setup, but it works!
As mentioned, pay attention to every field name or it won’t work.
Also, It was not working at first attempt. got ” PHP 5.5.30 / Array” at log.
Deleted the google oauth, reinstalled the plugin, tried a few times (as the field names was flawlessly correct), turned on the “less secure apps” from google (not sure if it is really necessary), and somewhere in the meanwhile it started to work!

Thaks you! it still on 1st day of use. If it survive working smoothly i’ll certainly buy you a coffee @paypal. =]

Worked on day 1, then stopped

Stopped working after a day (because I made a change that adversely affected Contact Form 7.) I broke it.

It wasn’t an NS Google Sheets Connector problem at all. I was the problem.

NS GSC working! I’m SO HAPPY.

Read all 10 reviews

Contributors & Developers

“NS Google Sheets Connector” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

1.2.4

  • Fixed issue with updating the Google Authentication

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