The below article will explain how to connect Elementor to Google Sheets, to automatically load leads or responses from Elementor forms into a Google Sheet.


What do you need?

To connect Elementor to Google Sheets you need:

  • A Zapier account – you can register for a free account, though you might need to pay depending on how many leads you plan to collect. 
  • Google Sheets access – if you have a Google account, you already have access to Google Sheets. 


Connecting Elementor & Zapier


  1. Create your Elementor lead form (this is already created by OHM)

  2. Create a Zap in Zapier and Set Up Trigger


Now, without closing the Elementor interface, open another tab and go to Zapier’s website. 

Then, click Make a Zap in the top-right corner:


This will open the Zapier editor.

In the Choose App & Event box, search for and select Webhooks by Zapier.

Then, in the Choose Trigger Event box, select Catch Hook.


Click Continue to advance.

3. Add Zapier Webhook URL to Elementor and Test Connection

Once you click Continue, Zapier should give you your own Custom Webhook URL:


Copy this value and then send it to the OHM team. 

After that we will add the value to the form and send some test data. Once we have done that we will inform you and you need to go back to the Zapier editor and click Continue to advance to the next step. You should see an option to Test & Review:


When you click that, you should see the data from the Elementor form that you just submitted:


If all looks good, click Done Editing to advance to the next step.

4. Set Up Action in Zapier

At this point, you’ve set it up so that Elementor will automatically forward new form submissions to Zapier. Now, you need to tell Zapier to add that data to Google Sheets.

First, you need to create the actual spreadsheet to hold your leads. 

To do that, open Google Sheets and create a new spreadsheet. You can set up column headings for all the information that you want to collect about your leads (this should include all the fields from your Elementor form). You can also add extra columns for additional information, like the page where someone submitted your lead capture form or the date:


Then, go back to the Zapier interface.

In the Do this box, search for and select Google Sheets. Then, in the Choose Action Event box, select Create Spreadsheet Row. This tells Zapier to add a new row to the spreadsheet for each new form submission in Elementor:


Then, click Continue. On the next screen, you’ll be prompted to sign in to Google Sheets and give Zapier access. This uses the standard Google authority process.

Once you’ve added your Google Sheets account, click Continue to advance:


Now, you need to select the spreadsheet to add information to:

  • Drive – select your Google Drive account.
  • Spreadsheet – select the spreadsheet that you created a moment ago.
  • Worksheet – select the worksheet within that spreadsheet (usually, you can just leave this as the default).

Then, you need to map the information from the Webhook to the columns in your spreadsheet. This includes your Elementor form fields, as well as any other information that you want to collect.


Once you’ve mapped all the information, click Continue to finish things off. Zapier will then prompt you to run another test:


And if everything went well, you should see the test data that you submitted via your Elementor form in Google Sheets:


To finish things off, all you need to do is turn on your Zap:


And that’s it! You just successfully connected Elementor to Google Sheets using Zapier.