Hi Everyone,
I am trying to set up a zap to tag specific Slack users in a weekly Monday meeting reminder based on who will be the meeting facilitator and who will be the meeting notetaker (we have this predetermined every week for the fiscal year in a Google Sheet). I’ve found some related topics I’ve linked here but I cannot find an aggregated explanation of how this might work or how to set it up it simple terms.
Ideally what I’d like to achieve looks like this: Every Monday an automated message pops up in a specified channel that says
“Happy Monday! Here are this week’s meeting facilitator and notetaker. Please arrange to swap if necessary.
Facilitator: @ user
Notetaker: @ user”
Related Topics:
Randomly tag users in weekly Slack message
Sending weekly message on Slack with Google Sheets Data
Automating Birthday Messages to Slack
Any help is much appreciated, thank you!
Tag specific users in Slack in weekly meeting reminder
Hi
Good question.
Try these Zap steps…
- Trigger: Schedule - Weekly
- Action: GSheet - Lookup Row
- Action: Slack - Find User (by Name / Email / Username)
- Facilitator
- Action: Slack - Find User (by Name / Email / Username)
- Notetaker
- Action: Slack - Send Channel Message
- User Mentions: type an open angle bracket, the at symbol (@), the user’s Slack member ID, and a closing angle bracket.
<@UG1234567>
- User Mentions: type an open angle bracket, the at symbol (@), the user’s Slack member ID, and a closing angle bracket.
Hi
I’m a bit confused on how I would be setting up the GSheet Lookup Row. Basically, I want it to either go in order of the rows from top to bottom on a weekly basis or actually pull the date information from the sheet and send the correct reminder for that week (whichever is easier/possible). Here is an example of how our sheet is set up right now:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/6e2875e8-676e-4258-824d-00a9c2b7b34b.png)
Would I be able to set up the zap to effectively pull the Slack user info from this sheet every week and tag those users accordingly? And if so, how would I go about filling out the GSheet action?
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/a4776fa8-7e75-4d68-923a-ec7dc5de7ab0.png)
Hi
If you want it done daily then you’d use this Zap trigger: Schedule - Daily
Then you’d lookup the current date to find the matching row.
Change the Lookup Column to “Date”
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/0654d79d-1ff7-4b18-a877-c11b97a9ace2.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/639b82e3-cc6a-4799-9586-b1de8ed75456.png)
Alternatively, you can use Airtable.
Airtable has Views
Views can have Filters. (e.g. Date = Today)
Views can be used to trigger Zaps.
Here’s my current setup:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/40f61d78-9eed-4855-aacf-f9d5841505ff.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/5e6b15a1-87bd-49e8-9462-d68e364ae0b4.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/dcb2fddc-0af4-4ee0-8533-90c449df7e6b.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/fbd36813-a5ab-4053-8821-faf1436a7b26.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/15b529b5-a07a-4440-956a-b1b0ed5dc3ef.png)
Change the Zap trigger to Every Day if you have GSheet rows for each day that you want to send out.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/54f1d322-1afc-4445-a4c7-46aba6d67c83.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/6f8ce9cf-6fac-486f-a794-754105482858.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/4e640996-0ea6-47e4-9144-e8caceb2db48.png)
If I need to, I can change all of these to the Monday dates that I need the reminder to be sent but right now the zap isn’t triggering from the dates on this sheet. It’s just triggering every Monday.
I am trying to solve the following: “how to get the correct information from the Google Sheet to Slack every week since the Facilitators and Notetakers are different each week. Thus, the zap will need to automatically tag different people each week on Monday according to the Google Sheet.”
The way I have it set up right now (I think) it would just keep tagging me in the reminder every single week.
The mapped variables will dynamically change each time the Zap runs based on the GSheet row found, so as long as the GSheet Lookup Row step is finding the correct date, then the Slack message sent will be dynamic each week.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/ca79e6b7-6c6c-45cc-b9e2-85ab197c132f.png)
Thank you for all your help so far, really appreciate it!
Really comes down to testing different uses cases.
When you tested the GSheet Lookup Row step with this date format from the Zap trigger step, did it return the correct row?
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/41ebb694-d46a-4964-b0a8-8d38c4f29957.png)
It did indeed trigger the correct row. I guess my question really boils down to: Is this Lookup Value field also dynamic?
If it is and it’s going to search that sheet every Monday for a date that matches the current date and pull the info from that row then I think I’m fine so long as I create a “Reminder Date” column that lists all the Mondays.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/dd0d63ea-f486-497c-81f4-22095b51dae7.png)
Any mapped variable in a Zap step is dynamic, so yes the Zap will work under the correct conditions.
Hi friends! I wanted to summarize some of Troy’s responses into a single reply for anyone following along!
The mapped variables will dynamically change each time the Zap runs based on the GSheet row found, so as long as the GSheet Lookup Row step is finding the correct date, then the Slack message sent will be dynamic each week.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/ca79e6b7-6c6c-45cc-b9e2-85ab197c132f.png)
Any mapped variable in a Zap step is dynamic, so yes the Zap will work under the correct conditions.
I hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.