CF7 Spreadsheets

Description

WordPress plugin that merge Contact form 7 functional with google spreadsheets (also works with private spreadsheet).

How to use:

Video instruction: https://www.youtube.com/watch?v=ZgZRBByY4fc
Video instruction (OLD versions): https://www.youtube.com/watch?v=5ICWr5MMo7E

  1. Prepare API
    • Go to the Console Developers API
    • Create new project (or choose existing one)
    • Click “enable API and services”, or click on “library” tab
    • Find in list “Google sheets API” and click “enable”
    • Go to Credentials tab and click create credentials. In dropdown list choose Service account key. In next window select you service account, and Key type to JSON.
    • Save the JSON document
    • Upload JSON document on plugin page (second tab).
  2. Create a table
    • Go to the Google Spreadsheets and create new table (or open exists table)
    • Copy table URL and ID. For example: //docs.google.com/spreadsheets/d/1yhzO1Q6ikYysfg8LCHqegPM/edit#gid=0 in this table URL is: 1yhzO1Q6ikYysfg8LCHqegPM, and ID is: 0(parameter gid).
    • If you have private spreadsheet – you should grant edit rights to your service account (that we create earlier) directly in spreadsheet. You could find service account email in your website admin panel after uploading JSON file.
  3. Paste the spreadsheet URL and ID in plugin options page, upload JSON file, and choose other options.
  4. Create usual form in Contact form 7 and use it.

Screenshots

  • Table options page
  • Output page

Installation

  1. Upload plugin folder CF7-spreadsheets to wp-content/plugins directory
  2. Open wordpress admin tool and activate the plugin at plugins menu

FAQ

Infinite wheel on mail send

Probably, you not enable “Sheets API” on Google developers console. Follow this link, and click “Enable”. Or you didn’t grant writable access to your service account.

Mail successfully send, but I don’t see result on google table…

Please check, that service account have access to write to your table.

Where I can give spreadsheet ID and URL?

Open table in browser, this parameters will in address string of your browser.

Reviews

May 14, 2019
Let me be 100% clear.. this is the ONLY plugin that claims to do this that ACTUALLY DOES WORK! So if your out there looking for this functionality, don't use the other plugins, use this one because this is the only one that works! Fantastic job on the developers part! Also excellent and quick support via the forums right here. I'm only taking off one star because the instructions of setting things up on the google side of things aren't exactly clear or maybe just not up to date. That part was the part that was the most time consuming/difficult... however you CAN do it.. it isn't way difficult in that you have to really know what your doing, just in that the instructions are exactly clear. GREAT JOB ON THIS PLUGIN AND THANK YOU!
April 5, 2019
After a lot of wasted time working with similar plugins, I finally came across this little gem. Followed the instructions to the tee and voila, perfect results! The YouTube tutorial helped me tremendously. Great plugin, thanks for making this!!
January 18, 2019
Hi, Huge thanks for developing this type of plugin. This is exactly what I need and it's actually so flexible and give options to pass RAW data as well when using CF7 Pipes for conditional email sending. Thanks,
Read all 12 reviews

Contributors & Developers

“CF7 Spreadsheets” is open source software. The following people have contributed to this plugin.

Translate “CF7 Spreadsheets” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

2.2.1

  • Fixed broken packages

2.2.0

  • Added composer config with package list
  • Updated dependencies
  • Added travis.ci to project
  • Added linter (php-cs-fixer) too project files
  • Fixed hidden field

2.1.2

  • Added data types (Number, Boolean, Formula, String)

2.1.1

  • Added shortcodes support
  • Fixed duplicate require upgrade.php file

2.1.0

  • Added CF7 special tags

2.0.3

  • Posts limit changed to unlimited

2.0.2

  • Fixed checkbox and multiselect results
  • Removed placeholders at empty fields

2.0.1

  • Fixed removing plugin data from database on deactivation

2.0.0

  • Rewrite in OOP style
  • Added configuring output row
  • Added forms choose to use
  • Fixed bug with checkbox (default action CF7)
  • New user interface

1.0.4

  • Compatibility with other plugins, that use google account fixed
  • Notice added
  • RU Translation updated

1.0.3

  • Security fixes

1.0.2

  • Added readme.txt and assets

1.0.1

  • Added translate to russian language
  • Added readme

1.0.0

  • Alpha version