CF7 Google Sheets Connector

説明

This plugin is a bridge between your WordPress Contact Form 7 forms and Google Sheets.

When a visitor submits his/her data on your website via a Contact Form 7 form, upon form submission, such data are also sent to Google Sheets.

How to Use this Plugin

In Google Sheets
* Log into your Google Account and visit Google Sheets.
* Create a new Sheet and name it.
* Rename the tab on which you want to capture the data.

In WordPress Admin
* Create or Edit the Contact Form 7 form from which you want to capture the data. Set up the form as usual in the Form and Mail etc tabs. Thereafter, go to the new “Google Sheets” tab.
* On the “Google Sheets” tab, copy-paste the Google Sheets sheet name and tab name into respective positions, and hit “Save”.

In Google Sheets
* In the Google sheets tab, provide column names in row 1. The first column should be “date”. For each further column, copy paste mail tags from the Contact Form 7 form (e.g. “your-name”, “your-email”, “your-subject”, “your-message”, etc).
* Test your form submit and verify that the data shows up in your Google Sheet.

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 form settings.

スクリーンショット

  • Installation step 3 - Google Sheets Connect Page.
  • Edit form - Google Sheets tab.
  • Google Sheet with special mail tags

インストール

  1. Upload cf7-google-sheets-connector to the /wp-content/plugins/ directory, OR Site Admin > Plugins > New > Search > CF7 Google Sheets Connector > Install.
  2. Activate the plugin through the ‘Plugins’ screen in WordPress.
  3. Use the Admin Panel > Contact form 7 > Google Sheets screen to connect to Google Sheets by entering the Access Code. You can get the Access Code by clicking the “Get Code” button.
    Enjoy!

FAQ

Installation Instructions
  1. Upload cf7-google-sheets-connector to the /wp-content/plugins/ directory, OR Site Admin > Plugins > New > Search > CF7 Google Sheets Connector > Install.
  2. Activate the plugin through the ‘Plugins’ screen in WordPress.
  3. Use the Admin Panel > Contact form 7 > Google Sheets screen to connect to Google Sheets by entering the Access Code. You can get the Access Code by clicking the “Get Code” button.
    Enjoy!
Why isn’t the data send to spreadsheet? 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 access code ( Check debug log )
  2. Wrong Sheet name or tab name
  3. Wrong Column name mapping ( Column names are the contact form mail-tags. It cannot have underscore or any special characters )

Please double-check those items and hopefully getting them right will fix the issue.

How do I get the Google Access Code required in step 3 of Installation?
  • On the Admin Panel > Contact form 7 > Google Sheets screen, click the “Get Code” button.
  • In a popup Google will ask you to authorize the plugin to connect to your Google Sheets. Authorize it – you may have to log in to your Google account if you aren’t already logged in.
  • On the next screen, you should receive the Access Code. Copy it.
  • Now you can paste this code back on the Admin Panel > Contact form 7 > Google Sheets screen.

評価

Worked perfectly ..

..from start to finish – very impressive.

Saved a ton of time getting CF7 fields into sheet for mailing list.

Thanks

Not working.

The plugin is not working, it seems that it doesn’t save the key in the settings and it doesn’t write into the google sheet. 🙁

It’s great once you get it working

Had to alter DefaultServiceRequest.php to make it work by setting CURLOPT_SSL_VERIFYPEER => true, to false on line 193. Then I had to get the sheet columns right (they can not contain capital letters or underscores/spaces only lowercase letters, numbers, and only the hyphen “-” as a special character). So going in knowing these things it should not take you as long as it did for me to set up. Other than those two little things, this plugin works as described and it continues to work great for me and my clients using G Suite.

Great plugin for organizing contact data

This is a pretty good plugin if you want to have all your contact data onto a google sheet. The only issue I encountered was when it wasn’t entering all of the data due to nametag format. For some reason it prefers nametags to be formatted like “product-name” (with dash) as opposed to “ProductName” (no dash). After I figured this out, all of the data was entered onto the sheet. It’s working great now!

Also, Abdullah provided excellent customer support. He helped make sure that my issue was resolved. Thanks Abdullah!

Fabulous!

Google Forms do not integrate well into WordPress. What a well designed solution to a real issue.

Any issues are resolved by ensuring that each column, sheet, and tab are named correctly according to the very clear instructions (capitalization is important!).

22件のレビューをすべて表示

貢献者と開発者

CF7 Google Sheets Connector はオープンソースソフトウェアです。以下の人々がこのプラグインに貢献しています。

貢献者

“CF7 Google Sheets Connector” をあなたの言語に翻訳しましょう。

開発に興味がありますか ?

コードを閲覧するか、SVN リポジトリをチェックするか、開発ログRSS で購読してみてください。

変更履歴

1.7 (26/08/2017)

  • Integrated Special Mail Tags with Spread Sheet without (_)underscores(Refer screenshot).
  • Fixed Date Format as per wordpress standards.

1.6

  • Updated Google Spread Sheet Library
  • Changed classes name for PHP Google Auth library.
  • Delete all data on uninstallation of plugin.

1.5

  • Fixed more class names due to conflict with other plugins.
  • Fixed issue to send hidden fields via dynamic text extension.
  • Added settings link on activation of plugin.

1.4

  • Fixed 500 Internal Server Error if sheet name or tab name is not set.

1.3

  • Added .pot file for easier translation.

1.2

  • Updated plugin description etc.

1.1

  • Fixed date format and display issues related to non-English dates.
  • Fixed the class name due to conflict with other plugins.

1.0

  • First public release
  • Integrated Contact form 7 with Google sheets.