Last modified: September 26, 2015

With the help of Formidable Pro, you can, not only store entries data in WordPress database but also you can send it to 3rd party data storage services such as Google Docs, Google Contacts, Google Drive and even Google Spreadsheet etc. However, it is not a built-in functionality of the plugin and it can trigger two action by default when someone submits a form;

  • sending a form entry to email (optional)
  • sending a form entry to WordPress Database

If you want to add an action to send created form entry to any other external data-storage  application such as Google Spreadsheet, you need to install free Zapier addon for Formidable Pro. This addon will generate an API key for you, that will be used to connect to external applications. Zapier uses this API key to trigger an action to send submitted form data to many other Zapier compatible applications.

In this tutorial, we will learn how to use Zapier to gather form entries to Google Spreadsheet or any other compatible application (available in Zapier database).

Step first – Install Formidable Pro Zapier addon

  • Access you Formidable Pro account and download add-on from add-ons section
  • Install and activate the plugin

Step two – Create a Zapier account

Open Zapier.com and create a free account (free plan is available with limited usage)

Step three – Click on Make a Zap

  • Here you will see two sections;
  • Choose an app to trigger an action (choose Formidable Pro) – choose a target app (choose Google Spreadsheet)
  • Set trigger New formidable Pro Entry  to Create a Google Spreadsheet Row

Formidable Pro to Google Spreadsheet Row

 

  • Then, Zapier will ask you to connect to your Formidable Pro account.

Adding Formidable Pro account to Zapier

 

Step 4 – Connect your Formidable Pro API key and website to Zapier

  • get back to your WordPress dashboard > Formidable Pro > Global settings > Api
  • copy your Formidable Pro api key and add it to Zapier
  • add the exact URL of your WordPress website
  • and click on Continue
      Zapier will verify your

Formidable Pro

    account and if successful, it will be added to Zapier.

Step 5 – Connect your Google Spreadsheet account to Zapier

  • After that, you need to connect to your Google Spreadsheet account (login to your Google account in a separate tab and create a new spreadsheet using this URL > Create a new spreadsheet > Add one field name of your form per column)
  • Zapier will ask you to permit to access to your Google account. Let it connect.

Step 6 – Linking Google Spreadsheet with your Formidable Pro form

  • On connecting to Google Spreadsheet account, Zapier will ask you to choose a form from dropdown list.

4512

  • Select the desired form and click the “continue” button
  • Now select the Google Spreadsheet from the dropdown

 

Selecting Google Spreadsheet in zapier1

  • On selecting the spreadsheet, Zapier will ask you to connect form fields to same named columns of the spreadsheet (created by us formerly)

3463

 

Step 7 – Finishing up the operation

Zapier will ask you to create a test entry in your form, and then it will investigate whether it is accessing newly created data or not. If it successfully accessed the new entry created, it will post your entry to spreadsheet connected to your Formidable Pro form.
Switch to Google Spreadsheet tab of your browser and you will find that your test entry is added to the spreadsheet.

That’s all.

About Shams

Shams, a professional blogger, has expertise in WordPress and Web Hosting. He is used to playing around with WordPress plugins, themes, web hosting services and some other innovative stuff regarding web design. He sifts out good stuff for web designers and reviews it to help them choose what they really need.

Being an energetic tech enthusiast, he regularly pens down breaking news and tutorials related to technology particularly Smartphones and other gadgets. Sometimes writes tech tips too. It was the dawn of Internet age when he started dabbling in it and has since been delving into the realm of the internet. He occupies a permanent burrow in virtual world.

He can be reached at.- here

Related Post

Increase more than 700% of Email Subscribers!
Dolor aliquet augue augue sit magnis, magna aenean aenean et! Et tempor, facilisis cursus turpis tempor odio. Diam lorem auctor sit, a a? Lundium placerat mus massa nunc habitasse, arcu, etiam pulvinar.
  We hate spam and never share your details.
Blogging and Web Design
GET IT NOW
500% MORE SUBSCRIBERS
EFFICIENCY
BOOST YOUR SALES
CREATIVITY
INSPIRE YOUR VISITORS
BE UNIQUE
CREATE UNIQUE POPUPS
Get amazing content to your mailbox
We never bother our subscribers and, we deliver what they want
Your Information will never be shared with any third party.
You are successfully subscribed to webcusp newsletter. Please check your mail and confirm your subscription.
Subscribe for Updates
We never bother our subscribers and, we deliver what they want
Your Information will never be shared with any third party.
You are successfully subscribed to webcusp newsletter. Please check your mail and confirm your subscription.
Follow us for exclusive content