Hello everyone,
What I try to achieve
I ran into a little conception thinking issue here with what I try to achieve. I want all reccord more than 21 days old to be remove from a Google Sheet. For that, I have a date column I can use.
First I though, ok let’s use a trigger on “new row” and then wait 21 days and then delete the row.
The issue
Issue is, meanwhile, maybe some manual operation have been made and the row number isn’t the same anymore. So I can’t be sure that my 21 days old rowID is still representing the correct row I need to delete.
Some thoughts
I thought I could use a daily trigger, then search for all reccord for who date value is 21 days old and then delete them, but I may have 50 rows to process (or more) and I think the search can’t return that amount of rows. Moreover, I don’t see how to then iterate over each rows and delete them.
I could use some zapier wisdom here 