How to integrate Contact Form 7 to Google Sheets | 2 Minutes Solution

YouTube – How To Integrate Contact Form 7 To Google Sheets

Overview

Advanced Form Integration plugin allows you to integrate Contact Form 7 to Google Sheets. When a user fills a form on your website, the plugin will send the data to your selected sheet that will create a new row. It uses secure OAuth 2.0 authentication and the latest Google Sheets API V4. One form can be connected to multiple sheets and multiple forms can be connected to a single sheet too. This plugin gives you the flexibility to map each form field to any sheet column. Additionally, data flow can be controlled using conditional l2ogic.

Contact Form 7
2 Sample Contact Forms

Supported Features

  • Create a new row

Requirement

  • Make sure that the Advanced Form Integration plugin is installed and activated.
  • The feature is supported under the free license so no payment is needed. Enjoy!
  • Read plugin documentation for Contact Form 7 and Google Sheets. It is not required but helpful for better understanding.

Google Sheet Authentication

Before start, you need to authorize your Google Sheets account. Go to WordPress admin area, click AFI > Settings and select the Google Sheets tab. Detailed instructions are there. A video instruction also included for your help. This can take a few minutes to set up and need only on the first time.

Create New Integration

Once authorization is done you can start creating new integration. Click on Add New under AFI menu, New Integration page will appear.

Title

A default title will be auto-generated with an auto incremental number. You can rename it to something related to the task. It will help you to quickly recognize the correct one when there is multiple integrations setup.

Trigger

Select Contact Form 7 in From Provider dropdown. Contact Form 7 plugin must be installed and activated otherwise you won’t see it listed. After selecting Contact Form 7, all forms built under Contact Form 7 will be fetched and auto-populated in Form/Task Name dropdown. Select the form that you want to integrate.

Contact Form 7 – Trigger setup

Action

Select Google Sheets in Platform dropdown. Select task.

Google Sheets
Google Sheets – Action Setup

Map Fields

Available spreadsheets list will be auto-populated. Select the desired one. You can have multiple tabs in the sheet, select the correct one from the dropdown. Now the plugin will fetch table headers (titles) and you can map which form field data want to send on which column. In Google Sheets table titles must be placed in the very first row otherwise the plugin can’t fetch them. Skip columns that you don’t want to map. Finally, click the Save Integration button.

Google Sheets – Table Titles Must Be On First Row

Frequently asked questions

Troubleshooting

Still need help?

Reach our support team at [email protected]