Let me start off by saying I am very new to Zapier.
I have a google sheets table with two columns Date and Name. I want uses Zapier to send messages to slack with the date and name on the google sheet.
The goal is to alert the team of the person that is on call and the date (which should be today’s date)
Link in the google sheet
I need to set up scheduler
Link to Slack
I’ve set up google sheets and slack but no way to automate it to send it daily at 8am since I can only have 1 trigger
I’ve tried using the scheduler trigger and google sheets look up action but I’m getting an error.
Thank you in advance for all insight on how to set this up