Skip to main content
Question

Can Zapier delete multiple rows on google sheets?

  • February 1, 2022
  • 1 reply
  • 1355 views

Hi,

 

I know it can delete rows up to 20, but I need it to delete a lot more than that as I am working with large sheets that contain thousands of records.

 

The process I want is:

  1. Trigger by email attachment 
  2. upload to googledrive 
  3. find rows using search term 
  4. delete rows 
  5. find rows using different search term
  6. delete those rows
  7. upload to airtable

I know it can do this individually, but I need it to loop until it can’t find any more rows of that contain that data.  For example, loop 3 to 6 until satisfied, then continue to 7.

 

 

 

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

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 1, 2022

Hi @baardie 

Check out this help article about how to create a looping Zap: