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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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

How to get around deduplication?

  • 8 May 2023
  • 3 replies
  • 82 views
jesszepeda

I am trying to send NPS survey results from Pendo to Slack, using Zapier. Unfortunately, the way that we had to build our Pendo instance means that we have multiple rows per user ID, some that have the NPS survey results and some that do not. 

 

Because of this, I need ALL rows from the visitor report in Pendo to go to Zapier and then I can filter out the ones that I don’t need. The deduplication is currently only sending me one result per visitor ID and it usually is one that does not include the NPS survey result, which isn’t what we want.

 

Is there a workaround or some feature that I am not aware of? I saw some people using google sheets as a middle step and was going to try testing that out. 

 

Let me know if anyone has any other ideas!

3 replies

SamB
Rank
Userlevel 7
Badge +11

Welcome to the Community, @jesszepeda!

Are the missing rows from different reports in Pendo but for the same user? Or are they all from the same report in Pendo for the same user? 

If they are for different reports then I think you’d likely need to set up additional Zaps that have the different report types selected to be able to trigger on them and have those report results added.

If they are from the same report, are there the same number of rows added for each user? And is it always the same rows that trigger the Zap? In which case, can you see any differences between those that do and don’t trigger the Zap? Do some contain custom fields for example? Just wondering if there might be a change that could be made to the rows that aren’t triggering to get them to trigger the Zap like the others. 

I’m not sure adding Google Sheets to the Zap will fix it as it would still need Pendo to trigger for all of the result rows. Is Pendo able to save the results directly into a Google Sheets spreadsheet? If so you could use a New Spreadsheet Row (Google Sheets) trigger which in theory allow you to trigger the Zap for each new row of results information that’s collected and ensure they’re all passed over to Slack. Do you think that could work or does Pendo not have the option to save results directly into another app? 

Looking forward to hearing your thoughts on this!

jesszepeda

Hi! They are all from the same report in Pendo and there is not the same number of rows added for each user - it varies depending on that user’s situation. I talked to Zapier support and they mentioned that it may be able to work if I could somehow get the responses to come into Zapier as line items instead of as polling triggers. But I’m not sure if that is possible. 

 

I will attempt the google sheets route today and see if that could work! I’m pretty positive that the de-duplication process is happening on the Zapier side so what you mentioned may be a solution. I will report back.

Danvers
Userlevel 7
Badge +12

Thanks for lettings us know where you’re at with this, @jesszepeda! I’d love to know if the Google Sheets workaround does the trick and if not, let us know and we’ll keep thinking on this with you :) 

Reply


Terms & Conditions