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) 這個外掛**並未在最新的 3 個 WordPress 主要版本上進行測試**。開發者可能不再對這個 外掛進行維護或提供技術支援，並可能會與更新版本的 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://tw.wordpress.org/plugins/cf7-spreadsheets/#description) * [使用者評論](https://tw.wordpress.org/plugins/cf7-spreadsheets/#reviews) * [安裝方式](https://tw.wordpress.org/plugins/cf7-spreadsheets/#installation) * [開發資訊](https://tw.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⌉⌊Table options page⌉[ Table options page [⌊Output page⌉⌊Output 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 或更新版本 ** * 已測試相容的 WordPress 版本 **5.6.17** * 語言 * [English (US)](https://wordpress.org/plugins/cf7-spreadsheets/) * 標籤: * [contact form 7](https://tw.wordpress.org/plugins/tags/contact-form-7/)[data](https://tw.wordpress.org/plugins/tags/data/) [google](https://tw.wordpress.org/plugins/tags/google/)[spreadsheets](https://tw.wordpress.org/plugins/tags/spreadsheets/) [table](https://tw.wordpress.org/plugins/tags/table/) * [進階檢視](https://tw.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/)