Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Hey!

I do have several Zaps with slightly different configurations that take the information from the Cognito Forms and send the data to a single table in Google Sheets. With the volumes going up, the accuracy of the table in Google Sheets started to decrease — the table regularly have duplicate rows for sole Trigger events. Nevertheless, the Zap history for those duplicates seems to be correct and nothing is inconsistent there. In order to detect what is wrong and isolate the issue I also looked at other steps that the above-mentioned Zaps have — all steps clearly were performed only once. However, the spreadsheet catches the data several times.

My assumption regarding the cause of the issue is that I have few Zaps that are accessing the same table in Google Sheets. However, I have to maintain different triggers that should cause the action in the sole table, I am kindly asking for your assistance. I’ve also already tried to add small delays steps inside the Zaps, it made the situation a bit better but did not solve the problem completely.

Please, let me know if you need further details and thank you in advance. :pray_tone1:

Regards,
Mariia

Hi @manyaned 

One way to solve for this is to add a GSheet Lookup Row step to the Zap followed by a Filter to continue only if there are 0 matching results found.

 

Delay After Queue steps may also help address the issue: https://zapier.com/help/create/customize/add-delays-to-zaps#delay-after-queue

Hey Troy,

Thank you for your response. I am using a Sheets Lookup Row step followed by a Filter as well as a Delay After Queue step. But the issue still appears.

I’ve added a DateTime value to track when the specific row is being sent by Zapier to Sheets. And for duplicates this value is the same meaning that the duplicates are a result of one Zap running. 

Maybe you have some other advises on that issue?

Thank you,
Mariia

@manyaned 

We’d need a specific example to trace and troubleshoot.

Are you able to outline one for us?

 

Otherwise, you can open a ticket with Zapier Support: https://zapier.com/app/get-help

Hey @manyaned! Just wanted to check in here to see if you were able to get the issue sorted out. I checked with our support team and couldn’t find and open ticket from you so I wanted to double-check. 

Let us know - we want to make sure your’e good to go here!

Terms & Conditions