Hi,
I'd like to make the date from a cell in a Google Sheet the trigger for sending a Slack notification with row contents (or just 1 cell will suffice).
How do I set this up? Or is there a better solution to this?
Best answer
Google Sheets to Slack, triggered by date from sheet
- Beginner
Best answer by ChrisP
If your end dates are always a set number of days from the begin date of the experiment there is a way you can achieve this in Airtable. You simply create a field "days since" which calculates the number of days since the begin date. You then create a view with a filter like this:
You then use updates to that view as a trigger. So, in the above example, as soon as any records hit the "3 days since" point, it will trigger any zap you wish it to.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+11- Zapier Solution Partner
Hi
So, Zapier can either trigger on a new row, or a unique change to an existing row.
By the sounds of it, you want to change the date and then have it trigger? If so, you can by either changing the date in that cell manually, or have another zap change it automatically.
Does that make sense?
- Beginner
Ok, so here's some more context: I have a sheet with all my ongoing experiments and each row has an end date - when the experiment should be concluded and analyzed. So when the day of analyzing the experiment comes, I'd like to get a notification.
+11- Zapier Solution Partner
If there will be less than 10 experiments every day, then you can use the "Find Many Spreadsheet Rows" Google Sheets search step.
Your zap would trigger with a "Schedule by Zapier step"m running every day. You can then use a "Formatter->Date/Time->Format" step to take the trigger timestamp and turn it into the same date format as your Google Sheet, and then use that as a search value in the Google Sheets step to return all the rows with a matching date.
- Connector
- Answer
If your end dates are always a set number of days from the begin date of the experiment there is a way you can achieve this in Airtable. You simply create a field "days since" which calculates the number of days since the begin date. You then create a view with a filter like this:
You then use updates to that view as a trigger. So, in the above example, as soon as any records hit the "3 days since" point, it will trigger any zap you wish it to.
Early access
Next Gen Zaps
Build and deploy automations from AI tools you already use. With Agentic Management, if anything breaks, the agent diagnoses the issue and proposes a fix.
Request access now
ZapConnect 2026 is coming
Join us September 23rd, 2026 for a free, one-day virtual event with 30+ sessions on AI automation. Get live build-alongs, playbooks, and strategies to lead AI transformation at your organization.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.