內容簡介
Caldera Forms Closure，此外掛將不再更新
由於Caldera Forms將在2021年12月31日停用和退役
歡迎您繼續使用此外掛。我們已更新了Google Integration方法，如果您仍然使用Caldera Forms，您仍然可以使用此外掛
首頁 | 文檔 | 支援 | 展示 | 高級版
此外掛為您的WordPress和Caldera Forms表單提供與Google Sheets的橋樑。
當訪客透過Caldera Forms在您的網站上提交其數據時，提交的數據也會被發送到Google Sheets。
它允許新增Caldera Forms處理器，從而實現提交表格並發送到Google Sheets。
查看現場展示
展示URL
Google Sheet URL檢視提交的數據
Google API
Caldera Forms Google Sheet Connector使用API版本4.0
您只需要簡單地添加工作表名稱、工作表ID、選項卡名稱、選項卡ID，以及在Google Sheets中手動排列列即可
如何使用此外掛
在Google Sheets中
* 登錄您的Google帳戶並訪問Google Sheets。
* 創建一個新工作表並將其命名。
* 重新命名您要捕獲數據的選項卡。
在WordPress管理員中
* 創建或編輯您要捕獲數據的Caldera Forms表單。照常設置表單和郵件等選項卡。然後，進入新的「Google Sheets」選項卡。
* 在「Google Sheets」選項卡中，將Google Sheets工作表名稱和選項卡名稱復制並粘貼到相應的位置，然後點擊「保存」。
在Google Sheets中
* 在Google Sheets的選項卡中，在第1行中提供列名。第一列應該是「日期」。對於每個進一步的列，從Caldera Forms中複製貼上郵件標記（例如「your-name」、「your-email」、「your-subject」、「your-message」等）。
* 測試提交表單，並確認數據出現在您的Google Sheets中。
視頻：如何開始使用Caldera Forms Google Sheets連接器
如何安裝、進行身份驗證和整合Caldera Forms和您的Google Sheet。
在YouTube頻道上查看視頻
重要說明
您必須非常仔細地注意命名。如果Google Sheets和表單設置之間的名稱和拼寫不匹配，此外掛的效果將是不可預測的。
外掛標籤
開發者團隊
② 後台搜尋「Caldera Forms Google Sheets Connector」→ 直接安裝（推薦）
原文外掛簡介
Caldera Forms Closure, No more updates on this plugin
Due to Caldera Forms being sunset/retired on December 31, 2021
You are welcome to continue using the plugin. We have updated the Google Integration method, Therefore you can still use the plugin if you are still using the Caldera Forms
Homepage | Documentation | Support | Demo | Premium Version
This plugin is a bridge between your WordPress Caldera Forms forms and Google Sheets.
When a visitor submits his/her data on your website via a Caldera Forms, upon form submission, such data are also sent to Google Sheets.
It allows to add new processor to Caldera Forms, that enables sending of submitted forms to Google Sheets.
Check Live Demo
Demo URL
Google Sheet URL to Check submitted Data
Google API
Caldera Forms Google Sheet Connector using API version 4.0
You required to simply add Sheet Name, Sheet ID, Tab Name, Tab ID and arrange columns manually in Google Sheet
How to Use this Plugin
In Google Sheets
* Log into your Google Account and visit Google Sheets.
* Create a new Sheet and name it.
* Rename the tab on which you want to capture the data.
In WordPress Admin
* Create or Edit the Caldera Forms 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”.
In Google Sheets
* 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 Caldera Forms(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 Caldera Forms Google Sheets Connector
How to Install, Authenticate and Integrate Caldera Forms with your Google Sheet.
Check Video on YouTube Channel
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.
