{"id":37830,"date":"2020-04-20T12:31:28","date_gmt":"2020-04-20T12:31:28","guid":{"rendered":"https:\/\/elementor.com\/blog\/?p=37830"},"modified":"2020-04-20T12:31:28","modified_gmt":"2020-04-20T12:31:28","slug":"connect-elementor-to-google-sheets","status":"publish","type":"post","link":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/","title":{"rendered":"How to Connect Elementor to Google Sheets to Collect Leads"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"37830\" class=\"elementor elementor-37830\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-958a04b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"958a04b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5c85adc\" data-id=\"5c85adc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6e878d4 elementor-widget elementor-widget-text-editor\" data-id=\"6e878d4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If you&#8217;re looking to generate leads on your WordPress site, the Form widget in <a href=\"https:\/\/elementor.com\/pro\/\" target=\"_blank\" rel=\"noopener\">Elementor Pro<\/a> makes it easy to create front-end forms to collect as much or as little information as needed from your leads.<\/p><p>Once you&#8217;ve done that, though, you need a way to organize and manage those leads after they&#8217;ve submitted your form.<\/p><p>The Form widget gives you plenty of options \u2014 you can connect directly to <a href=\"https:\/\/elementor.com\/features\/integrations\/\" target=\"_blank\" rel=\"noopener\">several email marketing\/CRM services<\/a>, or you can use Zapier to connect to the thousands of apps that are available on Zapier.<\/p><p>In this post, I&#8217;m going to show you how to connect <a class=\"wpil_keyword_link\" href=\"https:\/\/elementor.com\/\"   title=\"Elementor\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"911\">Elementor<\/a> to one specific app using Zapier &#8211; Google Sheets.<\/p><p>Google Sheets is a super simple (and free) way to manage leads. Plus, because most of us are familiar with working on spreadsheets, it&#8217;s easy to get up and running, and you&#8217;ll feel right at home when managing your leads.<\/p><p>Keep reading for a step-by-step guide on how to connect Elementor to Google Sheets to automatically add new leads as rows in your spreadsheet.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fa7208c elementor-widget elementor-widget-heading\" data-id=\"fa7208c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">What You Need to Connect Elementor to Google Sheets\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ef467d elementor-widget elementor-widget-text-editor\" data-id=\"0ef467d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>To follow this tutorial and connect Elementor to Google Sheets, you&#8217;re going to need a few things:<\/p><ul><li><strong>Elementor Pro<\/strong> &#8211; you need <a href=\"https:\/\/elementor.com\/pro\/\" target=\"_blank\" rel=\"noopener\">Elementor Pro<\/a> to access the <a href=\"\/help\/form-widget-pro\/\" target=\"_blank\" rel=\"noopener\">Form widget<\/a> and <a href=\"https:\/\/elementor.com\/help\/zapier-elementor-integration\/\" target=\"_blank\" rel=\"noopener\">Zapier integration<\/a>. Zapier is what lets you connect to Google Sheets, so this is essential.<\/li><li><strong>A Zapier account<\/strong> &#8211; you can <a href=\"https:\/\/zapier.com\/sign-up\/\" target=\"_blank\" rel=\"noopener\">register for a free account<\/a>, though you might need to pay depending on how many leads you plan to collect. No matter what, you can follow the tutorial for free.<\/li><li><strong>Google Sheets access<\/strong> &#8211; if you have a Google account, you already have access to Google Sheets. You can <a href=\"https:\/\/docs.google.com\/spreadsheets\/u\/0\/\" target=\"_blank\" rel=\"noopener\">open the dashboard here<\/a>.<\/li><\/ul><p>Once you have those three things, here&#8217;s a high-level look at the steps that you&#8217;ll follow in the tutorial:<\/p><ol><li>Create your Elementor lead form<\/li><li>Set up a Zapier Webhooks trigger<\/li><li>Connect Webhooks to your Elementor Form<\/li><li>Add your Google Sheets action in Zapier and map form fields to columns in your spreadsheet<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-371623a elementor-widget elementor-widget-heading\" data-id=\"371623a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">How to Connect Elementor to Google Sheets\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6c65d3d elementor-widget elementor-widget-heading\" data-id=\"6c65d3d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">1. Create Your Lead Capture Form\n<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b90aa64 elementor-widget elementor-widget-text-editor\" data-id=\"b90aa64\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>To get started, you need to create your lead capture form using the Form widget in Elementor Pro.<\/p>\n<p>You have a few options here. You can:<\/p>\n<ul>\n<li><a href=\"https:\/\/elementor.com\/blog\/create-wordpress-landing-page\/\">Create a dedicated landing page<\/a> that includes the Form widget.<\/li>\n<li>Create a popup that contains the Form widget and display it anywhere on your site using <a href=\"https:\/\/elementor.com\/features\/popup-builder\/\" target=\"_blank\" rel=\"noopener\">Elementor Popup Builder<\/a>.<\/li>\n<li>Add a form to an existing page <a href=\"https:\/\/elementor.com\/help\/embed-templates-anywhere-pro\/\" target=\"_blank\" rel=\"noopener\">using a template and its shortcode<\/a>.<\/li>\n<\/ul>\n<p>No matter which method you choose, the setup steps will be the same because all of the configuration happens within the Form widget&#8217;s settings.<\/p>\n<p>As long as you&#8217;re using the Form widget in Elementor Pro, you&#8217;ll be able to sync up with Google Sheets. It doesn&#8217;t matter where you display the Form widget.<\/p>\n<p>For this example, I&#8217;ve created a popup that contains the Form widget. In the form, I&#8217;ve set up three fields for:<\/p>\n<ul>\n<li>First name<\/li>\n<li>Last name<\/li>\n<li>Email address<\/li>\n<\/ul>\n<p>You can add as many (or as few) fields as needed, though. Later on, you&#8217;ll be able to map all of the fields to columns in your Google Sheets spreadsheet:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cedbecb elementor-widget elementor-widget-image\" data-id=\"cedbecb\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"434\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=434\/blog\/wp-content\/uploads\/2020\/04\/popup-with-form-widget-1024x555.png\" class=\"attachment-large size-large wp-image-37841\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/popup-with-form-widget-1024x555.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/popup-with-form-widget-300x163.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/popup-with-form-widget-768x417.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/popup-with-form-widget-1536x833.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=2002\/blog\/wp-content\/uploads\/2020\/04\/popup-with-form-widget.png 2002w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b33d3d0 elementor-widget elementor-widget-text-editor\" data-id=\"b33d3d0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Once you&#8217;ve set up your form, go to the <strong>Actions After Submit<\/strong> settings in the <strong>Content<\/strong> tab of the form&#8217;s settings. Then, add an action for <strong>Webhook<\/strong>. This is what lets you connect your form to Zapier (and subsequently Google Sheets).<\/p><p>Once you add the Webhook action, you should see a new settings area for <strong>Webhook<\/strong>. Keep this handy because you&#8217;ll need to use it in the next steps:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4f414e0 elementor-widget elementor-widget-image\" data-id=\"4f414e0\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"523\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=523\/blog\/wp-content\/uploads\/2020\/04\/webhook-settings-1024x669.png\" class=\"attachment-large size-large wp-image-37842\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/webhook-settings-1024x669.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/webhook-settings-300x196.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/webhook-settings-768x502.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/webhook-settings-1536x1004.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1665\/blog\/wp-content\/uploads\/2020\/04\/webhook-settings.png 1665w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6cdcb3b elementor-widget elementor-widget-heading\" data-id=\"6cdcb3b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2. Create a Zap in Zapier and Set Up Trigger\n<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3ef7503 elementor-widget elementor-widget-text-editor\" data-id=\"3ef7503\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Now, without closing the Elementor interface, open another tab and go to Zapier&#8217;s website.\u00a0<\/p><p>Then, click <strong>Make a Zap<\/strong> in the top-right corner:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be8b4b8 elementor-widget elementor-widget-image\" data-id=\"be8b4b8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"541\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=541\/blog\/wp-content\/uploads\/2020\/04\/make-a-zap-1024x693.png\" class=\"attachment-large size-large wp-image-37843\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/make-a-zap-1024x693.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/make-a-zap-300x203.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/make-a-zap-768x520.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/make-a-zap-1536x1039.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1986\/blog\/wp-content\/uploads\/2020\/04\/make-a-zap.png 1986w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-42a6197 elementor-widget elementor-widget-text-editor\" data-id=\"42a6197\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>This will open the Zapier editor.<\/p><p>In the <strong>Choose App &amp; Event<\/strong> box, search for and select <strong>Webhooks by Zapier.<\/strong><\/p><p>Then, in the <strong>Choose Trigger Event<\/strong> box, select <strong>Catch Hook.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-40ba8ac elementor-widget elementor-widget-image\" data-id=\"40ba8ac\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"523\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=523\/blog\/wp-content\/uploads\/2020\/04\/catch-hook-1024x670.png\" class=\"attachment-large size-large wp-image-37844\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/catch-hook-1024x670.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/catch-hook-300x196.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/catch-hook-768x502.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/catch-hook-1536x1005.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=2006\/blog\/wp-content\/uploads\/2020\/04\/catch-hook.png 2006w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-564562e elementor-widget elementor-widget-text-editor\" data-id=\"564562e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Click <strong>Continue<\/strong> to advance.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a208a56 elementor-widget elementor-widget-heading\" data-id=\"a208a56\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">3. Add Zapier Webhook URL to Elementor and Test Connection\n<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-951c6cc elementor-widget elementor-widget-text-editor\" data-id=\"951c6cc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Once you click <strong>Continue<\/strong>, Zapier should give you your own <strong>Custom Webhook <a class=\"wpil_keyword_link\" href=\"https:\/\/elementor.com\/blog\/url\/\"   title=\"URL\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"7025\">URL<\/a><\/strong>:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a3100de elementor-widget elementor-widget-image\" data-id=\"a3100de\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"535\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=535\/blog\/wp-content\/uploads\/2020\/04\/custom-webhook-url-1024x685.png\" class=\"attachment-large size-large wp-image-37845\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/custom-webhook-url-1024x685.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/custom-webhook-url-300x201.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/custom-webhook-url-768x514.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/custom-webhook-url-1536x1027.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=2008\/blog\/wp-content\/uploads\/2020\/04\/custom-webhook-url.png 2008w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7708702 elementor-widget elementor-widget-text-editor\" data-id=\"7708702\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Copy this value and then go back to the Elementor interface.\u00a0<\/p><p>Open the <strong>Webhook<\/strong> settings in the Form widget and paste in the Webhook URL that you got from Zapier:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a075035 elementor-widget elementor-widget-image\" data-id=\"a075035\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"563\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=563\/blog\/wp-content\/uploads\/2020\/04\/paste-in-the-webhook-url-1024x721.png\" class=\"attachment-large size-large wp-image-37846\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/paste-in-the-webhook-url-1024x721.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/paste-in-the-webhook-url-300x211.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/paste-in-the-webhook-url-768x541.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/paste-in-the-webhook-url-1536x1082.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1641\/blog\/wp-content\/uploads\/2020\/04\/paste-in-the-webhook-url.png 1641w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-60053b7 elementor-widget elementor-widget-text-editor\" data-id=\"60053b7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Then, save your Elementor design.<\/p><p>Once you publish your Elementor form, open a page that contains your lead capture form, and submit some test data \u2014 you&#8217;ll use this to test if the Zapier connection is working.<\/p><p>Then, go back to the Zapier editor and click <strong>Continue<\/strong> to advance to the next step. You should see an option to <strong>Test &amp; Review<\/strong>:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8102f67 elementor-widget elementor-widget-image\" data-id=\"8102f67\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"482\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=482\/blog\/wp-content\/uploads\/2020\/04\/test-and-review-1024x617.png\" class=\"attachment-large size-large wp-image-37847\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/test-and-review-1024x617.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/test-and-review-300x181.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/test-and-review-768x463.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/test-and-review-1536x925.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=2005\/blog\/wp-content\/uploads\/2020\/04\/test-and-review.png 2005w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f592f15 elementor-widget elementor-widget-text-editor\" data-id=\"f592f15\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>When you click that, you should see the data from the Elementor form that you just submitted:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-676cdf9 elementor-widget elementor-widget-image\" data-id=\"676cdf9\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"505\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=505\/blog\/wp-content\/uploads\/2020\/04\/check-data-from-elementor-form-1024x646.png\" class=\"attachment-large size-large wp-image-37848\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/check-data-from-elementor-form-1024x646.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/check-data-from-elementor-form-300x189.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/check-data-from-elementor-form-768x484.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/check-data-from-elementor-form-1536x969.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1980\/blog\/wp-content\/uploads\/2020\/04\/check-data-from-elementor-form.png 1980w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41b4fcf elementor-widget elementor-widget-text-editor\" data-id=\"41b4fcf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If all looks good, click <strong>Done Editing<\/strong> to advance to the next step.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ec5205 elementor-widget elementor-widget-heading\" data-id=\"0ec5205\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">4. Set Up Action in Zapier\n<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ad1bea8 elementor-widget elementor-widget-text-editor\" data-id=\"ad1bea8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>At this point, you&#8217;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.<\/p><p>First, you need to create the actual spreadsheet to hold your leads.\u00a0<\/p><p>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).\u00a0<\/p><p>You can also add extra columns for additional information, like the page where someone submitted your lead capture form or the date:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7ffcd2e elementor-widget elementor-widget-image\" data-id=\"7ffcd2e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"413\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=413\/blog\/wp-content\/uploads\/2020\/04\/create-spreadsheet-1024x529.png\" class=\"attachment-large size-large wp-image-37849\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/create-spreadsheet-1024x529.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/create-spreadsheet-300x155.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/create-spreadsheet-768x397.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/create-spreadsheet-1536x794.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=2000\/blog\/wp-content\/uploads\/2020\/04\/create-spreadsheet.png 2000w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-83dd66b elementor-widget elementor-widget-text-editor\" data-id=\"83dd66b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Then, go back to the Zapier interface.<\/p><p>In the <strong>Do this<\/strong> box, search for and select Google Sheets. Then, in the <strong>Choose Action Event<\/strong> box, select <strong>Create Spreadsheet Row<\/strong>.\u00a0<\/p><p>This tells Zapier to add a new row to the spreadsheet for each new form submission in Elementor:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-776d1b3 elementor-widget elementor-widget-image\" data-id=\"776d1b3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"536\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=536\/blog\/wp-content\/uploads\/2020\/04\/create-spreadsheet-row-1024x686.png\" class=\"attachment-large size-large wp-image-37850\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/create-spreadsheet-row-1024x686.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/create-spreadsheet-row-300x201.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/create-spreadsheet-row-768x514.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/create-spreadsheet-row-1536x1029.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1995\/blog\/wp-content\/uploads\/2020\/04\/create-spreadsheet-row.png 1995w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eb259f9 elementor-widget elementor-widget-text-editor\" data-id=\"eb259f9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Then, click <strong>Continue<\/strong>.<\/p><p>On the next screen, you&#8217;ll be prompted to sign in to Google Sheets and give Zapier access. This uses the standard Google auth process.<\/p><p>Once you&#8217;ve added your Google Sheets account, click <strong>Continue<\/strong> to advance:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c70ec61 elementor-widget elementor-widget-image\" data-id=\"c70ec61\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"559\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=559\/blog\/wp-content\/uploads\/2020\/04\/google-sheets-account-1024x716.png\" class=\"attachment-large size-large wp-image-37851\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/google-sheets-account-1024x716.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/google-sheets-account-300x210.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/google-sheets-account-768x537.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/google-sheets-account-1536x1073.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=2005\/blog\/wp-content\/uploads\/2020\/04\/google-sheets-account.png 2005w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-824f04c elementor-widget elementor-widget-text-editor\" data-id=\"824f04c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Now, you need to select the spreadsheet to add information to:<\/p><ul><li><strong>Drive <\/strong>&#8211; select your Google Drive account.<\/li><\/ul><ul><li><strong>Spreadsheet<\/strong> &#8211; select the spreadsheet that you created a moment ago.<\/li><\/ul><ul><li><strong>Worksheet<\/strong> &#8211; select the worksheet within that spreadsheet (usually, you can just leave this as the default).<\/li><\/ul><p>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.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-228452d elementor-widget elementor-widget-image\" data-id=\"228452d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"752\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=752\/blog\/wp-content\/uploads\/2020\/04\/mapping-information-from-Webhook-to-spreadsheet-columns-1024x963.png\" class=\"attachment-large size-large wp-image-37852\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/mapping-information-from-Webhook-to-spreadsheet-columns-1024x963.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/mapping-information-from-Webhook-to-spreadsheet-columns-300x282.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/mapping-information-from-Webhook-to-spreadsheet-columns-768x722.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/mapping-information-from-Webhook-to-spreadsheet-columns-1536x1444.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=2001\/blog\/wp-content\/uploads\/2020\/04\/mapping-information-from-Webhook-to-spreadsheet-columns.png 2001w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8a2294c elementor-widget elementor-widget-text-editor\" data-id=\"8a2294c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Once you&#8217;ve mapped all of the information, click <strong>Continue<\/strong> to finish things out.<\/p><p>Zapier will then prompt you to run another test:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-24c204e elementor-widget elementor-widget-image\" data-id=\"24c204e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"759\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=759\/blog\/wp-content\/uploads\/2020\/04\/run-another-test-1024x972.png\" class=\"attachment-large size-large wp-image-37853\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/run-another-test-1024x972.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/run-another-test-300x285.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/run-another-test-768x729.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/run-another-test-1536x1459.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=2002\/blog\/wp-content\/uploads\/2020\/04\/run-another-test.png 2002w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e33630 elementor-widget elementor-widget-text-editor\" data-id=\"7e33630\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>And if everything went well, you should see the test data that you submitted via your Elementor form in Google Sheets:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b545008 elementor-widget elementor-widget-image\" data-id=\"b545008\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"364\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=364\/blog\/wp-content\/uploads\/2020\/04\/check-test-email-on-google-sheets-1024x466.png\" class=\"attachment-large size-large wp-image-37854\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/check-test-email-on-google-sheets-1024x466.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/check-test-email-on-google-sheets-300x136.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/check-test-email-on-google-sheets-768x349.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1488\/blog\/wp-content\/uploads\/2020\/04\/check-test-email-on-google-sheets.png 1488w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d568b3d elementor-widget elementor-widget-text-editor\" data-id=\"d568b3d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>To finish things out, all you need to do is turn on your Zap:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f5ac93a elementor-widget elementor-widget-image\" data-id=\"f5ac93a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"535\" src=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=800,h=535\/blog\/wp-content\/uploads\/2020\/04\/turn-on-zap-1024x685.png\" class=\"attachment-large size-large wp-image-37855\" alt=\"\" srcset=\"https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1024\/blog\/wp-content\/uploads\/2020\/04\/turn-on-zap-1024x685.png 1024w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=300\/blog\/wp-content\/uploads\/2020\/04\/turn-on-zap-300x201.png 300w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=768\/blog\/wp-content\/uploads\/2020\/04\/turn-on-zap-768x514.png 768w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=1536\/blog\/wp-content\/uploads\/2020\/04\/turn-on-zap-1536x1027.png 1536w, https:\/\/elementor.com\/cdn-cgi\/image\/f=auto,w=2004\/blog\/wp-content\/uploads\/2020\/04\/turn-on-zap.png 2004w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bbd0ad7 elementor-widget elementor-widget-text-editor\" data-id=\"bbd0ad7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>And that&#8217;s it! You just successfully connected Elementor to Google Sheets using Zapier.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-844fbf2 elementor-widget elementor-widget-heading\" data-id=\"844fbf2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Conclusion\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e0f5cd9 elementor-widget elementor-widget-text-editor\" data-id=\"e0f5cd9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>With the Form widget in Elementor Pro and Zapier, it&#8217;s easy to create lead generation forms that connect to Google Sheets (or any of the other apps on Zapier).<\/p><p>You can set up your spreadsheet so that it meets your business needs and customize all of the information that you collect.<\/p><p>To get started, <a href=\"https:\/\/elementor.com\/pricing\/\" target=\"_blank\" rel=\"noopener\">purchase Elementor Pro today<\/a> and then follow the steps in this tutorial to set up the integration.<\/p><p>Do you have any additional questions about how to connect Elementor to Google Sheets? Ask away in the comments section!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Elementor Forms makes it easy to create front-end forms to collect information from your leads. In this post, we&#8217;re going to show you step-by-step how to connect Elementor to Google Sheets using Zapier.<\/p>\n","protected":false},"author":50988,"featured_media":37831,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[44,36],"tags":[79],"marketing_persona":[51],"marketing_intent":[49],"class_list":["post-37830","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-elementor","category-marketing","tag-build"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Connect Elementor to Google Sheets to Collect Leads<\/title>\n<meta name=\"description\" content=\"Elementor Forms makes it easy to create front-end forms to collect information from your leads. In this post, we&#039;re going to show you step-by-step how to connect Elementor to Google Sheets using Zapier.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Connect Elementor to Google Sheets to Collect Leads\" \/>\n<meta property=\"og:description\" content=\"Elementor Forms makes it easy to create front-end forms to collect information from your leads. In this post, we&#039;re going to show you step-by-step how to connect Elementor to Google Sheets using Zapier.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/elemntor\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-20T12:31:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/oovolzcf.elementor.cloud\/wp-content\/uploads\/2020\/04\/How-to-Connect-Elementor-to-Google-Sheets-to-Collect-Leads_External.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Colin Newcomer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@elemntor\" \/>\n<meta name=\"twitter:site\" content=\"@elemntor\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Colin Newcomer\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/\"},\"author\":{\"name\":\"Colin Newcomer\",\"@id\":\"https:\/\/elementor.com\/blog\/#\/schema\/person\/8df3c6697ea8e60fd1416e98a7ff0e21\"},\"headline\":\"How to Connect Elementor to Google Sheets to Collect Leads\",\"datePublished\":\"2020-04-20T12:31:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/\"},\"wordCount\":1281,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/elementor.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/elementor.com\/blog\/wp-content\/uploads\/2020\/04\/How-to-Connect-Elementor-to-Google-Sheets-to-Collect-Leads_External.png\",\"keywords\":[\"Build\"],\"articleSection\":[\"Elementor\",\"Marketing\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/\",\"url\":\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/\",\"name\":\"How to Connect Elementor to Google Sheets to Collect Leads\",\"isPartOf\":{\"@id\":\"https:\/\/elementor.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/elementor.com\/blog\/wp-content\/uploads\/2020\/04\/How-to-Connect-Elementor-to-Google-Sheets-to-Collect-Leads_External.png\",\"datePublished\":\"2020-04-20T12:31:28+00:00\",\"description\":\"Elementor Forms makes it easy to create front-end forms to collect information from your leads. In this post, we're going to show you step-by-step how to connect Elementor to Google Sheets using Zapier.\",\"breadcrumb\":{\"@id\":\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#primaryimage\",\"url\":\"https:\/\/elementor.com\/blog\/wp-content\/uploads\/2020\/04\/How-to-Connect-Elementor-to-Google-Sheets-to-Collect-Leads_External.png\",\"contentUrl\":\"https:\/\/elementor.com\/blog\/wp-content\/uploads\/2020\/04\/How-to-Connect-Elementor-to-Google-Sheets-to-Collect-Leads_External.png\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\/\/elementor.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Elementor\",\"item\":\"https:\/\/elementor.com\/blog\/category\/elementor\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Connect Elementor to Google Sheets to Collect Leads\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/elementor.com\/blog\/#website\",\"url\":\"https:\/\/elementor.com\/blog\/\",\"name\":\"Elementor\",\"description\":\"Website Builder for WordPress\",\"publisher\":{\"@id\":\"https:\/\/elementor.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/elementor.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/elementor.com\/blog\/#organization\",\"name\":\"Elementor\",\"url\":\"https:\/\/elementor.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/elementor.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/elementor.com\/blog\/wp-content\/uploads\/2025\/06\/images.png\",\"contentUrl\":\"https:\/\/elementor.com\/blog\/wp-content\/uploads\/2025\/06\/images.png\",\"width\":225,\"height\":225,\"caption\":\"Elementor\"},\"image\":{\"@id\":\"https:\/\/elementor.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/elemntor\/\",\"https:\/\/x.com\/elemntor\",\"https:\/\/www.instagram.com\/elementor\/\",\"https:\/\/www.youtube.com\/channel\/UCt9kG_EDX8zwGSC1-ycJJVA?sub_confirmation=1\",\"https:\/\/en.wikipedia.org\/wiki\/Elementor\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/elementor.com\/blog\/#\/schema\/person\/8df3c6697ea8e60fd1416e98a7ff0e21\",\"name\":\"Colin Newcomer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/elementor.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/42aa991c5e5152c551c3ca3aa09e84d6e08a3a40420e566d930ab289160b09bc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/42aa991c5e5152c551c3ca3aa09e84d6e08a3a40420e566d930ab289160b09bc?s=96&d=mm&r=g\",\"caption\":\"Colin Newcomer\"},\"description\":\"Colin is a freelance writer for hire specializing in WordPress and digital marketing. Grow your business with in-depth, conversational blog posts.\",\"url\":\"https:\/\/elementor.com\/blog\/author\/colinn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Connect Elementor to Google Sheets to Collect Leads","description":"Elementor Forms makes it easy to create front-end forms to collect information from your leads. In this post, we're going to show you step-by-step how to connect Elementor to Google Sheets using Zapier.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How to Connect Elementor to Google Sheets to Collect Leads","og_description":"Elementor Forms makes it easy to create front-end forms to collect information from your leads. In this post, we're going to show you step-by-step how to connect Elementor to Google Sheets using Zapier.","og_url":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/","og_site_name":"Blog","article_publisher":"https:\/\/www.facebook.com\/elemntor\/","article_published_time":"2020-04-20T12:31:28+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/oovolzcf.elementor.cloud\/wp-content\/uploads\/2020\/04\/How-to-Connect-Elementor-to-Google-Sheets-to-Collect-Leads_External.png","type":"image\/png"}],"author":"Colin Newcomer","twitter_card":"summary_large_image","twitter_creator":"@elemntor","twitter_site":"@elemntor","twitter_misc":{"Written by":"Colin Newcomer"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#article","isPartOf":{"@id":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/"},"author":{"name":"Colin Newcomer","@id":"https:\/\/elementor.com\/blog\/#\/schema\/person\/8df3c6697ea8e60fd1416e98a7ff0e21"},"headline":"How to Connect Elementor to Google Sheets to Collect Leads","datePublished":"2020-04-20T12:31:28+00:00","mainEntityOfPage":{"@id":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/"},"wordCount":1281,"commentCount":0,"publisher":{"@id":"https:\/\/elementor.com\/blog\/#organization"},"image":{"@id":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/elementor.com\/blog\/wp-content\/uploads\/2020\/04\/How-to-Connect-Elementor-to-Google-Sheets-to-Collect-Leads_External.png","keywords":["Build"],"articleSection":["Elementor","Marketing"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/","url":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/","name":"How to Connect Elementor to Google Sheets to Collect Leads","isPartOf":{"@id":"https:\/\/elementor.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/elementor.com\/blog\/wp-content\/uploads\/2020\/04\/How-to-Connect-Elementor-to-Google-Sheets-to-Collect-Leads_External.png","datePublished":"2020-04-20T12:31:28+00:00","description":"Elementor Forms makes it easy to create front-end forms to collect information from your leads. In this post, we're going to show you step-by-step how to connect Elementor to Google Sheets using Zapier.","breadcrumb":{"@id":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#primaryimage","url":"https:\/\/elementor.com\/blog\/wp-content\/uploads\/2020\/04\/How-to-Connect-Elementor-to-Google-Sheets-to-Collect-Leads_External.png","contentUrl":"https:\/\/elementor.com\/blog\/wp-content\/uploads\/2020\/04\/How-to-Connect-Elementor-to-Google-Sheets-to-Collect-Leads_External.png","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/elementor.com\/blog\/connect-elementor-to-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/elementor.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Elementor","item":"https:\/\/elementor.com\/blog\/category\/elementor\/"},{"@type":"ListItem","position":3,"name":"How to Connect Elementor to Google Sheets to Collect Leads"}]},{"@type":"WebSite","@id":"https:\/\/elementor.com\/blog\/#website","url":"https:\/\/elementor.com\/blog\/","name":"Elementor","description":"Website Builder for WordPress","publisher":{"@id":"https:\/\/elementor.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/elementor.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/elementor.com\/blog\/#organization","name":"Elementor","url":"https:\/\/elementor.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/elementor.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/elementor.com\/blog\/wp-content\/uploads\/2025\/06\/images.png","contentUrl":"https:\/\/elementor.com\/blog\/wp-content\/uploads\/2025\/06\/images.png","width":225,"height":225,"caption":"Elementor"},"image":{"@id":"https:\/\/elementor.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/elemntor\/","https:\/\/x.com\/elemntor","https:\/\/www.instagram.com\/elementor\/","https:\/\/www.youtube.com\/channel\/UCt9kG_EDX8zwGSC1-ycJJVA?sub_confirmation=1","https:\/\/en.wikipedia.org\/wiki\/Elementor"]},{"@type":"Person","@id":"https:\/\/elementor.com\/blog\/#\/schema\/person\/8df3c6697ea8e60fd1416e98a7ff0e21","name":"Colin Newcomer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/elementor.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/42aa991c5e5152c551c3ca3aa09e84d6e08a3a40420e566d930ab289160b09bc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/42aa991c5e5152c551c3ca3aa09e84d6e08a3a40420e566d930ab289160b09bc?s=96&d=mm&r=g","caption":"Colin Newcomer"},"description":"Colin is a freelance writer for hire specializing in WordPress and digital marketing. Grow your business with in-depth, conversational blog posts.","url":"https:\/\/elementor.com\/blog\/author\/colinn\/"}]}},"_links":{"self":[{"href":"https:\/\/elementor.com\/blog\/wp-json\/wp\/v2\/posts\/37830","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elementor.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elementor.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elementor.com\/blog\/wp-json\/wp\/v2\/users\/50988"}],"replies":[{"embeddable":true,"href":"https:\/\/elementor.com\/blog\/wp-json\/wp\/v2\/comments?post=37830"}],"version-history":[{"count":2,"href":"https:\/\/elementor.com\/blog\/wp-json\/wp\/v2\/posts\/37830\/revisions"}],"predecessor-version":[{"id":93734,"href":"https:\/\/elementor.com\/blog\/wp-json\/wp\/v2\/posts\/37830\/revisions\/93734"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/elementor.com\/blog\/wp-json\/wp\/v2\/media\/37831"}],"wp:attachment":[{"href":"https:\/\/elementor.com\/blog\/wp-json\/wp\/v2\/media?parent=37830"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elementor.com\/blog\/wp-json\/wp\/v2\/categories?post=37830"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elementor.com\/blog\/wp-json\/wp\/v2\/tags?post=37830"},{"taxonomy":"marketing_persona","embeddable":true,"href":"https:\/\/elementor.com\/blog\/wp-json\/wp\/v2\/marketing_persona?post=37830"},{"taxonomy":"marketing_intent","embeddable":true,"href":"https:\/\/elementor.com\/blog\/wp-json\/wp\/v2\/marketing_intent?post=37830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}