website logo
⌘K
✔ Account Setup
Create New Account
Load Appropriate Snapshot
Setup the Clients Location and Information.
Setup Email Domain - Agency Settings1
Setup Phone Number
Integrate with Google & Facebook
Setup Custom Values
Reputation Setup
User Setup
🛢Campaign Funnel Setup
Step 1.1 - Copy over the Funnel
Step 1.2 - Color Changes & Logo Swap
Step 1.3 - Coupons Left Script
Step 2 - Color Changes & Logo Update
Step 2 - Copy Form, Options & Integration
Custom Values for Funnel
Step 3 - Funnel Scripts
Setting Up Funnel Reporting
⚙ Custom Values
🚿 Pipeline Setup
🔫 Triggers Setup
Trigger Activation & Editing
$99 New Patient Triggers
Teeth Whitening for Life Triggers
📲 Editing Campaign Sequences
☎Call Tracking Setup
Call Swapping (Website)
Creating a Number Pool (Website)
🧪 Testing Campaign & Live
Docs powered by archbee 
6min

Step 4.1 - Send Leads to Google Sheets

Next we will set up a trigger and send our lead to google sheets so we can keep track of how many leads are coming in each month.

Start by creating a new Trigger or editing an existing one in the Prime Local App.



Document image

Setup the trigger like the screenshot above. Note that you must select the right form for your campaign. We will next get the webhook URL from Zapier.



Log into Zapier and lets create a new Zap!

Search for "Webhooks by Zapier" and select it as our App.

Next select "Catch Hook" as the trigger event.



Document image

Copy the webhook URL and place it into the Prime Local trigger from the step before:



Document image



Document image

Note, no data is needed for the silent mode stuff in Zapier, just press continue in Zapier to go to the next step.

After this you will need to send some test data from the form so Zapier can pickup the data.

Do this by going to:

Marketing > Form Builder > Your Form > Integrate Form > Link



Document image

Paste this form into a new tab on your browser and fill it out with some test data and submit.

Go Back to Zapier and Click "Test & Review". Zapier should now pull in the test data you submitted in your form. You're now ready to setup the next

You'll now create an action that will happen after the Webhook.





Next, lets format the date:

For the next step search for "Formatter by Zapier"



Document image

Continue

Document image

next click test & review and you should have a nicely formatted date for input into the next steps.

Add Another "Do this..." by clicking the blue "+" sign



Document image

Search for and choose Google Sheets

Document image

And Choose "Create Spreadsheet Row" as your action event

Next choose your Google Acct.



Document image

Select the corresponding Drive, spreadsheet, and worksheet you need.

Document image

Next Map all the spreadsheet fields to the high level data pulled in from the webhook. Some fields can remain blank.



Make sure that the date field is pulled from "Formatter by Zapier"



Document image



Next, Send your test & Continue:

Updated 29 Apr 2020
Did this page help you?
Yes
No
UP NEXT
Step 4.2 - Send Leads to Google Analytics
Docs powered by archbee