[WordPress] 外掛分享： Integration with Google Sheets for Contact Form 7

WordPress 外掛 Integration with Google Sheets for Contact Form 7 的封面圖片。

前言介紹

  • 這款 WordPress 外掛「Integration with Google Sheets for Contact Form 7」是 2024-01-15 上架。
  • 目前有 100 個安裝啟用數。
  • 上一次更新是 2024-01-16，距離現在已有 474 天。超過一年沒更新，安裝要確認版本是否可用。以及後續維護問題！
  • 外掛最低要求 WordPress 3.6 以上版本才可以安裝。
  • 有 2 人給過評分。
  • 還沒有人在論壇上發問，可能目前使用數不多，還沒有什麼大問題。

外掛協作開發者

alexagr |

外掛標籤

google | sheets | Google Sheets | contact form 7 |

內容簡介

繁體中文總結：
這個外掛提供了Contact Form 7和Google Sheets之間的整合。它在Contact Form 7中添加了一個新的處理器，以便將提交的表單發送到Google Sheets。使用該外掛可以將Contact Form 7配置為在提交表單時將數據發送到Google Sheets。

問題與答案：

- 這個外掛具有什麼功能？
- 提供Contact Form 7和Google Sheets之間的整合，使得提交的表單可以發送到Google Sheets。
- 如何將這個外掛連接到Google Sheets？
- 安裝完外掛後，在設定頁面上創建所需的應用程式憑證，以建立與Google Sheets的連接。
- 如何在Google Sheets中設定數據捕獲？
- 創建一個新的Google Sheet，進入你想要捕獲數據的分頁，在第一列中輸入"datetime"以捕獲提交的時間和日期。不需要為其他列輸入名稱，它們將在表單提交時自動添加。
- 如何在Contact Form 7中設定將數據發送到Google Sheets？
- 打開Contact Form 7的聯繫表單，切換到Google Sheets選項卡，配置Sheet ID和Tab ID並保存。然後提交一個測試表單，驗證數據是否出現在Google Sheets中。
- 這個外掛支援捕獲哪些提交元數據？
- 除了時間日期和常規表單字段外，還可以捕獲Contact Form 7的特殊郵件標籤。可以通過手動在電子表格中添加相應的標題來實現捕獲。
- 這個外掛與"Contact Form 7 Database Addon - CFDB7"整合使用嗎？
- 是的，如果已使用Contact Form 7 Database Addon - CFDB7來保存提交的表單，還可以將已提交的表單重新發送到Google Sheets。這在初始表單提交時出現問題和/或有人錯誤刪除Google Sheets中的數據時非常有用。
- 這個外掛的實施方式有什麼不同之處？
- 它使用服務原則進行Google Sheets的身份驗證，具有完全不同且更可靠的電子表格更新邏輯，實現自動標題生成以確保不會丟失提交的數據，同時支援捕獲提交的元數據。

原文外掛簡介

This plugin provides integration between Contact Form 7 and Google Sheets.
It adds new processor to Contact Form 7 that enables sending of submitted forms to Google Sheets.
Connecting the Plugin to Google Sheets
After installing the plugin you must go to it’s Settings screen and create application credentials needed to establish connection with Google Sheets. All instructions are provided in the Settings screen.
After successfully creating application credentials and uploading them (i.e. completing steps 1 and 2), you will see Client ID and Client Email that represent your instance of “Google Sheets for Contact Form 7” plugin. You will need to share your sheets with Client Email (as Editor role) to grant “Google Sheets for Contact Form 7” plugin permissions to edit them.
Using the Plugin
After successfully connecting the plugin to Google Sheets, do the following to configure your Contact Form 7 to send data to Google Sheets on form submission.
In Google Sheets

Create a new Google Sheet
Switch to the tab where you want to capture the data

Determine Sheet ID and Tab ID from the sheet’s URL that looks as follows: https://docs.google.com/spreadsheets/d/sheet-id/edit#gid=tab-id
For example, for URL https://docs.google.com/spreadsheets/d/142XLjqRCpr7iWldfARhSS_GiFoy4l5RqZfSD6RHXM64/edit#gid=0 Sheet ID is “142XLjqRCpr7iWldfARhSS_GiFoy4l5RqZfSD6RHXM64” and Tab ID is “0”

Enter “datetime” in the the first column if you want to capture time and date of submission

There is no need to enter names for other columns – they will be automatically added upon form submission
Share the sheet with Client Email that represents your instance of “Google Sheets for Contact Form 7” plugin – as Editor role

In Contact Form 7

Open your contact form
Switch to Google Sheets tab
Configure Sheet ID and Tab ID and click Save
Submit a test form and verify that the data shows up in your Google Sheet

Automatic Header Generation
The plugin verifies spreadsheet header on each new form submission and adds new fields to it if needed. Note that it never deletes fields from the header – as this would also delete some submission data – though you can do it manually. You may also manually reorder columns as you wish.
Capturing Submission Metadata
In addition to the datetime and regular form fields, you may also capture Contact Form 7 special mail-tags. In order to do so, add manually corresponding headers to your spreadsheet. Remove square brackets and first underscore from the tag name, and replace remaining underscores with dashes. For example, add remote-ip header to capture [_remote_ip] mail-tag.
Integration with “Contact Form 7 Database Addon – CFDB7”
If you use Contact Form 7 Database Addon – CFDB7 to save your submissions, you will also be able to resend already submitted forms to Google Sheets. This may be useful if something went wrong during initial form submission and/or someone deleted data in Google Sheets by mistake. In order to do so, in CFDB7 plugin, choose your form, open specific submission and click Send to Google Sheets button.
Acknowledgements
Initial version of this plugin was inspired by CF7 Google Sheets Connector plugin.
However it’s implementation is quite different:

it uses service principle for authentication with Google Sheets
it has completely different and much more reliable sheets update logic
it implements automatic header generation, to ensure that no submission data is lost
it supports capturing submission meta-data
it provides integration with CFDB7 plugin for forms re-submission

各版本下載點

  • 方法一：點下方版本號的連結下載 ZIP 檔案後，登入網站後台左側選單「外掛」的「安裝外掛」，然後選擇上方的「上傳外掛」，把下載回去的 ZIP 外掛打包檔案上傳上去安裝與啟用。
  • 方法二：透過「安裝外掛」的畫面右方搜尋功能，搜尋外掛名稱「Integration with Google Sheets for Contact Form 7」來進行安裝。

（建議使用方法二，確保安裝的版本符合當前運作的 WordPress 環境。

最新版本

延伸相關外掛（你可能也想知道）

文章
Filter
Apply Filters
Close
Mastodon