內容簡介
CF7 Google Sheet Connector是一個外掛插件，可在您的WordPress基於Contact Form 7表單和Google Sheets之間建立一個橋樑。 ** 🚀 是一個最受歡迎的WordPress插件。**
當訪客通過Contact Form 7表單在您的網站提交他/她的數據時，這些數據也會被發送到Google Sheets。
主頁 | 文檔 | 支援 | 示範 | 高級版
= 📝 CF7 ➜ ✍️Google Sheet=
消除加入表格設置或將標題（郵件標籤）添加到表格列時出現錯誤。 我們推出了Googlesheet Connector PRO版本，具有更多的自動化功能。
✨[高級版功能](https://www.gsheetconnector.com/cf7-google-sheet-connector-pro?wp-repo)✨
➜自定義Google API整合設置
➜允許從外掛程序設置中創建新表格
➜自定義排序功能/使用啟用-停用管理在表格中顯示的字段/標題名稱/顯示Google表格。
➜在標題中使用所有特殊郵件標籤字段
➜為WPForms PRO用戶同步現有輸入
➜凍結標頭設置
➜標題顏色和行奇偶顏色。
請參閱功能和優點頁面以了解WPForms Google Sheet PRO外掛程式的功能的更詳細信息
⚡️ 查看現場示範
示範網址：CF7 Google Sheet
Google表單URL以檢查提交的數據
⚡️ 如何使用此外掛程序
第1步 – 在Google Sheets中
➜ 登錄您的Google帳戶，然後訪問Google Sheets。
➜ 創建新表格並命名它。
➜ 重命名或保留您要捕獲數據的標簽的默認名稱。
➜ 複製表格名稱、表格ID、標簽名稱和標簽ID（參見屏幕截圖）
第2步 – 在WordPress管理員中
➜ 創建或編輯要捕獲數據的Contact Form 7表單。像平常一樣在表單和郵件等標籤上設置表單。然後，轉到新的“Google Sheets”標籤。
➜ 在“Google Sheets”標籤上，將Google Sheets表格名稱和標籤名稱複製並黏貼到相應位置，然後點擊“保存”。
第3步 – 在表格中排列列
➜ 在Google表格標籤中，在第1行中提供列名。第一列應為“日期”。對於每個進一步的列，從Contact Form 7表單中複製貼上郵件標籤（例如，“your-name”、“your-email”、“your-subject”、“your-message”等）。
➜ 測試您的表單提交並驗證數據是否出現在您的Google表格中。
外掛標籤
開發者團隊
② 後台搜尋「GSheetConnector for CF7 – Connect Contact Form 7 to Google Sheets and Send Form Submissions in Real Time」→ 直接安裝（推薦）
📦 歷史版本下載
原文外掛簡介
GSheetConnector for CF7
🚀 A Most Popular WordPress Plugin.
★★★★★
Google Sheets Connector for CF7 is an addon plugin, A bridge between your WordPress based Contact Form 7 forms and Google Sheets.
When a visitor submits his/her data on your website via a Contact Form 7 form, upon form submission, such data are also sent to Google Sheets.
Homepage | Documentation | Support | Demo | Premium Version
= 📝 CF7 ➜ ✍️Google Sheet=
Get rid of making mistakes while adding the sheet settings or adding the headers ( Mail Tags ) to the sheet column. We have Launched the Googlesheet Connector PRO version with more automated features.
✔ PRO Features
➜ Custom Google API Integration Settings
➜ Allowing to Create a New Sheet from Plugin Settings
➜ Custom Ordering Feature / Manage Fields to Display in Sheet using Enable-Disable / Edit the Fields/ Headers Name to display in Google Sheet.
➜ Using all the Special Mail Tags Fields in Headers
➜ Syncronize Existing Entries for WPForms PRO users
➜ Freeze Header Settings
➜ Header Color and Row Odd/Even Colors.
Refer to the features and benefits page for more detailed information on the features and free vs pro of the CF7 Google Sheet Connector PRO Addon Plugin
⚡️ Check Live Demo
Demo URL: Google Sheets Connector for CF7
Google Sheet URL to Check submitted Data
⚡️ How to Use this Plugin
Step: 1 – In Google Sheets
➜ Log into your Google Account and visit Google Sheets.
➜ Create a new Sheet and name it.
➜ Rename or keep default name of the tab on which you want to capture the data.
➜ Copy Sheet Name, Sheet ID, Tab Name and Tab ID (Refer Screenshots)
Step: 2 – In WordPress Admin
➜ Create or Edit the Contact Form 7 form from which you want to capture the data. Set up the form as usual in the Form and Mail etc tabs. Thereafter, go to the new “Google Sheets” tab.
➜ On the “Google Sheets” tab, copy-paste the Google Sheets sheet name and tab name into respective positions, and hit “Save”.
Step: 3 – Arranging Columns in Sheet
➜ In the Google sheets tab, provide column names in row 1. The first column should be “date”. For each further column, copy paste mail tags from the Contact Form 7 form (e.g. “your-name”, “your-email”, “your-subject”, “your-message”, etc).
➜ Test your form submit and verify that the data shows up in your Google Sheet.
🔥 Videos to help you get started with Google Sheets Connector for CF7
🚀How to Install, Authenticate and Integrate Contact Form with your Google Sheet.
Important Notes
➜ You must pay very careful attention to your naming. This plugin will have unpredictable results if names and spellings do not match between your Google Sheets and form settings.
👉 Get CF7 GoogleSheetConnector PRO today
