AppSheet and Slack Integration for Project Management

I saw someone post this in a Reddit forum and it sums up what I am looking to do for an AppSheet/Slack integration. I'm trying to figure out the best way to make an open message conversation for each of the projects in our project management section of the app that has all our jobs. 

Lets say I built a project management app in Google AppSheet and my vision is to run it on the left half of the screen and slack on the right side of the screen, Slack being used to channelize internal communication for each project. Google AppSheet is setup to call Slack Webhooks. Here is my list of requirements so far and relevant info I've found.

  1. From each project in my app, I can click a button and call a Webhook to create a slack channel for that project. I will use project name and project create date for the slack channel name. https://api.slack.com/methods/conversations.create

  2. When a user in AppSheet chooses a project that has a Slack channel associated, my slack client changes to that channel. https://api.slack.com/reference/deep-linking#client

  3. Being able to send messages and view messages through the AppSheet app for the associated project. 

When I research Slack incoming Webhook, https://api.slack.com/messaging/webhooks, I'm finding that they are for a specific channel.

 

1 4 990
4 REPLIES 4