In case you need to come back again, you can bookmark this page with Ctrl + D or Cmd + D.

In case you need to come back, you can bookmark this page with the Share Icon on your phone.

Connect Elementor Forms To Google Sheets Without Zapier Or Coding

Written by Cylas Tee, on August 10, 2022
Elementor Forms To Google Sheets Connector Featured Image
Elementor Forms To Google Sheets Connector Featured Image

If you have been using Elementor Forms for your client work, you will probably at some point need to connect Elementor Forms to Google Sheets to collect customer data.

After doing your research, you will also find out that the only way people are recommending: is to use Zapier to connect your forms to Google Sheets. Either that, or it's likely some solutions that involves certain about of coding.

In this article, I will show you how you can connect your Elementor Forms to Google Sheets another way - with no coding or Zapier subscription needed, so that you don’t need to be rich or a coding techie to get it working.

We all know that Zapier cost A LOT! It’s either USD 240 when billed annually or USD 29 per month, which is totally not worth it if the only thing you want to do is to connect your form to Google Sheets.

The way I usually use to connect Elementor Forms to Google Sheets involves the use of a plugin, which is also the way I always use for all of my clients - with Piotnet Addons For Elementor Pro.

What is Piotnet Addons For Elementor Pro?

Piotnet Addons For Elementor (PAFE) is just another extension or feature library for Elementor. Inside Piotnet Addons, there’s Google Sheets Connector feature that allows you to connect Elementor Native Form to Google Sheets.

The Google Sheets Connector feature from Piotnet Addons had saved me hundred of dollars in subscription from Zapier, and it's now my go to solution whenever a client needs to connect their Elementor Forms to Google Sheets.

How To Connect Elementor Forms To Google Sheets

1. Download & Install Piotnet Addon For Elementor (PAFE) Plugin

Piotnet Addons For Elementor Pro Home Page

The first thing you need to do would be to download the PAFE plugin. The PAFE plugin comes in both single site yearly license or an unlimited lifetime license.

If you are managing multiple Elementor websites, I would highly recommend getting the lifetime license. Not only you are getting the Google Sheets Connector that will save you tons of monthly subscription, you are also getting multiple PAFE feature that you might find useful, like form builder, conditional logic, multistep form and even form abandonment.

2. Add Your Google Sheets Integration Key In Piotnet Setting

Piotnet Addon Client ID Settings

After installing and activating the PAFE plugin, you would need to add a Google Sheets Integration Key in the Piotnet Settings Page. This is to allow Piotnet to communicate to your worksheet to read the mapping and write the necessary data.

If you are having trouble finding this settings page, the page is located at:

Dashboard > Piotnet Addons > Settings > Integration > Google Sheets Integration > Enter Google Sheets Integration API Key > Save Setting.

In order to integrate to Google Sheets, we would need to add the Client ID and Client Secret from your Google Account, this requires us to enable the Google Sheets API from your Google Account in the next step.

3. Enable The Google Sheets API From Google Account

Piotnet Addons - Create Credentials In Google Console

To enable the Google Sheets API, you would need to go to your developer console dashboard at the following link.

From the console dashboard, you would need to do a few things.

The first thing you need to do is to create a new project (Unless you already have one). Only after you have a project selected, you can look for Google Sheets API from the API Library, and click enable to activate the feature.

Once you have enabled the Google Sheets API, you can go back to the dashboard, then select “Credentials” to create a new “OAuth client ID”. The completion of this step will provide you with the Client ID and Secret you need to complete the Elementor to Google Sheets integration.

I understand that this might be slightly more complicated that it sounds, so if you need more specific instructions, you can see PAFE’s very own documentation from this page here.

4. Complete Google Sheets Integration With Client ID and Client Secret

At this point, the hardest part is out of the way. With your Client ID and Client Secret, you can complete the Elementor to Google Sheets Integration from the Piotnet Settings page.

All you need is to paste both Client ID and Client Secret, then click Authorize. A typical google permission dialog will appear, and all you need to do is to approve the access required by Piotnet.

5. Enable Google Sheets Connector In Your Form

Elementor Forms Google Sheet Connector Widget

Now that all the configurations is done, you will need to go back to your form inside the Elementor Editor. A “PAFE Form Google Sheets Connector” Control should appear in your side panel when you select your form. If you cannot find this control, make sure you have activated and enable it from the Piotnet Plugin settings.

6. Configure And Test Your Elementor To Google Sheets Connector

You are all done!

All you need to do next is to enter your Google Sheets ID, Worksheet Tab Name and populate the mapping between the Elementor Form Fields to the Google Sheets Columns.

Once all of those are set, your integration should be working fine, and you would see data appearing in your Google Sheets when you submit your form.

Bonus: Why You Should Use Piotnet Addons For Your Elementor Forms?

I know you might be thinking twice before purchasing the PAFE license, but trust me when I say that all of my Elementor sites now have PAFE installed due to the variety of features it provides.

It covers all of the most important features that Elementor lacks, from column links, to form builder, to Google Sheets Connector. And if the Google Sheets Connector is not enough, let me introduce you to the Form Abandonment feature.

Enabling the Form Abandonment feature will allow you to collect the leads form input even before he completes the form. This allows you to collect their email and retarget them even when they abandon the form halfway. If that’s not valuable enough, I am not sure what else is.

Give PAFE a go, you will not regret it.

Conclusion

That should be all!

If you follow the guide or the documentation step by step, you should not face any problems connecting your forms to Google Sheets. If you have any questions, feel free to leave a comment.

Have a nice day!

Affiliate Disclaimer: Keep in mind that we may receive commissions when you click our links and make purchases. However, this does not impact our reviews, recommendation and style of writing. We try our best to keep things fair and balanced, in order to help you make the best choice for you.
Share This Post:
Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
Cylas Tee Thumbnail Image
About Cylas Tee
With over a decade of experience, Cylas Tee is a Digital Marketing Specialist on a mission to help Personal Brands build, grow and scale their online business.
RECENT POST
Russell Brunson Perfect Webinar Slides - How To Get It?
Two Comma Club Roadmap: Join The Two Comma Club Today!
Lead Funnels - What It Is & How To Create An Amazing Funnel
All Of Russell Brunson's Best Books, Courses, Resources & Live Events (Updated Weekly)
Infinitus Members Registration: How To Become An Infinitus Member (All Countries)
BEST ELEMENTOR ADDON
Piotnet Addons For Elementor
Contains most additional advanced features that's not included in Elementor Pro.
LEARN MORE
3 Shares
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram