I have a Google Sheets sheet with a Date column which contains datetime values in UTC. I’d like to have my zap get rows from that sheet only if they have a date from the last seven days.
I’ve been trying to use Lookup Spreadsheet Rows, but it seems like Lookup Value only accepts a single value, not a calculation. What I’d like is to do a calculation (“>= current datetime in UTC - 7 days”) and only get rows that match that criterion.
I’ve seen recommendations to add another column to my spreadsheet that returns TRUE if the Date value is greater than or equal to the current time minus 7 days, but I’d like to avoid having more filler columns. Is it possible to do this with Zapier?
