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