Action: Lookup Spreadsheet Row (Google Sheets) searches for the row based on the Row ID number contained in the event details.Action: Send Direct Message (Slack) Sends user a DM on Slack (takes username details from the Lookup Spreadsheet Row action).Action: Only Continue if (Filter by Zapier) column in row Contains the word Slack and relevant checkbox column Contains the word FALSE.Add Row ID to the event description.Īction: Lookup Spreadsheet Row (Google Sheets) searches for the row based on the Row ID number contained in the event details. Action: Create Detailed Event (Google Calendar) set the Repeat Frequency as appropriate to make it a recurring event (for each recurring event a reminder will be sent).Trigger: New Spreadsheet Row (Google Sheets).I’m thinking that sort of workflow would look like this: If you’re not familiar with using filters I’d recommend checking out our Add conditions to Zaps with filters guide for more details.Īnother thing you might want to consider is adding a column to denote whether they should receive a Slack DM or an email. But you’d also want to delete the recurring events so that they don’t continue to trigger the Zaps. But you’d also want to have a Filter by Zapier action added to ensure that the Zap only continues to run if the checkbox values for those columns are FALSE (when ticked the checkbox value would come through as TRUE). I think you could use a similar approach to what’s suggested in that other topic. We had a similar question asked a little while back here:
0 kommentar(er)
