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
- 2 replies
Best answer by ChrisPBest 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.
+10- Zapier Expert
- 2437 replies
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
- 2 replies
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.
+10- Zapier Expert
- 2437 replies
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
- 79 replies
- 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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.