I am trying to find the right approach of extracting the information from all rows of a Google Sheet that were added through another zap in the past week. Then, ChatGPT should summarize those newly added rows (or at least one column of the rows), and send it via slack to a channel.
My Google Sheet contains a column with a formula that says “TRUE” if the row was added in past week, and “FALSE” if it was added before the past week. I wanted to take this column as a lookup value, but it does not work because it cannot find any values - probably because the cell value is a formula, and not “TRUE” or “FALSE” as string?
What’s the best way to achieve this?
Then, I would need to feed the input of several cells at once to gpt → Because I want it to summarize all cells at once, and not cell by cell. How can I achieve this?
I also tried it with Zapier tables but I couldn’t find a formula that would change the cell values dynamically with the logic “Say ‘True’ if the row was added before last Monday and upcoming Monday from today’s date”).
Best answer by Tim_wienboeker
Solved it like this:
In G-Sheet, I have two sheets:
one with all updates and a column whether the info was added within past week (False = older than a week, True = within last week).
Used this formula for column A in zap. {{zap_meta_human_now}} is taking today’s date and time. G-Sheet then checks whether that date when the column was added is between last Monday 7am and next Monday 7am (from TODAY()) → so it checks whether the update was added within last week.
one with all updates and a column whether the info was added within past week (False = older than a week, True = within last week).
Used this formula for column A in zap. {{zap_meta_human_now}} is taking today’s date and time. G-Sheet then checks whether that date when the column was added is between last Monday 7am and next Monday 7am (from TODAY()) → so it checks whether the update was added within last week.
