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=5ICWr5MMo7E

  1. Prepare API
    • Go to the Console Developers API
    • Enable Sheets API (in library tab)
    • Create new service account
    • 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
  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).
  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”.

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

It works perfectly

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,

Супер!

Долго искал работающий плагин для связи контактной формы и google таблиц, и вот нашел. Работает отлично, никаких багов я не заметил в процессе работы с этим плагином. Рекомендую!

Freaking AWESOME PLUGIN!!!

I never rate plugins, but this is AWESOME!!! Moshenskyi Danylo is incredibly responsive, and if people just knew the power of this plugin it would have hundreds of thousands of downloads. WELL DONE!!!!

Amazing plugin that worked when no other plugin works

I tried many other plugins but no one worked for me when I saw this plugin with only 40 installations I thought it should be a junk plugin.. but I discovered totally the opposite. This plugin offered a very useful features that no other plugin offers the flexibility to manage the columns and add a custom text to the columns.. it doesn't have a field name restrictions.. what I'm happy about this plugin the most besides that it works perfectly is that this plugin gave me the ability to style my sheet nicely and then this plugin added the data to that styled sheet resulting in a an automatically updated beautifully styled google sheet. The only thing that i may don't like that much is that connecting it to google api is not that easy.. but it's not that hard too with the help of this youtube video below.. but hoped that it would be a little easier. https://www.youtube.com/watch?v=5ICWr5MMo7E And finally, i really hope that you keep updating it even if you start selling it on codecanyon with a guarantee that you will keep updating it I'm ready to buy it if the price is resonable.

Functional and flexible – My advised plugin

I have tested multiple plugins to connect Drive and CF7, this is the only one that offers all the functionality I need: - Access to sheets in G Suite Team Drives (most plugins do not offer this) - Flexibility in column-field names - Minimal string manipulation and adding custom text in columns not from CF7 fields. Nice work, this plugin deserves more support. One remark, you need a bit of knowledge about Google API and sheets to be able to set this up. Help may be updated.
Read all 7 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.1.1

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

2.1.0

  • Added CF7 special tags

2.0.4

  • Fixed zero transfer as empty string

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