Good Morning Everyone - I am trying to set up an automation with Slack but I cannot find out if my desired scenario is possible.
I run an Artist Management company and what I want to do is when an offer comes in for one of my artists to automatically send the details of that offer entered into Airtable to the artists private slack channel.
I know I can specify the artist channel in the slack automation but then I am restricted to that artist and that would mean setting up 150+ different automations to account for all artists. Is there a way for me to build the automation so that Airtable finds the private channel of the specific artist from the information in Airtable and then send it to that private channel? This would result in only 1 automation compared to 150+.
Hopefully that all makes sense. Thank you!