Deleting multiple rows in Google Sheet

#1

Do anyone have any idea to delete multiple rows in Google sheet using the “Delete a row” plugin, this plugin seems to only accept one row id a time and cannot accept a collection of row ids while passing in (Shows input format error)
Can I build a loop to repeat this step again or is their a smarter way?

(Karen Barker) #2

Hi @marandy0905 :wave:

The easiest way to achieve this would be to use the GoTo Labels. My thought here would be that you’d have something like the following logic in your flow:

  • Label
  • Search Rows
  • Delete 1st row from the search row results
  • GoTo Label - Filtered on Search Rows Count > 1

The only limitation here would be that you can only use the GoTo Label action a maximum of 20 times in any flow. :thumbsup:

1 Like
#3

THANKS, you guys really have super fast reply!

2 Likes