About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Zapier Webhook for tracking pixel to autofill Google Sheets

  • 21 March 2023
  • 3 replies
  • 102 views
speculo
Userlevel 1
Badge

I am trying to use a webhook to pull data from a tracking pixel and write the information to a google sheet. The information I am hoping to continually track is for new leads’ contact info. Here is an outline of the steps:

  1. Choose Webhooks by Zapier and choose Catch Raw Hook for the Event
  2. Copy webhook URL into the pixel
  3. Test the trigger
  4. On action, choose Google Sheets and choose Create Spreadsheet Row for the Event
  5. Choose google account, spreadsheet, and properly set up worksheet(with header)
  6. When I begin filling the cells of the spreadsheet, all of the information the webhook pulled is useless and not what I intended to pull. I have a photo attached of some of the options. The rest are equally unhelpful.

How do I change this to pull the information I want which is contact information for new potential leads that have been tracked on the website?

1 Attachment
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @speculo 

Good question.

What app is being used to collect the lead info? (e.g. a form app)

We will need more context about how the webhook is configured in the tracking pixel.

Screenshots are best to provide context.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
speculo
Userlevel 1
Badge

Hi @speculo 

Good question.

What app is being used to collect the lead info? (e.g. a form app)

We will need more context about how the webhook is configured in the tracking pixel.

Screenshots are best to provide context.

Thanks @Troy Tessalone ! We are using a pixel from AudienceLab to collect the lead info. The webhook is simply pasted in the data webhook section on AudienceLab as shown in the photo below. Let me know if you have other questions. 

1 Attachment
Troy Tessalone
Userlevel 7
Badge +14

@speculo 

Zapier has built in data deduplication for trigger data.

So you may need to add a query string parameter such as a UNIX timestamp to be included with every request. (e.g. ?ts=[UNIX])

Not sure if AudienceLab supports that.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions