Linux 软件免费装

在这里免费安装WordPress以及其他软件

Banner图

Plugin Name

开发者 Moshenskyi Danylo
更新时间 2021年1月3日 22:35
PHP版本: 4.7 及以上
WordPress版本: 5.6
版权: GPLv2 or later
版权网址: 版权信息

标签

google contact form 7 table data merge spreadsheets save mail

下载

2.2.1 2.2.4 2.3.0 2.3.2

详情介绍:

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
  2. Go to the Console Developers API
  3. Create new project (or choose existing one)
  4. Click "enable API and services", or click on "library" tab
  5. Find in list "Google sheets API" and click "Enable"
  6. 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.
  7. Save the JSON document
  8. Upload JSON document on plugin page (second tab).
  9. Create a table
  10. Go to the Google Spreadsheets and create new table (or open exists table)
  11. 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).
  12. 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.
  13. Paste the spreadsheet URL and ID in plugin options page, upload JSON file, and choose other options.
  14. Create usual form in Contact form 7 and use it.

安装:

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

屏幕截图:

  • Table options page
  • Output page

升级注意事项:

2.1.2 Column data types (can send formulas to google sheets). 2.0.1 Small fix. 2.0.0 Major update. New interface, few new important features. 1.0.4 Important fix for compatibility with other plugins (required moved inside mani function). Notices. 1.0.3 Security fixes. 1.0.2 Added readme.txt and assets. Not important update. 1.0.1 Added translate to russian language. Added readme. 1.0.0 Alpha version.

常见问题:

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.

更新日志:

2.3.2 2.3.1 2.3.0 2.2.4 2.2.3 2.2.2 2.2.0 2.1.2 2.1.1 2.1.0 2.0.3 2.0.2 2.0.1 2.0.0 1.0.4 1.0.3 1.0.2 1.0.1 1.0.0