內容簡介
GSheetConnector for Formidable Forms 是一個堅固的 WordPress 外掛程式，專為了將 Formidable Forms 無縫地整合到 Google Sheets 中而設計。通過輕鬆地將 Formidable Forms 數據直接傳送到指定的 Google Sheets，提升您的數據管理和工作流程自動化。
特點
輕鬆整合：無縫地將 Formidable Forms 連接到 Google Sheets。
工作流程優化：通過自動將表單數據傳送到 Google Sheets，優化您的工作流程。
用戶友好界面：簡化的設置和配置，為您提供一個無壓力的體驗。
開始使用
整合：
在 Formidable Forms 菜單中，找到並點擊「Google Sheets」。
點擊下面的「使用 Google 登入」按鈕。
選擇您的 Google 帳戶並授予必要的權限。
插件將自動檢索並將驗證碼貼到輸入框中。
點擊「保存並驗證」按鈕，最終驗證您並在輸入框中顯示「目前活動」文字。
您還會在輸入框下方看到已驗證的帳戶電子郵件 ID。 （參見截圖）
連接表單和 Google Sheets：
在 Formidable Form 設置中：
導航到「設置」->「操作和通知」選項卡。
找到 GSheetConnector 菜單。
通過添加工作表名稱、工作表 ID、標籤名稱和標籤 ID 來配置工作表詳細信息
保存設置以連接到 Google Sheets。
添加連接的 Google Sheet 標題：
根據上面配置的工作表詳細信息，打開 Google Sheet，手動將表單字段標籤名稱添加到 Google Sheet 中。 （參見截圖）
耶！您已經準備好無縫地將表單提交的數據傳輸到 Google Sheet 中。
數據庫存儲
GSheetConnector 將 Google Sheets 詳細信息存儲在 WordPress 數據庫中。這些包括驗證詳細信息，如驗證碼和令牌詳細信息，如訪問令牌、範圍、驗證創建和到期時間戳等等。
第三方服務使用
GSheetConnector 依賴以下第三方服務來實現特定功能。請注意以下所使用的外部服務：
Google APIs
GSheetConnector 使用 Google APIs 來將其與 Google Sheets 整合。這涉及與以下域名的通信：
Google APIs 的基本網址：
https://www.googleapis.com
請查閱 Google APIs 的使用條款和隱私政策：
Google APIs 服務條款
Google 隱私和條款
OAuth 2.0 授權服務器
為了處理身份驗證，GSheetConnector 與 Google 提供的 OAuth 2.0 授權服務器交互。相關的 URL 包括：
令牌 URL：
https://oauth2.googleapis.com/token
撤銷 URL：
https://oauth2.googleapis.com/revoke
請查閱 Google OAuth 2.0 的使用條款和隱私政策：
Google API 服務用戶數據策略
Google 隱私和條款
使用的庫
Google API Client Library：
GitHub 存儲庫
Google API Client Library是一組用於簡化訪問 Google 服務的客戶端庫。這裡我們使用的是使用 PHP 編程語言的 Google Drive。這些庫提供了一個方便的方法來與 Google APIs 交互，並處理身份驗證、請求格式化和其他常見任務。
使用的範圍
https://www.googleapis.com/auth/drive.metadata.readonly
此範圍與 Google Drive API 相關聯，用於請求訪問有關用戶的 Google Drive 文件的唯讀元數據的權限。具體來說，此範圍授予您的應用程序能夠查看元數據，例如文件和文件夾名稱、ID、修改日期和其他信息，但無法修改或刪除文件的實際內容。
https://www.googleapis.com/auth/spreadsheets
此範圍與 Google Sheets API 相關聯，用於請求代表用戶管理 Google Sheets 的權限。此範圍授予您的應用程序讀取、編寫、
外掛標籤
開發者團隊
② 後台搜尋「GSheetConnector For Formidable Forms」→ 直接安裝（推薦）
原文外掛簡介
GSheetConnector for Formidable Forms is an addon plugin,
A bridge between your WordPress based Formidable Forms and Google Sheets.
✔🚀 Quick and Simple to use WordPress Plugin.
If you’re using Formidable Forms by WPMU DEV to collect data from your website visitors , it’s important to have a streamlined process for managing that data. One way to do this is to send Formidable form entry data directly to a Google Sheet. This integration can save your time and effort by eliminating the need to manually transfer data from your form submissions to your spreadsheet.
When a visitor submits their information on your website using GSheetConnector for Formidable Forms, the data they provide is automatically sent to Google Sheets upon form submission in real-time.
Homepage | Documentation | Support | Demo | Formidable Forms Google Sheet PRO
= 📝 Formidable Forms ➜ ✍️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 Formidable Forms Google Sheet 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.
➜ Syncronize Existing Entries for Formidable Forms 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 of the Formidable Forms Google Sheet PRO Addon Plugin
⚡️ Check Live Demo
Demo URL: Formidable Google Sheet
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
➜ Navigate to Formidable Forms > Google Sheet > Integration Tab
➜ Authenticate with Google using new “Google Access Code” while clicking on “Get Code”
➜ Make Sure to ALLOW Google Permissions for Google Drive and Google Sheets and then copy the code and paste in Google Access Code field, and Hit Save & Authenticate.
➜ Now fetch the sheet details by clicking “Click here to fetch Sheet details to be set at Formidable Forms settings.
Step: 3 – Form integrate with Google Sheet
➜ Go to Formidable > Google Sheet > Form Feed tabs
➜ Here Display add Form List and Click on Connect to Google Sheet.
➜ Click on Add Feed .
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 Formidable Forms 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.
External Services
This plugin connects your Formidable Forms with Google Sheets. To work properly, it relies on the following external services:
Google APIs (https://www.googleapis.com)
Used to send the form submission data to your connected Google Sheets.
Data sent: Only the form/entry data that you choose to map in the plugin settings.
Data is sent when a form is submitted or when the integration is triggered.
Terms of Service: https://policies.google.com/terms
Privacy Policy: https://policies.google.com/privacy
Google Accounts OAuth (https://accounts.google.com)
Used for authentication and authorization to connect your Google account.
Data sent: During authentication, the plugin requests OAuth 2.0 access tokens with permissions to access your Google Sheets.
Terms of Service: https://policies.google.com/terms
Privacy Policy: https://policies.google.com/privacy
GSheetConnector Authentication Service
Used to simplify the OAuth connection process between your Formidable Forms and Google APIs.
This service does not store your form entries or personal data; it only facilitates authentication with Google.
Terms of Service: https://www.gsheetconnector.com/terms-of-service/
Privacy Policy: https://www.gsheetconnector.com/privacy-policy/
Important Notes
➜ You must pay very careful attention to your naming. This plugin will not send submissions, if names and spellings do not match between your Google Sheets and form fields.
👉 Get Formidable GoogleSheetConnector PRO today