CF7 Spreadsheets

      Geen reacties op 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
    • 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

  1. Table options page

    Table options page

  2. Output page

    Output page

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.

Installation

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

Changelog

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