Description
CF7 Google Sheet Connector is an addon plugin, A bridge between your WordPress based Contact Form 7 forms and Google Sheets. ** 🚀 A Most Popular WordPress Plugin.**
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](https://www.gsheetconnector.com/cf7-google-sheet-connector-pro?wp-repo)✨
➜ 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 of the WPForms Google Sheet PRO Addon Plugin
⚡️ Check Live Demo
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 CF7 Google Sheets Connector
🚀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.