1. Home
  2. Docs
  3. CF7 GSheet Connector Free
  4. How to Connect a Google Sheet with CF7 Forms?

How to Connect a Google Sheet with CF7 Forms?

To Connect Google Sheet and Contact Form 7

Successfully Install Contact Form 7 and CF7 Google Sheet Connector Plugins then Activate the Plugin through the ‘Plugins’ Screen in WordPress.

  • Use the Admin Panel > Contact form 7 > Google Sheet screen to Add do Integration Google Access Code.
google sheet button How to Connect a Google Sheet with CF7 Forms?
  • Here you will need to integrate Contact Form 7 plugin with your Google account. Simply click on “Get Code” button to get access code for authentication.
get code
  • By clicking on the get code button it will redirect you to your Gmail account. Sign in and you will get a message to allow create, edit, delete and view your googlesheets.
gsheet connector permission
gsheet connector permission
gsheet connector permission
  • By clicking on the Allow button you will get your access code. You can copy code and enter the code in the textbox and save it. After saving code you will see message in green that Access code saved. But do check debug log for invalid access code.
view button
  • Go to Google Drive, Create a New Google Sheet and Add Google Sheet Title and Google Sheet Tab Name.
cf7 Google Sheet
  • Go to the Contact form 7 > Here click on edit of Contact form for which you want to connect with Google Sheet
cf7 Edit Contact Form
  • Click on the Google Sheet Tab.
  • From the Respective Google Sheet copy-paste the “Google Sheet Title”, “Google Sheet Tab Name”, “Google Sheet ID” and “Google Sheet Tab ID” on the Google Sheets Tab in the Contact Form 7.
sheet and tab id
  • You Will get Google Sheet ID and Google Tab ID from Your Sheet Slug (URL).
google sheet and tab id
  • Go to Google Drive in the Google sheets tab, provide column names in row 1. (e.g. “your-name”, “your-email”, “your-subject”, “your-message”, etc).
Add CF7 Custom Google Sheet Header Names
  • Test your form submit and verify that the data shows up in your Google Sheet.

How to Authenticate with Google Access code in CF7 Google Sheet Connector FREE Version

How can we help?