I’m trying to get a google sheet to process.
Trigger is new file in a folder in google drive.
THe problem is, it’s a NEW file every time.
Because of that, get next row(s) as a piece to loop is tough because group size is variable. (could be 10 rows, could be 100. I suppose I could do a check for row amount first and then pass that, but that I feel like there should be a better/easier way. Additionally, I don’t like the memory_key because each file is NEW so it needs to start at 2 again (headers is 1)
Is Find Rows better for this use case? Or not?
ANy insight on best practices here?
Thanks!
