Title: CF7 Spreadsheets
Author: moshensky
Published: <strong>2017年1月5日</strong>
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://ja.wordpress.org/plugins/cf7-spreadsheets/#description)
 * [レビュー](https://ja.wordpress.org/plugins/cf7-spreadsheets/#reviews)
 *  [インストール](https://ja.wordpress.org/plugins/cf7-spreadsheets/#installation)
 * [開発](https://ja.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

## FAQ

### 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
reply

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/)をチェック
するか、[開発ログ](https://plugins.trac.wordpress.org/log/cf7-spreadsheets/)を [RSS](https://plugins.trac.wordpress.org/log/cf7-spreadsheets/?limit=100&mode=stop_on_copy&format=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](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**
 *  最終更新日 **6年前**
 *  有効インストール数 **400+**
 *  WordPress バージョン ** 4.7またはそれ以降 **
 *  検証済み最新バージョン: **5.6.17**
 *  言語
 * [English (US)](https://wordpress.org/plugins/cf7-spreadsheets/)
 * タグ
 * [contact form 7](https://ja.wordpress.org/plugins/tags/contact-form-7/)[data](https://ja.wordpress.org/plugins/tags/data/)
   [google](https://ja.wordpress.org/plugins/tags/google/)[spreadsheets](https://ja.wordpress.org/plugins/tags/spreadsheets/)
   [table](https://ja.wordpress.org/plugins/tags/table/)
 *  [詳細を表示](https://ja.wordpress.org/plugins/cf7-spreadsheets/advanced/)

## 評価

 5つ星中4.7つ星

 *  [  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/)