Title: CF7 Spreadsheets Author: moshensky Published: 2017 年 1 月 5 日 Last modified: 2020 年 12 月 29 日 --- 搜索插件 ![](https://ps.w.org/cf7-spreadsheets/assets/banner-772x250.jpg?rev=1570283) **该插件尚未通过WordPress的最新3个主要版本进行测试**。 当与较新版本的WordPress一起 使用时，可能不再受到维护或支持，并且可能会存在兼容性问题。 ![](https://ps.w.org/cf7-spreadsheets/assets/icon-256x256.png?rev=1570283) # CF7 Spreadsheets 作者：[moshensky](https://profiles.wordpress.org/moshensky/) [下载](https://downloads.wordpress.org/plugin/cf7-spreadsheets.2.3.2.zip) * [详情](https://cn.wordpress.org/plugins/cf7-spreadsheets/#description) * [评价](https://cn.wordpress.org/plugins/cf7-spreadsheets/#reviews) * [安装](https://cn.wordpress.org/plugins/cf7-spreadsheets/#installation) * [开发进展](https://cn.wordpress.org/plugins/cf7-spreadsheets/#developers) [支持](https://wordpress.org/support/plugin/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](https://www.youtube.com/watch?v=ZgZRBByY4fc) Video instruction (OLD versions): [https://www.youtube.com/watch?v=5ICWr5MMo7E](https://www.youtube.com/watch?v=5ICWr5MMo7E) 1. Prepare API 2. * Go to the [Console Developers API](https://console.developers.google.com/) * 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). 3. Create a table 4. * Go to the [Google Spreadsheets](https://docs.google.com/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. 5. Paste the spreadsheet URL and ID in plugin options page, upload JSON file, and choose other options. 6. 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](https://console.developers.google.com/apis/api/sheets.googleapis.com/), 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. ## 评价 ![](https://secure.gravatar.com/avatar/64706c7e5188ab1b516b3a13caa4eb4d8d9df6b84598f7c2727b49b65898c0dc? s=60&d=retro&r=g) ### 󠀁[Perfect!](https://wordpress.org/support/topic/perfect-8702/)󠁿 [ofmarconi](https://profiles.wordpress.org/ofmarconi/) 2021 年 8 月 8 日 It has never been easier! ![](https://secure.gravatar.com/avatar/efa17ac72e4a810ca68ba8e5542bc60647986fdb710503200f3126d58ee9f3dc? s=60&d=retro&r=g) ### 󠀁[Excellent](https://wordpress.org/support/topic/excellent-9914/)󠁿 [ikenfin](https://profiles.wordpress.org/ikenfin/) 2020 年 11 月 2 日 Works great, thanks! It needs “how-to” page for users not familar with google api configuration. — Местами не очень понятные названия у полей настройки на русском языке. В частности “url таблицы” это ID файла spreadsheet, а не url на файл. ![](https://secure.gravatar.com/avatar/07f1ca4c9fa7c4706c4f3afbd7a59d9e33b8422c4ddb6300495af528e795bcd2? s=60&d=retro&r=g) ### 󠀁[CF7 Spreadsheets Review](https://wordpress.org/support/topic/cf7-spreadsheets-review/)󠁿 [Ramana Chary.K](https://profiles.wordpress.org/ramanachary/) 2020 年 8 月 13 日 Its Working & Thanks for Your Plugin ![](https://secure.gravatar.com/avatar/fda7ca06acf5b5acadaf7415280e389be9f42f83cd88dc30716ab7f2c7718643? s=60&d=retro&r=g) ### 󠀁[not working](https://wordpress.org/support/topic/not-working-3294/)󠁿 [](https://profiles.wordpress.org/demenyzo/) 2020 年 6 月 12 日 not working anymore ![](https://secure.gravatar.com/avatar/52ff85888cc10e1b55188c538bac7e164a784f9619f32af37e4024e4c3793139? s=60&d=retro&r=g) ### 󠀁[Wonderful support](https://wordpress.org/support/topic/wonderful-support-43/)󠁿 [stefanando](https://profiles.wordpress.org/stefanando/) 2020 年 3 月 30 日 Thank you for your support in solving the issue I had with this simple and effective plugin! ![](https://secure.gravatar.com/avatar/6226c79379175fa7754083d74a97c3d5695aa163fdae40a082624e30de8f8b35? s=60&d=retro&r=g) ### 󠀁[Excellent](https://wordpress.org/support/topic/excellent-8188/)󠁿 [juanchopaul23](https://profiles.wordpress.org/juanchopaul23/) 2019 年 10 月 15 日 1 回复 Excellent, although a bit difficult to configure. [ 阅读所有19条评价 ](https://wordpress.org/support/plugin/cf7-spreadsheets/reviews/) ## 贡献者及开发者 「CF7 Spreadsheets」是开源软件。 以下人员对此插件做出了贡献。 贡献者 * [ moshensky ](https://profiles.wordpress.org/moshensky/) [帮助将「CF7 Spreadsheets」翻译成简体中文。](https://translate.wordpress.org/projects/wp-plugins/cf7-spreadsheets) ### 对开发感兴趣吗? 您可以[浏览代码](https://plugins.trac.wordpress.org/browser/cf7-spreadsheets/)， 查看[SVN仓库](https://plugins.svn.wordpress.org/cf7-spreadsheets/)，或通过[RSS](https://plugins.trac.wordpress.org/log/cf7-spreadsheets/?limit=100&mode=stop_on_copy&format=rss) 订阅[开发日志](https://plugins.trac.wordpress.org/log/cf7-spreadsheets/)。 ## 更新日志 #### 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](https://contactform7.com/selectable-recipient-with-pipes/) #### 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 ## 额外信息 * 版本 **2.3.2** * 最后更新：**5 年前** * 活跃安装数量 **400+** * WordPress 版本 ** 4.7 或更高版本 ** * 已测试的最高版本为 **5.6.17** * 语言 * [English (US)](https://wordpress.org/plugins/cf7-spreadsheets/) * 标签 * [contact form 7](https://cn.wordpress.org/plugins/tags/contact-form-7/)[data](https://cn.wordpress.org/plugins/tags/data/) [google](https://cn.wordpress.org/plugins/tags/google/)[spreadsheets](https://cn.wordpress.org/plugins/tags/spreadsheets/) [table](https://cn.wordpress.org/plugins/tags/table/) * [高级视图](https://cn.wordpress.org/plugins/cf7-spreadsheets/advanced/) ## 评级 4.7 星（最高 5 星）。 * [ 17 条 5 星评价 ](https://wordpress.org/support/plugin/cf7-spreadsheets/reviews/?filter=5) * [ 1 条 4 星评价 ](https://wordpress.org/support/plugin/cf7-spreadsheets/reviews/?filter=4) * [ 0 条 3 星评价 ](https://wordpress.org/support/plugin/cf7-spreadsheets/reviews/?filter=3) * [ 0 条 2 星评价 ](https://wordpress.org/support/plugin/cf7-spreadsheets/reviews/?filter=2) * [ 1 条 1 星评价 ](https://wordpress.org/support/plugin/cf7-spreadsheets/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/cf7-spreadsheets/reviews/#new-post) [查看全部评论](https://wordpress.org/support/plugin/cf7-spreadsheets/reviews/) ## 贡献者 * [ moshensky ](https://profiles.wordpress.org/moshensky/) ## 支持 有话要说吗？是否需要帮助？ [查看支持论坛](https://wordpress.org/support/plugin/cf7-spreadsheets/)