Airtable/Slack Automation to update auto selected private channels

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!

Hi @Gary_Arbuthnot,

Unless you know Javascript and you write your own custom Javascript to handle this, this is not possible with native Airtable Automations. (Even if native Airtable Automations did handle conditional situations like this, Airtable limits you to 25 action steps — far fewer than the 150 conditionals you would need).

However, you can very easily accomplish this with Integromat. Even better, you wouldn’t even need to setup 150 conditionals in Integromat, because you could dynamically search for the name of a channel.

I am a professional Airtable consultant and a Registered Integromat Partner. If you have a budget for this project and you’d like to hire an expert to help you set this up with Integromat, please feel free to contact me through my website at ScottWorld.com.