Formidable Forms

Formidable Forms

  • Features
  • Pricing
  • Blog
  • Support
  • Login
  • Get Formidable Forms

Formidable Team / Last Updated December 9, 2021

How to Send WordPress Forms to Google Sheets

Now you can seamlessly integrate form data with a spreadsheet. This impromptu backup system can be set up fast and won't cost you anything but a few minutes of time!

How to send WordPress Forms to Google Sheets

There are a few common reasons why businesses need to export form entries to a spreadsheet. The most common one is to simply back-up your data, something that we'd recommend all businesses do regularly!

Besides backing up data, you might also want to use form entries for other purposes. Having them in a handy spreadsheet means you could do more with them. For example, if you create a online registration form, you could collect contact details in a spreadsheet to make it easier to schedule follow-up calls in the future.

Formidable Forms is the best WordPress Form Builder plugin. Get it for free!

The problem is that transferring all the information you need from one app to the other can be incredibly time-consuming. It's also prone to human error (no matter how careful you are) and this could spell disaster if there are missing entries or typos messing everything up.

Surely there's an easier way of transferring the information you need between two apps?

This calls for the number one modern solution: automation. The beauty of automation is that it removes the time, hassle and errors caused by manually handling data. Why spend all that time manually backing everything up when it can all be handled automatically?

Today we'll be taking you through how to set up a Google Sheets data entry form. But first, let's introduce you to the brilliant app we'll be using throughout.

Uncanny Automator: A simple way to integrate your favorite plugins

Uncanny Automator is a free WordPress plugin that gets data from WordPress forms to Google Sheets. It allows you to connect the best WordPress plugins and apps to automate workflows. It's like Zapier, but works natively inside of WordPress. It offers free credits, just like Zapier, but after the credits are gone, you'll save loads by skipping Zapier. Who couldn't use a plugin like that?

They have more than 75 apps available to connect, including Slack, WooCommerce, BuddyPress, social media pages and of course, Google Sheets.

How does it work?

After connecting WordPress forms to Google Sheets (through Automator), a new row will automatically be added to the bottom of a Google Sheet with all the form data. This can be triggered whenever a new entry is received in Formidable. It can even be added conditionally based on a field value in the form.

This saves you from manually exporting your form entries to a CSV and then going into Google Sheets and importing it. Automator works behind the scenes to give back time to you or your client.

For this integration to work, you'll need:

  • The Formidable Forms plugin (the free plugin is fine)
  • A Google account
  • The Uncanny Automator plugin to tie it all together

Step 1: Install Automator and Formidable Forms

First of all, you'll need to install Formidable Forms and Uncanny Automator. Even the free Automator plugin will do.

Once Automator is installed, you'll need to connect to the Automator processing service from inside the plugin. Here, you'll be able to create a free Automator account. Or, if you have the paid version, install that as well and activate it with your license key.

Step 2: Create a recipe for your WordPress site

All the integrations that Automator handles are called recipes. So, for this to work, we'll need to create a recipe that connects Formidable Forms with the app you want to integrate with - in this case Google Sheets.

When you go to the Automator → Add new page, you'll get a choice between Logged-in users and Everyone. In this case, we want every entry submitted in a form to go to Google Sheets. Click Everyone and then Confirm.

WordPress automator logged-in or everyone

Step 3: Select Formidable as the Trigger app

To connect Formidable Forms entries with Google Sheets, you'll need to set a Trigger and an Action. In this case, the Trigger will be Formidable Forms and the Action will be Google Sheets.

This is how the sequence works:

A form is submitted → Creates new form entry → Creates new row in Google Sheets

To choose your Trigger app, click on for Formidable Forms.

Automator triggers from WordPress

This tutorial will also work with any of the best WordPress form plugins, including WPForms, Gravity Forms, and Ninja Forms. But since you're reading this, we're going to assume you already know that Formidable is the most flexible form builder out there and blows away all the rest.

Anyway... So once a form plugin is selected as the trigger, you'll get a list of possible 'triggers' including 'A form is submitted'. Select which one you wish to set up. There is also a trigger available when a logged-in user edits a form, but we are only seeing triggers for everyone.

Select the Google sheets data entry form

Step 4: Select Google Sheets as the Action app

Once you've set your Trigger app, it's time to tell it what to do with the form data. Setting up your Action app is pretty much the same.

Once you select the Google Sheets action, you'll be walked through the quick process of connecting Automator to Google. Next, you'll again be given a list of options. Select the option to Create a Row in a Google Sheet.

When you've selected your Trigger and Action apps, you'll now need to select the spreadsheet you want to link. This is where the new data will be directed.

WordPress forms to Google Sheets mapping

