Send your Contact Form 7 data directly to your Google Sheets spreadsheet.
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.
β 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
Google Sheet URL to Check submitted Data
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.
πHow to Install, Authenticate and Integrate Contact Form with your Google Sheet.
β 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.
cf7-google-sheets-connector
to the /wp-content/plugins/
directory, OR Site Admin > Plugins > New > Search > CF7 Google Sheets Connector > Install
. Admin Panel > Contact form 7 > Google Sheets
screen to connect to Google Sheets
by entering the Access Code. You can get the Access Code by clicking the “Get Code” button.Google Sheet Integration without authentication
Permission page if user is already logged-in to there account.
Permission popup-1 after logged-in to your account.
Permission popup-2 after logged-in to your account.
After successful integration - Displays "Currently Active".
Google Sheet settings page with input box Sheet Name, Sheet Id, Tab Name, Tab Id.
Get Sheet and Tab Id from the URL.
Google Sheet headers with Special Mail Tags.
Sometimes it can take a while of spinning before it goes through. But if the entries never show up in your Sheet then one of these things might be the reason:
Please double-check those items and hopefully getting them right will fix the issue.
Admin Panel > Contact form 7 > Google Sheets
screen, click the “Get Code” button.Admin Panel > Contact form 7 > Google Sheets
screen.(26-06-2024)
* Security Improvements: Enhanced user input sanitization to prevent malicious code execution in connected Google Sheets.
(11-06-2024)
* Fixed: not allowing users to enter the administration screen.
(07-06-2024)
* Fixed: Vulnerabilities issues.
(09-04-2024)
* Added: UI changes.
(11-03-2024)
* Added : Added links for support,docs.
* Added : Showcasing PRO Features in Google Sheets tab.
(11-12-2023)
* Done UI changes for Tag list in Google Sheet Tab under Contact Form settings.
* Fixed : Resolved active plugins listing issue in system status tab.
(05-10-2023)
* Fixed : Resolved debugging view, open and close link systematically.
* Added : For user without Google Drive and Google Sheets permissions displayed error message.
(03-10-2023)
* Added: Get Code button has replaced with the Sign in with Google button.
* Added: For user without Google Drive and Google Sheets permissions authentication shows alert with message.
* Added: Redesigned System Status and Error Log for improved functionality and user experience.
* Fixed : Vulnerabilities issues.
(24-06-2023)
* Added: few more minor UI changes.
(04-05-2023)
* Added: minor UI changes.
(27-04-2023)
* Fixed : Vulnerabilities issues.
(23-02-2023)
* Added : Remove access permission from google account while deactivating authentication.
* Fixed : Make it compatible with plugin Smart Grid-Layout Design for Contact Form 7.
(05-08-2022)
* Updated: API Library to latest version 2.12.6 and Guzzle Library to version 7.4.3
* Migrated: OAuth OOB to alternative method as getting deprecated from 3rd October 2022.
(19-01-2022)
* Fixed: \’Line Break\’ on textarea issue resolved.