skip to Main Content

The Best Contact Form 7 and Google Sheets Integration

Uncanny Automator is the best Contact Form 7 and Google Sheets integration. Find out why in this easy how-to guide.

contact form 7 and google sheets integration featured image

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 plugin wordpress download

Contact Form 7 is a purpose-driven plugin that you can get started with for FREE if you haven’t already.

Download Contact Form 7.>>>

Google Sheets

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.

google sheets homepage

All you need to get started with Google Sheets is a FREE Google account.>>>

Uncanny Automator

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?

uncanny automator homepage

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.

Get started with Automator and connect Contact Form 7 to Google Sheets.>>>

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.

automator recipe type selector 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.

contact form 7 integration

From the drop-down list that appears, select A form is submitted.

contact form 7 action 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:

contact form 7 action a form is submitted live

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.)

google sheets integration not connected

After you’ve connected your Google account, a drop-down list will appear. Select Create a row in a Google Sheet.

google sheets action 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.

google sheets integration get columns from google worksheet

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.)

contact form 7 tokens

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:

google sheets values filled in using contact forms 7 tokens

After you’ve filled out all of the fields, click Save. Your action should look like this:

google sheets action create a row in a google sheet live

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.

contact form 7 + google sheets integration store form submission data recipe

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.

contact form 7 + google sheets integration crm and sales recipe

How will you use this Contact Form 7 and Google Sheets integration? Let us know in the comments section below.

Avatar photo

Brendan Da Costa is a WordPress content writer with a Shakespearean-level gift of gab (his words, not ours). He left a successful career in economics to pursue his passion for writing and discovered the wonderful world of WordPress while building his own website to showcase his work. As a self-taught enthusiast who spends more time tinkering with plugins and themes than he would care to admit, Brendan writes equally for WordPress beginners and veteran developers alike. With his unique blend of expertise and creativity, he continues to elevate the digital landscape one WordPress article at a time.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This page may contain affiliate links. Once in a while, we may earn a commission from those links. But with or without commissions, we only recommend products we like.
Back To Top