這個外掛並未在最新的 3 個 WordPress 主要版本上進行測試。開發者可能不再對這個外掛進行維護或提供技術支援,並可能會與更新版本的 WordPress 產生使用上的相容性問題。

CF7 Spreadsheets

描述

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.

螢幕截圖

  • Table options page
  • Output page

安裝

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

常見問題

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.

評價

2020年11月2日
Works great, thanks! It needs “how-to” page for users not familar with google api configuration. — Местами не очень понятные названия у полей настройки на русском языке. В частности “url таблицы” это ID файла spreadsheet, а не url на файл.
2020年3月30日
Thank you for your support in solving the issue I had with this simple and effective plugin!
閱讀全部19個評價

貢獻者及開發者

“CF7 Spreadsheets” 是一個開源的軟體。以下的人對這個外掛作出了貢獻。

貢獻者

將 CF7 Spreadsheets 外掛本地化為台灣繁體中文版。

對開發相關資訊感興趣?

任何人均可瀏覽程式碼、查看 SVN 存放庫,或透過 RSS 訂閱開發記錄

修改日誌

2.3.2

  • Fixed deprecated jQuery method on file upload.

2.3.1

  • Fixed extra notices on non-existing errors.
  • Fixed CF7 (v 5.2.2) bug with new required parameter in internal functions.

2.3.0

  • Fixed CF7 (v 5.2.1) bug with new parameter in internal functions.
  • Fixed notice “uninstall hook can be only static method”

2.2.4

  • Data source became WPCF7_Submission instead of $_POST (pipes feature works).

2.2.3

  • Temporary rollback pipes feature, because it affects placeholders

2.2.2

  • Fixed regexp, responsible for parsing text message (multiline tags and couple of tags in one line works well now)
  • Added pipes feature

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