00 Days
00 Hrs
00 Mins
00 Secs
Expired
Get a flat 19% discount today. Use Coupon Code
OFFEREND19

How to make Elementor Google Sheets Connection?

elementor google sheet

Looking to send leads from Elementor Form to Google Sheets or want to create an Elementor Google Sheets connection within a minute? Actions Pack makes it easy to create front-end Elementor forms to collect information from your leads.

With Actions Pack, you can create an unlimited number of forms in easy and simple steps. Create a form for your campaign using Elementor Pro’s default form widget, select Google Sheet from available actions, enter your Google Spreadsheet API credentials, and start collecting leads quickly.

In this post, I will show you step by step how to integrate Google Sheets with your Elementor Pro Form in 1 min.

Things You Need to Connect Elementor to Google Sheets

To follow this tutorial to integrate Google Sheets to your Elementor Forms, you’re going to need a few things:-

  1. Elementor Pro – You need the Elementor Pro plugin. Because you are going to use the power of Elementor’s native form widget.
  2. Actions Pack – Unlike Zapier’s monthly subscription, You need to purchase the Actions Pack plugin only once. Actions Pack creates a bridge between your Elementor Form and Google Spreadsheet
  3. Spreadsheet – Assuming you already have a Google account, you must have created a Spreadsheet or may create a new one here. Alternatively, if you want to send your leads to another spreadsheet that your colleague has already created, then ask him/her to share it with you. Just make sure that your Google Account has the access to that spreadsheet.
  4. Spreadsheet API Credentials – To allow Actions Pack write data into your Spreadsheet on behalf of you, you need to enter the Google Spreadsheet API credentials in Actions Pack settings that we will discuss in later in this article.

1. Create Your Lead Capture Form

To get started you need to create a form using Elementor Pro’s Form widget. You have few options here, you may create your lead capture form on a page or popup or may place the Elementor template shortcode on an existing page.

Drag and drop Elementor’s form widget to your page or popup. Create as many fields as you want.

2. Select Google Sheet in Actions After Submit

Screenshot 2020 09 20 at 5.25.23 AM

Once you’ve designed your form, select Google Sheet in Actions After Submit settings. This is what lets you connect your form to Google Sheets.

3. Configure Google Sheet Action

configure google sheet action

As soon as you select Google Sheet in Actions After Submit, you will be able to see all settings as shown in the image above.

First, you need to configure API Credentials. You have two options here.

  1. Default Source – If you select the default source, you need to set the API credentials here /wp-admin/admin.php?page=elementor#tab-integrations. This is one time and can be used for all the forms. It is recommended to use the default source.
  2. Custom Source – If you select custom source, you can set credentials for each form you created.

3.1 Where to get Client Id & Client Secret?

create google sheet client id secret 2

To get API client Id and Client Secret you need to Enable Google Sheet API here. Then enter a project name as you wish. Select Web Server and enter the URI http://yoursite.com/wp-admin/admin-ajax.php in the Authorised redirect URI input field.

3.2 Establish Elementor Google Sheets Connection

google sheet api authentication

After you copy and paste the Client ID and Secret, you need to click on the Validate Credentials button once. If everything is correct, you are good to go. You will see a green checkmark and your Elementor Google Sheets connection is successful. Don’t forget to click on the Save Changes button that in the bottom of that page.

3.3 Enter your Spreadsheet Details

google sheet url

In this step, you need to enter your Google Sheet Details. Copy the entire spreadsheet URL where you want to send your form data and paste it inside the Spreadsheet URL input field. You can also enter ant individual sheet name E.g Sheet1 or Sheet2. Just keep in my mind you need to enter the exact name as it is in your Google Spreadsheet page. Also if you rename your sheet in the future you need to update the same here.

3.4 Map Elementor Form Fields with Google Sheet Columns

elementor google sheets field mapping

Now you need to perform field mapping between your Elementor form fields and columns of your Google Sheet. In layman’s term, you have to explicitly tell Actions Pack, which field’s data should go to which column in your Google Sheet.

Conclusion

Once you are done with your field mappings, you are ready to test your lead capture form and send data from your Elementor’s form to Google Sheet.

With Actions Pack Addon, it’s easy to create lead generation forms that connect to Google Sheets. It is faster or quicker. Neither you need to depend on other API service providers like Zapier nor you have to pay a monthly subscription for a limited number of leads collection. Actions Pack provides you the freedom to create an unlimited number of leads collection.

To get started, purchase Actions Pack and then follow the steps in this tutorial to set up the Elementor Google Sheets Integration.

Do you have any additional questions about how to connect Elementor to Google Sheets? Ask below in the comments section!

Table of Contents

2 Responses

    1. That is a nice question. The major differences are performance and price. Zapier is too costly and you need to pay a monthly fee. Here you pay one time that is also half of the Zapier’s monthly fee. With Zapier, form creation is limited. With Actions Pack it is completely under your control. You can create unlimited number of Elementor forms and connect it to Google Sheet for each and every campaign.

      Secondly, with Zapier, data process is slow. Because when you submit a form, data from your server goes to Zapier server and then again it goes to Google Server. With Actions Pack data goes directly from user ends to Google server. It is also GDPR friendly.

      With Zapier, you need to integrate it with your Elementor Form each-time you want to connect to Google Sheet. There is no global option. Again and again you need to configure API and all which is a frustrating task I believe. With Actions Pack you just need to configure it once which even takes less than 1 min.

Leave a Reply

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