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.

Dear Zapier Community,

I am currently working on a project where I need to transfer data from one Google Sheets document (approximately 300 rows) to another Google Sheets document. Due to constraints with another automation in the target sheet, which can only process 4 new rows per minute, I am facing a challenge: I cannot transfer the data all at once but need to manage the transfers so that only four rows are inserted per minute.

I have heard about the features "Looping by Zapier" and "Delay after queue," but I am unsure how to best implement these for my scenario. Could you please help me configure a solution that allows:

  1. Reading four rows from the source sheet,
  2. Transferring these four rows to the target sheet,
  3. Waiting for one minute, and
  4. Repeating the process until all data has been completely transferred.

I would greatly appreciate any guidance or best practices you could provide to effectively solve this task with Zapier.

Thank you in advance for your support!

Hi ​@Foodji Marketing Team 

How will you mark that you’ve processed certain rows?

Is there a GSheet column that will be used for status?

​@Troy Tessalone that’s open for ideas, whatever works can be used :)

​@Foodji Marketing Team 

Guide for the general concept about how to create a looping Zap with webhooks and GSheets: 

 

You’ll have to add in logic for the Delay and to find rows (4) and create rows.

​@Troy Tessalone thank you so much for your help! Is there a way without using webhooks as Google Sheets is already an integration in Zapier? 

Hi ​@Foodji Marketing Team,

 

You can create a looping Zap with Google Sheets without webhooks by setting up a trigger for new rows, adding an action to make a row in another sheet, using a delay step, and then looking up a row in the original sheet. A filter ensures the loop continues only when a match is found, and another action adds a row back to the first sheet, triggering the cycle again. Be cautious, as looping Zaps can run indefinitely if not configured properly, so thorough testing is recommended.

 

I hope this helps! Let me know if you have any more questions.

Terms & Conditions