in this video I'm going to show you step by- step how to build your own slack AI assistant you can build out a slack workspace like this with specialized channels where your customers or clients can ask questions and then your assistant can answer those common questions and it can even answer more complex questions as well we'll build out the whole thing on make integrate with slack and I'll even show you how to set up chat GPT assistant where you can develop and train your assistance based off of content you can use these Vector store databases to upload your content all you have to do is Click add and upload it here and then you can give your assistant special instructions on how to use that data and how to respond which allows you to integrate your assistant together with slack and I'm also using air table as a database to track all of the messages and the answers so that I can better train the model as we go so I built this because I have a thriving community on the school platform and we promise really great support and so as you can imagine we get a lot of the same questions asked over and over again and the team does have to spend a lot of time answering the same questions so we were able to extract all the data from school and then we were able to build out a general knowledge base for the no code architects commun and then we connected that to slack in the knowledge base so that you could ask any question related to the community here and then the assistant is able to answer questions directly to our members without having to do it manually and then we also realized we could build more specialized assistance for Niche topics we do have an open source project inside of our community called the no code Architects toolkit and this channel here responds directly to questions related to a specific API function that we have which is called ffmpeg compose where you can ask it specific questions like how do I merge two videos and then the NCA assistant will respond directly with how to build the Json for merging two videos together using the FFM Peg compose feature and then you can also ask follow-up questions like to better explain what's in the Json and then it'll explain the whole thing to you and then your clients can have an ongoing in-depth conversation with your expert AI assistant all right so first we're going to go ahead and build out our air table database that we use in our automations to store the incoming messages and also the responses from the assistants but if you don't want to build out yourself and you want to get access to the templates including the templates for make so you can import the blueprint where you can just click save and the entire automation pops up just like that make sure to jump into the no code Architects it's a thriving Community where you can get tech support a make an air table course and a bunch of other automation templates like the one you're seeing today we answer everyone's question and we've got calls almost every single day all right so now let's build out the aor table database you will need an air table account and when you first join in you'll be able to create a new base go ahead and start one from scratch now it's going to give you a default database just like this you can go ahead and close this here what I recommend doing is just deleting these three colums here and then just taking a second to rename this to message ID this is the only special column we really use here it's called an auto number field so you can come back here and adjust this to message ID and then you can scroll down to Auto number go ahead and click save and then just take a moment to add the rest of the fields the only other column types we use in this entire project is a long text field and also a single line text field so I'm going to come up here and just show you all of the columns just like that just go through your database and add the message the user the type the Tim stamp go ahead and spell everything the same way I did the thread timestamp the client message ID the team the channel the channel type assistant thread ID and assistant response and you can see these are all the single line text and then we have two the long text fields for message and the assistant resp response so go ahead and build that out it'll look just like this except it won't have the data but you should have all of these columns a single line text and then our long text fields for the message and the assistant response all right so next we're going to go ahead and connect up make with our slack workspace and a specific channel so I'm here in make I'm going to go ahead and create a web hook here we're going to go ahead with a custom web hook do not use a custom mail hook then I'm going to go ahead and add the web hook now I'm going to name it the YouTube Dem Mo AI slackbot I'll go ahead and click save I'm going to go ahead and click okay I don't need the URL quite yet and now I'm going to jump over to api. slack.com here's the app that I already created which I showed you at the beginning we're going to go ahead and create a new app we're going to start from scratch I'm going to name this app the YouTube demo Ai slackbot and I'm going to add a workspace here I'm going to install it into the content engine DB I'm going to go ahead and create the app it's going to give you a a couple of these popups you can go ahead and just say got it we don't need anything on this screen first we're going to jump down to events subscriptions we're going to turn the events on and now for the request URL I'm going to jump back over to make and I'm going to jump into the web hook and I'm going to go ahead and copy the web hook to clipboard I'm going to go ahead and click okay and I am going to go ahead and click run once right now because when I jump back here and I put in this web hook it is going to send a request to that web hook so if I come back here we will see that it sent us a challenge now it did fail because we didn't respond with the challenge I'm going to show you how to set that up next and if you need to retry and send that request again you can always just click here but that's why I ran it once before I even put the URL in here so that I could be one step ahead so now all I need to do is add one more step here we're going to add a web hook web hook response and now for the body we're just going to add the challenge right back go ahead and click okay I'm going to go ahead and click save I'm going to go ahead and click run once again now I'm going to jump back to the slack API I'm going to go ahead and retra try and now it is verified we can see that if I come here it got the request and then sent the challenge back to slack so we're good to go there now what we need to do is subscribe to bot events I'm going to add a bot user event I'm going to type message I'm going to scroll down and we'll do the group message history so this will be alerts for private channels and then we'll add one more message and now this time we're going to go ahead and add in the message channels and we should be good to go I'm going to go ahead and save changes then we're going to come back over here to install app I'm going to install to the content engine DB slack workspace I'll go ahead and allow if I jump back to our workspace I'm going to go ahead and just refresh here then I'm going to go ahead and add a new channel create new channel I'll create a blank Channel we'll go YouTube demo we'll go ahead and create I'm going to skip adding anybody to that for now and now from here I'm going to come up to the YouTube demo I'm going to go to Integrations I'm going to go to add an app now you can see here we have the YouTube demo AI slackbot I'm going to go ahead and add that now we've added that to the channel here so now if we come up to make I should be able to delete this web hook response I'm going to go ahead and just run this once I'm going to wait for new data I'm going to come over to our YouTube demo I'm going to type test then jump back over to make and now we have that test coming through right here if I jump into the event we see that test coming through right like that and that means we're good to go and continue Contin on with the video and if you're enjoying this video make sure to like And subscribe to the channel that tells me what type of content you want more of now one other thing that I do want to set up first before we try to build out the rest of the make automation is just to get our chat GPT assistant up and running so I'm going to jump up to open AI you just want to make sure you're logged in to open AI I'm currently in the playground but I'm going to jump over to the main settings I'm going to come down to projects and of course if you haven't set up your billing yet you'll want to take care of that first using the API and the playground is a different account than your normal chat GPT so make sure you also get your bilding details in for the playground and the API so now I'm going to go ahead and create a new project I'm going to call this the YouTube demo AI slackbot we go ahead and create it now I'm going to go to API keys I'm going to create a new secret YouTube demo Ai slackbot and then you'll be able to select the project in this case the YouTube demo AI slackbot we'll create that secret key I'm going to copy that key I'm going to come back to make I'll go ahead and add a new open AI module and we're going to message an assistant I'm going to go ahead and add a new connection I'm going to put in my API key here I'll go ahead and click save now if I come here to assistance it's not going to have anything because we didn't actually created yet so I'm going to come back to open AI here I'm going to go ahead and select the new project so I'm going to come to the YouTube demo AI slackbot then I'm going to jump over to the playground and then I'm going to come to assistants and then I'm going to go ahead and create a new assistant I'm going to go ahead and call this the ffmpeg compose assistant and for the system instructions I'm actually going to jump back and grab the system instructions that I already set up here now I'm going to jump back to our new bot and then I'll drop those system instructions here basically we're just telling the assistant what they should answer questions on and more specifically I'm asking it to answer questions on FFM Pig compose which is an API endpoint that I created in the no code Architects toolkit and then I'm saying unless you're asked more about general question questions about FFM Peg make sure to always answer in the context of my API and then I also gave it a few sample responses so I'm going to go ahead and click save now what I'm going to do here is I'm going to come to the file search and here's where we can add files this is where we can upload all of the information that our assistant should be aware of I'm going to add an API guide here I'm also going to add a couple of other files couple of other specialized files from here go ahead and click open so what it's going to do is it's going to upload these files here as the source of information to use for your AI assistant so I'll go ahead and attach those so now it's building the vector store of the files that we uploaded and so now I should be able to ask a question about FFM Peg compose the NCA toolkit endpoint for generating video files how would I create a Json for combining two video files we'll go ahead and click run and so now it's going to give me the answer on how to do that so I'm just just telling it not to re-encode a special efficiency command that you can call so now it's going to run the same command except it's not going to encode the two files you don't really need to understand what I'm doing here I'm just showing you examples of how this new assistant works this is really the playground where you can test it out and now that we have this we should be able to jump back to make and if we come to our assistant we should now see one we can go ahead and just refresh and now you can see I have that FFM Peg compose assistant and we are ready to go so I'm going to go ahead and disconnect this module for now we don't need it and now we have everything that we need to build out our entire make automation we have our chat GPT assistant we've built out our slack app and we've connected that to our slack Channel we've also run a test and we got that test back here at the web hook so finally you should already have your air table database built out I'm going to go ahead and duplicate the one that I had previously built I'm going to call this the YouTube demo AI slackbot I'm not going to duplicate the records I'm going to start with the fresh database let's go ahead and duplicate the base I'll go ahead and open that base you'll just want to make sure that you have yours and it should be a clean database with no rows in it yet and now we can go ahead and get started now I did want to provide just a little bit more context in terms of what I actually loaded up into my assistant here just so you understand what you need to upload for your own assistant now I didn't upload a ton of information I wanted a really specific assistant that knew how to handle one specific task and so all I did was upload a guide on my FFM Peg compose module and so what I did was I just created a guideline for how to use the ffmpeg compose module and different examples of the payload or the Json file I need to use in order to get that module to work successfully so I can scroll down here I gave it five different examples I actually had Claud write this for me using the actual source code from the NCA toolkit modules and then we also uploaded the source code from the no code architex toolkit ffmpeg compos modules so I actually provided the source code as well so was able to read this and really understand how the module actually works and that was really all I needed to upload in order to make this assistant function properly and then of course again I updated the system instruction so that it knew its purpose and it also had some examples as well on top of the files that I uploaded all right so let's keep moving along I'm going to move this assistant over to the side for a bit cuz we don't need it quite yet the first thing that I'm going to do is I'm going to search our existing database so again we have our air table database here's the YouTube demo a slackbot the first thing that we're going to do is we're going to search the database for an existing thread that may exist for an incoming message now remember the way that slack works is when you have a message like this there is a way to reply to that message and then it creates an actual thread and so we're going to use the slack thread to isolate everything for a single threaded conversation with the chatbot so notice the chatbot also has this concept of threads so that as you talk back and forth with the assistant it will keep track of that particular thread and so we're going to connect that thread to the thread in slack so again we're going to come back to our integration here and we are going to search Air table for that possibly existing thread and of course if it's just the initial message in the main Channel there will not be a thread and will handle both situations so I'm going to come back here to make we're going to go ahead and search records you want to make sure you pick a connection that has access to your air table database I'm going to use this YouTube demo account and then I'm going to pick the YouTube demo Ai slackbot and then for the table I'll go ahead and pick table one now for the output field here the only thing that you're going to need is the assistant thread ID so you can go ahead and check that everything else can be left unchecked and now we need to add in the formula so I'm going to go ahead and copy this in from a previous example you'll want to make sure that you copy this exactly so what we have here is we have an and statement that has three commas in here separating three different Expressions here what we're doing is we're searching the database for a row that does not have a thread timestamp so again you're going want to pause the video and copy this exactly as I have it make sure you match the case of the column names here notice we're referencing the thread timestamp column here and I have it in between these curly braces and then it says does not equal and then there's just two quotes here so it's basically saying that the thread Tim stamp is not empty and then we're also saying that the thread Tim stamp is equal to the event that's coming in from here now you're not going to have this placeholder here so I'm going to show you how to build that from scratch I'm going to erase the one that I have and I'll also erase this one here so to build this out manual you'll want to make sure to come into these double quotes and you can put curly brace curly brace one do event. thread uncore TS and then you put two curly braces to close it out and then here for the user you actually should already have this event here if you come in between your two quotes you should be able to select the event user that came from our initial test when we set up the slack API go ahead and add that in here just like that now that you've put in the your formula you can move the limit to just one and then we can go ahead and click okay and now the next thing that we're going to do is we're actually going to create a row for the new message so here what we were doing is we were looking at the existing database to see if there was an existing thread to attach the new message to in this module here we are going to actually write the new message to the database so I'm going to come to aor table create a record and again you're going to want to select the same connection that you used in the the previous module for the base YouTube Again YouTube demo Ai slackbot and for the table we're going to use table one and now what we're going to do here is just basically match up all of the records from the previous example here we're going to go into the message and we'll add the text and you can see our previous test for the user We'll add the user for the type We'll add the type for the timestamp we're going to go ahead and select the TS value here and now for the thread time stamp we have to add a special if clause here we're going to jump to this configuration here with the gear and we're going to use the if empty we're going to go ahead to this initial opening here and I'm going to go ahead and build my own make placeholder here with a curly brace open open one dot event dot thread time TS and then two close curly braces and then later on when we do actually have that value it will be replaced here and then here we're going to go ahead and add in come back to the star and we're going to add the TS so basically what we're doing here is that when we write the message here we are either writing the current thread timestamp or we are writing the existing timestamp for a new message which will become the thread timestamp the way that slack knows whether it is a thread or whether it is a new message is based off of this timestamp here so we're going to add the client message ID right here that is right here we'll drop in the team which is right here and we'll put in the Channel which is right here then for the channel type we'll add the channel type and now for the assistant thread ID we'll go ahead and use the value that we selected in the search here assistant thread ID so now we should be good to go I'm going to go ahead and click okay I'm going to go ahead and run this once and wait for new data it always asks you that question if you've already got some requests in the queue for testing just always use new data so now I'm going to come back to our YouTube demo I'm going to go ahead and type test again we'll send that message through come back to we should see that come through so it searched for the existing records now there shouldn't be anything in there so the output bundle here is zero and that's what we expect because if we go to our air table database we did not have any messages in here until now now we have one because we created that record right here and so now what I'm going to do is I'm going to go ahead and respond to the user but before I do that I would like to show how the threads and the timestamps work so if we come in here notice that we do not see a thread timestamp but we did record the timestamp of this message in the database so if I come here we have the thread Tim stamp right now so now I'm going to come back to make I'm going to run once again again I'm going to wait for new data don't use existing data I'm going to wait for new data then I'm going to jump back over here and now I'm going to reply inside of this thread here test two and we'll do we'll send it we'll jump back to make notice that that message is coming through and now notice we're going to have a thread ID so there's a thread time stamp so now this search should be coming back with a bundle now because now this formula works it now has a thread time stamp so it was able to find the existing Master thread which is in the database here this was the original thread so we have that thread timestamp so all the messages that come inside that thread will have the same thread timestamp because in the make automation again remember in the create record we either send the thread Tim stamp or if that's empty then we send the event timestamp and that's how we start threads and make sure that we keep track of threads so that each message that comes in we know whether it's part of a thread or whether it's a new message altogether so again back to the next step I'm going to come and add the slack module so that we can send a message go ahead and show more I'm going to create a message I'm going to go ahead and add a new connection we're going to add a slackbot I'm going to go ahead and click save this should open up authentication in which case you can connect it to to the proper slack workspace in this case it's the content ention DB I'm going to give it permissions here where it says enter a channel ID or name I'm going to go ahead and leave that enter manually and I'll go ahead and use the channel that came from the initial message coming into the system here we'll just pass that straight back and for the text I'm going to go ahead and say hey and then I'm going to use some special characters here which will get translated into a name so I'm going to use a greater than sign and the at symbol and then I'm going to go ahead and use the user ID here and then I'm going to close it with a less than so this is going to say hey user thanks please give me a moment to respond dot dot dot and we can leave blocks empty I'm going to go ahead and show advaned settings and then for the thread message ID I can go ahead and pass in the timestamp you can leave reply broadcast as empty link names empty parse message no you can leave all of this pretty much the same if you have an icon that you want to use for your chatbot when it responds you can add that I'll copy in the one that I used in my previous example and I'll also give the username ffmpeg assistant and I'll go ahead and click okay I'll go ahead and click save and I'll go ahead and just run this once again I'll wait for new data I'll come back to slack here and I'll do test number three send that over to make jump back to make real quick so now sending the message back if we come back here now we have the FFM Peg assistant responding saying Hey Stephen G Pope thanks give me a moment to response sorry I spelled that wrong so I'll fix that respond and then we'll go ahead and click okay so now the next thing we need to do is we need to use our assistant so I'm going to go ahead and connect that up now I'm going to go ahead and jump into our assistant it looks like it reset the connection so I'm going to go ahead and change that remember we created the FFM Peg together and I'm going to pick the proper assistant and then I'm going to map in the message from slack here we have the event and the text pretty cool you can upload images again we're going to use the thread ID from the search here it will either have a thread or it will be empty make sure not to use the create record we're going to scroll down and use the assistant thread ID that we searched for shouldn't need any advanced settings for now I'm going to go ahead and click okay and then from here what I need to do is I need to update air table with the response from the assistant I can also update the thread ID that we get from the assistant so that the next time it comes through it uses the same thread so let's go ahead and update the record that we created here go to aor table update a record again for the base we're going to use the YouTube demo Ai slackbot and then for the table go ahead and select the table for the record ID we'll use the record ID from the module 5 so we'll just add that in here this ID here and then the only thing we need to update is the assistant thread ID which is going to come out of here which is the thread ID here and then the assistant response that'll be this result here and that's all we need we can go ahead and click okay and then we're just going to respond back to the user with our message I'll go ahead and clone this add this to the end we can keep everything here except our response should be the result from the assistant I'll erase that we'll give it the result and again we'll keep that thread message ID the timestamp everything else can be the same and we have our icon URL I'll go ahead and click okay we'll go ahead and click save now before we run this and actually turn it on for good there is a filter here that we need to add because if you notice we're creating messages ourself with slack and so these messages are coming into the thread as well and they are also going to trigger our web hook so if we send a message and then that message comes back in it's going to create an infinite Loop and it's just going to exhaust all of our automations so I'm going to come here and I'm going to add the value here and again I'm going to type it in manually because it does not yet exist in our sample data I'm going to come here and do two open curly braces 1. event dobot ID make sure you do everything that I do exactly and then two close curly braces it's going to turn into this little placeholder here and we're just going to come down to this and we're going to say does not exist so when a message comes in it should not have this bot ID if it does we're going to filter it out and then we're going to add an and Rule we're going to come here and we're going to go to message type this one does exist so we'll go ahead and use it and it should be equal to message and we're going to add one more and Rule and we're going to use two open cly braces 1. event. subtype and then two close cly braces and again we're going to say does not exist and we're going to go ahead and click okay and then we'll go ahead and click save and now we should be able to come down here and turn this on again we're going to wait for new data I'll come back to slack how do I create a Json for ffmpeg compos to combine two video files and I'll go ahead and send that to our make automation which is going to ask the FFM Peg compose assistant once it gets a response it updates air table with that response and then messages back to slack so we'll come back to slack and now we have our response so now all we need to do is come back to our automation let's give it a name slack aibot I'll put YouTube so I know it's the YouTube demo then I'm going to go ahead and save it I'll go ahead and back out I'm going to turn it on and when I do I'm going to say delete all the old data we have some old records in the queue we'll delete that old data go ahead and delete and now I'll come back to slack and I'm going to come back to the main channel here and just start a new thread how can I overlay an image over a video in ffmpeg compose I'll go ahead and send that message we're going to get that reply remember where it's going to say hey thanks for the message give me a moment to respond and now it went ahead and gave me the message for using this endpoint and exactly how to go about doing it so now I would be able to take this Json and use it with the FFM Peg API call and then of course you could say hey could you explain this Json to me in more detail and now because we've set up the automation correctly it's going to respond in this thread it's going to say hey give me a second again and then it's going to break down all of the different pieces that we just went through the inputs the filters the outputs the global options and the ID which all translates to this here the inputs the filters the outputs the global options and the ID I'm going to show you the example that I built out myself that's a little bit more complex one of the main things that you might need from this is just an error Handler here what we're doing is that if there is an error in this module here we added an error Handler to send a message to the channel that there was an error and then to ignore it and just tell them to try again so if you wanted to add that to yours here we could come to the chat GPT module we could add an error Handler and then we can just scroll down down to slack we can create a message for the channel ID again we'll just use the channel from the original module here so we'll add the channel text we'll go ahead and say sorry we've encountered an error please try again and we'll show the advanced settings just so we put in that thread ID if we didn't do that it would send a message back to the main thread here which would not be correct so we'll put in that thread message message ID again we get that from right here and again if we want to put in the icon URL I can grab that I can drop that here ffmpeg assistant I'll go ahead and click okay and then I'm going to add one more option here which is just to ignore that means that it won't recover from the error it will just send a message and then ignore and then it will just wait for the next message I'll go ahead and click save and I'll Auto align everything so there we go that's a fully functional AI chatbot the message comes in we look for an existing thread save that message we let them know that we got the message we get the response we handle possible errors and then we save the actual response and give that back to the user now one other thing that I did add here which you might be interested in based off of the channel I send it to a different assistant so you can see here in my example that I first showed you here in the no code Architects workspace I have a different assistant tied to different channels so all the messages here in the knowledge base go to one assistant and all the messages that come into the FFM composed Channel go to a different assistant so to do that all you need to do is add a route and then you filter based off of the channel so you can see I have the channel ID here and then you can see I'm passing the message to that assistant right here if there's an error I respond please try again and then instead of updating air table and sending the response because I have multiple assistants that might be called I set a variable with the thread ID and the result and I do that for both channels here that way I can have a third route that handles the response from either this assistant or this assistant it gets the variables that either one of these assistants would have set so here again we set the same variables the result and the thread ID and so we get that result and thread ID right here in a git variable and then we finally do the same thing that we did here in this module here where we update the record that we created and then we send back the response so here we're doing the same thing it's just that we're using the variables instead of the values that come directly out of the chat GPT assistant so you can see here we're updating the thread ID and the assistant response from the git variable and then we simply respond with the result that was in one of the set variables that we got here where we saved the output from our chat GPT assistant so again if you want this more advanced template that's already built out and access to the air table template make sure to jump into the no code Architects Community you can jump right to the classroom to the automation Vault you'll get immediate access to the blueprints and a thriving Community where you can get text support or join the almost Daily Calls where you can talk to me personally I hope to see you there either way I hope you enjoyed this video and I'll see you in the next one