Hey, guys. I’m trying to create a management solution for Telegram groups for our company. We are currently using Airtable for an employee directory, and I would like to incorporate messaging group management into it. We have several Telegram groups at our company, and each employee is granted membership to the groups based on their role at the company (sales, engineering, etc.) I would like to use an automation to:
Send an email to new users added to a group that includes a static invite link
Ban/block employees from group(s) if they quit or are terminated
I’m planning to use Airtable automations to invite the new users, and a chat bot to kick/ban members that have changed roles or are terminated. (probably this one: Telegram Bot Integrations | Integromat)
I’m struggling with coming up with a “clean” way to make this work. Ideally, there would be a linked field to another table that contains all the info for the various groups (name, invite link, etc). Users should be added/removed from groups by changing the values of the linked field. I can set up an automation to watch when that field is updated, but I can’t think of a good way to see exactly how the field has changed.
A “dirty” way to do this is to create a checkbox field to specify group membership, but this will get messy very quickly. There would have to be a separate checkbox for each group, and a separate automation for each checkbox.
Have any of you solved a similar problem? I would love some suggestions.
p.s. I’m not sure if you have a budget for your project, but if you do, I’d be happy to come in as your Airtable consultant and set all of this up for you, including the Integromat portion of it as well.