Hi Makers Newbie here hitting giant blockers and would love to pick your brains!
I am trying to set up a Holiday Notice which will do the following everyday at a specific time:
- search for specific text “Run” showing up in Column K Today’s Notice within a sheet
- if there are one or more row that contain “Run” in their Column K Today’s Notice,
2.1 Text Aggregator will grab the data row in Column Weekday in Post, Date in Post, Name, Countries, and combine them into a list like this:
Weekday in Post,
Date in Post:
2.2 and then send a Slack message to a private channel as a bot, in the format of:
If these holidays apply to you and you plan to work on those days, comment in the thread and tag your direct manager. Thank you and Happy Holidays!
- if there are NO cells contains the text “Run”, the operation will not proceed to Text Aggregator and therefore NOT send a Slack message
So this is what my workflow looks like right now:
And the settings here:
Currently I’m having problems with:
Unable to send as a Slack bot. I could not find the private channel by selecting from a list (which is showing nothing), so I manually entered the channel ID. And then the operation comes back with “Error: channel_not_found (200)”.
I can successfully send Slack messages as a user, BUT the search module and text aggregator failed to filter out the data which does not contain “Run”, and proceeded with processing the next step and ended up sending Slack messages with empty variables.
I’d love to your insights on how to solve these issues! Thanks in advance!