Go ahead and click the Get columns button to fetch the existing columns in the spreadsheet. You can now map your form fields to specific fields in the spreadsheet.

For example, with contact form sign ups, you'll want to match 'First Name' to the 'First Name' column on your Google spreadsheet. You can do this in Automator once your Google account and spreadsheet has been selected.

With that, you're all set up. Go ahead and submit a test entry just for the thrill of seeing it show up in the Google Sheet.

Wrapping up

Well that was easy! This is such a simple integration that can save you tons of valuable time and effort. Remember, this is just one of a huge range of integrations that run through Uncanny Automator. Once little things like data entry have been automated, you can get back to doing something more worth your time, like growing your business in new ways.

Read more about WordPress automation

  • How to Connect a Pipedrive Form to WordPress How to Connect a Pipedrive Form to WordPress
    Read More
    How to Upload Files to Dropbox from Your WordPress Forms How to Upload Files to Dropbox from Your WordPress Forms
    Read More
    How to Create ActiveCampaign WordPress Forms How to Create ActiveCampaign WordPress Forms
    Read More

Using WordPress and want to get Formidable Forms for free?

Get Formidable Forms Lite Now

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

Comments

  1. RGerhart says

    April 27, 2019 at 4:23 pm

    Is there a way to do this without using Zapier? I don't like to have an intermediary outside of my control for transferring vital information. That is why I so far hesitated to use Formidable functions which depend on Zapier. I don't want to involve a third party in a for my company essential process.

    Reply
    • Kara Copple says

      April 29, 2019 at 6:09 am

      You could manually export form data as a CSV file and then move it across to Google sheets. But it'd take longer of course, which is why we recommend using Zapier.

      Reply
  2. Antonio Almeida says

    November 10, 2019 at 1:48 am

    I thought a native integration was coming out between FP and GS. There was a 3rd party add-on in the past that said they sold the code to you. Is still on the radar or did you abandoned the idea?

    Reply
    • Ki Lee says

      August 7, 2020 at 12:28 pm

      +1 to this question!

      Reply
      • Abby Buzon says

        August 16, 2020 at 6:36 pm

        Another +1 to this question.

        Reply
        • Ryan Cordoni says

          August 17, 2020 at 10:12 pm

          Hi everyone, thanks for reaching out. We didn’t realize this was still on your radar, but we’ll make sure to look into it a bit more.

          Reply
  3. Farhan says

    November 3, 2020 at 6:39 pm

    Hi, is it possible to retrieve the entries sent to Google Sheet and display (view) it back in the wordpress?

    Reply
    • Steve Wells says

      November 5, 2020 at 1:31 pm

      Hi Farhan,
      It sounds like you are referring to a two-way sync between Google Sheets and your form entries. Doing this automatically isn't currently supported, but you could manually import spreadsheet values into WordPress form entries using the CSV Import feature.

      Reply
  4. Richard Wells says

    January 20, 2021 at 2:37 pm

    There is an alternative to Zapier, if you want to pull WordPress stats data to Google Sheets. I myself been looking for an easier tool to use and found Coupler.io that can synchronize your WordPress data with Google Sheets on a set schedule. And there is no need to buy it in order to try how it works

    Reply

Leave a Reply Cancel reply

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

Get Email Updates

Popular Resources

    • How to Create a Searchable Database on a WordPress Site
    • Create a Calculator in WordPress: Easy, Powerful Results
    • How to Create a Fitness Tracker in WordPress
    • Formidable Views: The Best WordPress Custom Application Plugin
    • How to Require Email to Download Files in WordPress
    • How to Create Conditional Drop Down Lists in WordPress Forms
    • The Best Gravity Forms Alternative: Formidable Forms vs Gravity Forms
    • How to Make a Quiz in WordPress
    • WPForms Alternative: Formidable Forms vs WPForms Compared

Take on bigger projects Right Now

Get the tools you need to revolutionize your workflow and architect a masterpiece. Build the most advanced WordPress forms and actually use the data you collect in meaningful ways.

Get the most advanced WordPress form plugin and the only form builder with integrated Views.

Get Formidable Forms Now

Resources

  • Community
  • Affiliates
  • Contact
  • Free Online Form Builder

Top Features

  • Application Builder
  • Calculator Forms
  • Surveys & Polls
  • Quiz Maker
  • Form Templates
  • Application Templates
  • Directories
  • Donation Plugin

Company

  • About Us
  • Giving Back
  • Careers
  • Newsletter
  • Blog

Copyright © 2022 Strategy11, LLC. Formidable Forms® is a registered trademark Strategy11, LLC.
Privacy Policy | Terms of Service | Sitemap

Join 300,000+ using Formidable Forms to create form-focused solutions fast. Get Started See User Reviews