I have a Google Sheet, where based on a =UNIQUE() formula new emails will populate into a column on a separate tab when a relevant date. This formula populates all emails addresses into a list within a column when they = today + 2 days, essentially a 2 day timer with other filters/criteria.
I believed this would be a good trigger for Zapier “New or Updated Spreadsheet Row” with Google Sheets. However, Zapier is not triggering when new emails are automatically populated into this column through that formula.
Has anyone experienced this and/or discovered how to solve this?