I am compiling a list of all the opportunities (varies every day, but over 340 items) in our CRM for a sepcific pipeline. The API setup for the CRM will only allow me to pull 20 rows of data at a time, I am using a Webhook to return the 20 rows then place them in a Google Sheet using the “Add Multiple Row” zap. Then I am using the Looping Zap to do everything again. The Webhook an dthe Add Multiple Rows is insiude the Loop. It places the first 20 rows into my Google Sheet, but then repeats the same 20 rows for every additional interation. It looks like my full ZAP repeats itself for the number of iterations instead of running one Zap and then the loop will iterate. After reading another thread, I added a Delay functrion and It is doing the same thing. Any thoughts on how to accomplish this?
How do I prevent repeated data in Google Sheets when using Looping Zap with a Webhook in Zapier?
+14- Zapier Orchestrator & Solution Partner
Hi
For us to have more info, post screenshots showing how your Zap steps are outlined and configured in EDIT mode so we can see the field mappings.
Also, include the link to the API endpoint documentation you used to configure the API request.
+11- Community Manager
Hello there,
It’s been a while since we heard from you so not sure if you’ve already got this solved? If so, would you be up for sharing some details on what the solution was? This would be really useful to others running into similar issues in their Zaps so we’d really appreciate it! 🙏
If not, is there any sort of offsetting in the Webhooks action that would ensure that it returns a different set of row data each time? If not I’d suggest setting the webhook to pull in the next page of row data based on the loop iteration number. E.g. the first loop iteration pulls page 1, the second loop iteration pulls page 2 etc. That way the data it’s attempting to pull should be different for each loop run.
If you run into any trouble on setting that up, can you share some quick screenshots of the current set up of the Looping, Webhooks and Google Sheets actions as Troy mentioned? That’ll help to give us a better idea of what changes might need to be made to the current setup to get things working. Make sure to blur or remove all personal information (names, emails, addresses etc.) from screenshots before sharing - you can use a tool like Zappy for that.
Looking forward to hearing from you on this! 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.