GSheetConnector

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:

1. 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

2. 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

3. 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

Read the full description on the official page →