Create a seamless WooCommerce to Airtable integration with Uncanny Automator in just a few clicks—and…
Uncanny Automator is the best Contact Form 7 and Google Sheets integration. Find out why in this easy how-to guide.
Have you been asking yourself, “How do I integrate Contact Form 7 and Google Sheets?” If you have, then you can relax—you’ve found the best solution available.
Storing your Contact Form 7 form submission data in Google Sheets is a great idea. Apart from simply collecting and storing the data, you can use Google Sheets to analyze your form submissions. Whether you want to measure your response time or collate your responses in one place for the whole team to see, this is a great integration to incorporate into your workflows.
In this article, we’ll show you exactly how to connect Contact Form 7 to Google Sheets with the best integration tool around—Uncanny Automator!
What You’ll Need
In order to connect Contact Form 7 to Google Sheets, there are just three things that you’ll need.
Contact Form 7
Contact Form 7 is the no-frills, all-business contact form building plugin for WordPress. While Contact Form 7 might not have an easy drag-and-drop builder like some of its competitors (Gravity Forms and WPForms, for example), it makes up for this with simplicity and flexibility.
Contact Form 7 is a purpose-driven plugin that you can get started with for FREE if you haven’t already.
As an integral part of the Google Suite of apps, Google Sheets needs no introduction. As a powerhouse spreadsheet maker, Google Sheets lets you analyze all of your metrics and KPIs. Most importantly, as with all other Google apps, it’s easy to share your work in Google Sheets with the whole team or restrict access to only a few key decision makers.
Uncanny Automator is the #1 automation and integration tool for WordPress users. Using simple combinations of triggers and actions, you can integrate all of your favorite apps and plugins and automate your workflows. But what makes Automator the best Contact Form 7 and Google Sheets integration?
With Automator’s click-and-play builder, creating Contact Form 7 and Google Sheets integrations is simple and user-friendly—no code required. Additionally, Automator’s advanced features such as tokens (more on those later), filters and delays empower you to create automations that suit your specific needs.
Want to store Contact Form 7 submission dates in Google Sheets? Use a Unix timestamp to record the precise time of a form submission with a single click. How about automatically sorting Contact Form 7 form submissions into different spreadsheets within Google Sheets? You can do that with a simple filter.
Connect Contact Form 7 to Google Sheets
Integrating Contact Form 7 and Google Sheets with Uncanny Automator only takes five steps—and about just as many clicks. Before we dive into the details, here’s a brief overview of the steps we’ll take.
1. Create a new recipe: From your WordPress Admin Sidebar, navigate to Automator > Add New > Everyone.
2. Name your recipe: Contact Form 7 + Google Sheets Integration: Store Form Submission Data.
3. Configure your trigger: Select Contact Form 7 > A form is submitted.
4. Configure your action: Select Google Sheets > Create a row in a Google Sheet.
5. Go Live: Toggle your recipe from Draft to Live.
Step 1: Create a New Recipe
From your WordPress Admin Sidebar, navigate to Automator > Add New. Because we want to store all form submissions in Google Sheets, and not just submissions from our logged-in site users, in the pop-up window that appears, select Everyone.
Step 2: Name Your Recipe
Give your recipe a name that makes it easy to recognize at a glance. For example, we’ve named this recipe Contact Form 7 + Google Sheets Integration: Store Form Submission Data.
Step 3: Configure Your Trigger
In the Triggers panel, from the menu of available integrations, click on Contact Form 7.
From the drop-down list that appears, select A form is submitted.
Automator will prompt you to select one of your contact forms. After you’ve selected the form, click Save. Your trigger should look something like this:
Step 4: Configure Your Action
In the Actions panel, click on Add action. From the menu of available integrations, click on Google Sheets. (Automator will prompt you to connect your Google account. Follow the prompts to do so.)
After you’ve connected your Google account, a drop-down list will appear. Select Create a row in a Google Sheet.
Automator will then prompt you to select the Drive, Spreadsheet and specific Worksheet where you would like to store your Contact Form 7 submissions data. After you’ve selected the worksheet, click Get columns and Automator will retrieve the first value (presumably the title) from each column.
Once Automator has retrieved the columns, you can proceed to fill in the values for the new row of cells. To fill in these cells with Contact Form 7 data, we are going to use tokens (i.e. dynamic pieces of data pulled from across your WordPress website or even, in this instance, from within an Automator recipe).
To select tokens, click on the Asterisk next to a field and select the token that you want to use to populate the cell. For Contact Form 7 tokens, the name of the token corresponds to the name of the field in your contact form. You can also use data and time tokens, such as the Current Unix timestamp token, to record the exact moment that someone submitted the form. (If you’re unfamiliar with Unix time, check out our guide on converting Unix timestamps to dates in Google Sheets and Airtable.)
Fill in the remaining forms using tokens. Depending on how you’ve configured your Google Sheets worksheet, you might fill in the fields as follows:
After you’ve filled out all of the fields, click Save. Your action should look like this:
Step 5: Go Live!
With your trigger and action all configured, it’s time to complete this Contact Form 7 and Google Sheets integration. All you have to do now is toggle your recipe from Draft > Live.
More Contact Form 7 and Google Sheets Integrations
Now that you’ve gotten the hang of the creating Automator recipes, you can create your own Contact Form 7 and Google Sheets integrations. Take this integration, for example, where we automatically tag our contacts in Drip (or a CRM of your choosing) whenever they submit a contact form. Then we send a message to our sales team in Slack, notifying them that one of our customers has reached out to us.
How will you use this Contact Form 7 and Google Sheets integration? Let us know in the comments section below.