Contact Form 7 is one of the most popular WordPress plugins. Over 5+ million users are using this plugin on their website. This plugin can be used for various reasons. You may create an inquiry form, customer feedback form, survey, etc. with the Contact Form 7 plugin.
When it comes to marketing strategy, you mostly want to capture leads coming through these forms. This customer’s data can be utilized to send them promotional offers, and updates about your products or services. By building a better strategy over the customer’s data you can grow your business. But the question is what’s the best service to store these leads?
Google Sheets is a popular service that can be used to store your website form entries. There are several benefits of using this service.
- You can share access to the Spreadsheet with your colleague or an authorized person.
- Google Sheets provides different formulas which can be integrated as per use cases.
- It’s available on all possible devices – PC, Laptop, Mobile, and Tablets.
In this tutorial, I show you how to send Contact Form 7 entries to Google Sheets. The solution given in this article will allow you to connect unlimited forms with Google Sheets.
Connector – Contact Form 7 & Google Sheets
To get started, you have to install and activate the Connector – Contact Form 7 & Google Sheets plugin. This plugin cost $25 per license. The license you purchased will be valid for 1 year. You’ll get free updates over this period.
After this period is over, you can still continue using this plugin without receiving new updates. It’s up to you to renew your license. There is no subscription plan involved in it.
Upon plugin activation, you will get a new tab Connect Google Sheet inside your every form.
In this section, you should enter your Google Web APP URL, Google Sheet ID, and Google Sheet Tab Name.
Watch the video below which explains how to get the Google Web App URL and use this plugin.
I am also giving a step-by-step guide on how to get these details from your Google account.
How to Get Your Google Web APP URL
Our Connector plugin takes advantage of Google Apps Script to build a bridge between Contact Form 7 and Google Sheets.
Usually, to connect your Google Sheets with the website, you need to follow the OAuth process. During the OAuth, you have to grant access to your Google Drive and Google Sheets to the third-party application. But with the Google Apps Script, you’d cut these middle third-party applications. You’re the only one who will have access to your Google Drive and Google Sheets.
With Google Apps Script, you have to perform some steps inside your Google Sheets. In the end, you’ll get a Web App URL which will be used to grab the form entries into your Spreadsheet.
Open your Google Drive and create a new Google Sheets where you want to capture Contact Form 7 entries.
From your Google Sheets, click on the Extension -> Apps Script. It’ll take you to the Apps Script page. Give it some name.
In the Script editor, you need to paste the code from the plugin’s configuration page which is at Contact -> Connector – Google Sheets.
After adding the above code, click on the Save icon in the Script editor.
Next, you need to authorize this script for your account. From the left side menus, go to Triggers -> Add Trigger. It’ll open a popup with all values prefilled. Make sure the function is set to doPost.
Upon clicking the Save button it prompts for Authorization. It may say Google hasn’t verified this app. Don’t worry about this message. We are going to use this app for internal purposes so no need to verify it. Click on Advanced and proceed with it.
Click on Deploy -> New deployment. Choose a web app from the settings icon.
Next, execute the web app as yourself, set access to Anyone, and hit the Deploy button.
You’ll get your web app URL. Copy it. It’s nothing but your public URL to which our plugin will send form data via POST requests.
Next, grab your Google Sheet ID and Google Sheet Tab Name. You can easily get it from your Spreadsheet. The Sheet ID is present in the URL.
Similarly, Tab Name is available at the bottom of the Sheet. By default, it’s set to Sheet1.
Add these details to your form configuration under Connect Google Sheets tab.
That’s it! Now sit back and relax. You should see your form submissions will be stored automatically on your Google Sheets.
If you want to store multiple forms, create a new Sheet(by clicking the + icon) and pass this newly created tab name in the respected form’s Connect Google Sheets tab. Google Web App URL and Google Sheet ID will remain the same.
The post Send Your Contact Form 7 Entries to Google Sheets appeared first on Artisans Web.