How to Send new Customer Leads from your Website to a Google Spreadsheet with Zapier



How to Send new Customer Leads direct from your Website to a Google Spreadsheet with Zapier

We're going to show you how to capture leads from your website and send them to Google Sheets using Popcorn Metrics WebZapp and Zapier, in less than five minutes

As an example we are going to use web page to show you how can you quickly and easily track web forms and send customer leads to your CRM.

If you scroll down you'll see the Lead Capture form and we're going to capture all the leads on that form. From there want to update those leads direct to our CRM tools (and in ithis case we're using a Google Sheet as as simple CRM).

The first step is to track the form in Popcorn Metrics. You just need to open your Popcorn Metrics account and load your website there. In this example we are loading our WebZapp landing page which is under the domain PopcornMetrics.com.

To capture our form, we just need to scroll down, right click Add and Event and select Form Submit. Next we are going to call our form CTA Webzapp Signup Form and we are going to change the field names so that they make more sense. Next we'll save our form and click on publish.

The form takes around 15 minutes to be live and we can go ahead and start integrating with Zapier.

The next step is to create the Zap in Zapier. Here you just need to go to your dashboard and click on Make a new Zap.

You need to choose your trigger app which is Popcorn Metrics and select the trigger. This is the trigger that will capture the form that you've saved in Popcorn Metrics and send it to Zapier.

You need to select your Popcorn Metrics account. Just click on Connect and enter your Popcorn Metrics credentials.

Next you need to select the domain if you click on the drop down you'll see the list of domains that you have in your Popcorn Metrics account.

You need to also select the form that we tracked was called CTA Webzapp Signup Form. Next. click on Continue

The last step is to test if the trigger is working properly so we just need to click on Fetch and Continue and Zapier is going to test the trigger.

To integrate with the spreadsheet we need to be pre-fill the first row with the field names as in our example we had: first name, last name, email, website, and CRM tools, so our spreadsheet is going to map the same fields.

Next we need to select our Action App. We want to send our web form leads to a Google Sheet so we just need to select Google Sheets from the Action App List.

Next we need to select the action. The action is to create a spreadsheet row. Whenever we receive a new Lead. Next we need to connect our Google Sheets account.

We need to select our Spread Sheet. If you click on the drop down you'll see the list of all the spreadsheets that you have and the Google Sheets (the one that we are using in this example is Test Zapier) and we need to select which Worksheet from that Spreadsheet we want to store the results. In this case we only have one sheet.

Next we need to map the fields in our Spreadsheet with the fields in our web form. For the first name we can click on the right button that will fetch all the fields in Popcorn Metrics and the firstname is called First Name website is Website etc. Once you're finished we just need to click on Continue.

Now Zaper needs to test if everything is working properly so we are going to create a test and click on continue. Cool - the test is successful so we just need to click on Finish and name this Zap in Zapier and turn the Zap on.

Lastly, lets check if everything is working properly. As you can see our spreadsheet is empty, it only contains the first row with the field names.

So let's go back to our web from, enter one leads and click on Sign up Now. All the fields that were mapped are showing in our Google Sheet. We're done.



Try our WebZapp integration for Zapier!




 


Why our amazing customers love us.





Elena Benito, Popcorn Metrics has saved us tons of effort and time.

"Popcorn Metrics has saved us tons of effort and time."

Elena Benito, Chief Marketing Officer, http://startupxplore.com


Elizabeth Forbes-Rohde, Revolutionised the way we work on web projects as a team.

"Revolutionised the way we work on web projects as a team."

Elizabeth Forbes-Rohde, Content Manager, http://crockfordcarlisle.com.au






Ian Walker, My developers are happy, we're more efficient as a team.

"My developers are happy, we're more efficient as a team."

Ian Walker, Marketing Analyst, http://invokelabs.com


Nik Crossman, This is a godsend for me.

"This is a godsend for me!"

Nik Crossman, Chief Operations Officer, http://groopt.com






Start your free trial now!









As seen on:
As seen on Product Hunt - Popcorn Metrics
As seen on T3n - Popcorn Metrics
As seen on TechEu - Popcorn Metrics
As seen on Techworld - Popcorn Metrics
As seen on VentureVillage - Popcorn Metrics
As seen on DinheiroVivo - Popcorn Metrics

Copyright ©2013 ©2014 PopcornMetrics.com. All rights reserved.