in this video I'll walk through how to build an automation that turns Zoom calls into hundreds of quality posts automatically first we'll walk through that automated system then I'll show you how to repurpose the Zoom content into other content and stick around to the end where we talk about how to create high ticket offers all right so let's go over the automation i'm in a blank workflow in NAN i'm going to jump over to the No Code Architects community into the classroom where we have all the templates and I'm going to download the workflow that downloads all of the Zooms and helps us repurpose that content and I'm simply going to import that into NADN and so here we have our automation at a scheduled time this is going to log into our Zoom account and download all of the Zoom recordings and the transcripts and then it's going to index all of that content into our Superbase data store and I can jump over to Superbase and you can see an example here we have all of the transcripts of the Zoom calls automatically imported and then we've also vectorized all of the transcriptions so that we can access them and then repurpose them so I'm going to go ahead and delete all of the existing rows here so that we can go ahead and run the automation and see it run and then we can walk through how it works now we should have an empty database here we go so we can start from scratch i'm going to go ahead and test the workflow here you can see we're getting all the meetings then we're getting those recordings making sure we have the transcript downloading the transcript and then inserting them into the Superbase vector data store and then if we were to come back to our superbase vector store here we would see again we have all of those Zoom meetings here so let's go over this automation and just step through it one by one so you can see how it works first up here we have the trigger this is going to run at some scheduled interval you can really run this as often as you want more likely you can just run it once a day and it's going to grab in all of the new recordings in this next module here what we're doing is we're doing a quick query into our database to find the most recent Zoom call that we have in the database so that when we process the rest of the recordings we only process the new recordings we don't need to process all of the Zoom recordings every single day when you get the active recordings it's going to return all of the meetings that are still active that haven't been deleted so you don't need to process those every single time so what we do is we just do a quick query in the database and we're just using this date here to figure out the last time this database was updated and so with that then we can go ahead and get all of the meetings and then here we're just doing a quick check to see if there was any value here if your database was empty just like the way we ran it just a few seconds ago then there isn't going to be a last run date so in this case it's just going to be false and then it can come down and go ahead and start processing all of the recordings so anytime you're running this from scratch or you delete everything there isn't going to be a last run date because when you search the database this is going to be empty and there's going to be no date in that case then it's going to just follow this path and download all of the recordings if there are previous recordings that we've put into the database then we will have a date and when we process that data we can filter out based on that date so in this case what we're doing is we're looking for any Zoom recordings that were created after or equal to the last runtime and this should probably just be is after not equal to then the next step here in the automation is to get the recording files so if we open this up here we're going to see an array of all of the Zoom recordings it's going to give you links to those files then in this next module here what we're doing is breaking apart the specific recordings that are part of each recorded Zoom conversation just remember for every Zoom recording you're going to have multiple files you're going to have the active speaker you might have the gallery view you might have the screen recording you might also have audio only and you might also have the transcript which is just the written material from the call already transcribed that you can use instead of having to transcribe it yourself with some other thirdparty software so one of the important parts about setting this up correctly is in your Zoom recordings you want to make sure that you're also automatically creating the transcription so that when you split out all of the different recordings for a given call then you can then only process the transcript so you can see here we had three actual Zoom calls then it split it out into 24 items because those three calls were broken out into lots of different calls like the active speaker and the gallery view and the transcript so for each one of these Zoom calls we had actually eight different items and then we filtered it back down again so that we're only processing for that transcript then in this next module here we're actually downloading those transcripts or converting them into text because they're not actually transcripts the way Zoom processes these is that they are a web VTT file which is a lot like a SRT file which has all of the timestamps and the transcript broken up into little chunks so what we do here is we actually turn that into something that looks more like a transcript that we can then convert into a file and then we can insert all of these files one by one into the superbase vector store and then once you have all of that Zoom content indexed into your vector store database then you can use an automation similar to this which is using an AI agent to search that database and then use OpenAI to take that content that it found and then rewrite it and then output that content out the other side and it's important to remember that even though I only have a few conversations in here that were recorded previously in the day as you add more and more content into the system over time from your client calls from your sales calls you're going to have more and more relevant information that you can query against and create content from and so let's go ahead and look at an example here i'm going to use this automation and the way it works is we have a chat interface which is hooked up to the agent so we can ask it questions and ask it to do things it's going to query the information use OpenAI to pull all that information together and complete our request and send it out the other side so I'm going to go ahead and open up the chat so I'm going to go ahead and ask the agent to write some content about one of the conversations that happened in one of the Zoom calls from the No Code Architects community on one of our tech calls where people come in and they ask questions around techreated questions so I'm just going to come in here and say write an article about the differences between Digital Ocean and Google Cloud Run and the NCA Toolkit and we'll go ahead and send in that question so now the agent is thinking about that it's looking up the relevant information from the database and now OpenAI is helping take all of that information to write the article and then we should see that come out the other side and then of course you can always use the log here to walk through the logic that the agent used to figure everything out and then here we can see that we have our article coming out the other side it took that entire Zoom conversation and reformatted it into an article that we could post right to our website or onto social media we could also have it write a video script please write a 60second video script on the differences between Digital Ocean and Google Cloud Run and the NCA Toolkit again it's going to run a query against that and then go ahead and write a video script and so there it came back with a video script or we could say write five tweets about the NCA toolkit so again you can write any question you want have it create any type of content you want and it's just going to reformat your existing content in the most raw form possible just conversations on Zoom and it's going to respond back with ready to go content for social media or for your website or wherever you want to publish that now one thing that is important to note about these vector store databases and these questions that we're asking it's not just looking for stuff that has NCA in it and grabbing all of that and just trying to rewrite it it's actually looking at the question itself and looking at the content that is most relevant to that question and returning that so it's much more sophisticated than just a text search bringing back that content and rewriting it so now when it comes to actually creating offers and selling automations like this the most important thing that you need to keep in mind is the target audience because this is not necessarily an automation that you can just sell to anyone there's only a few specific types of buyers that are really going to offer you a 5K fee for an automation like this and it's usually going to be packaged with some sort of coaching or some sort of ongoing service because the only people that are going to be able to afford something like this are people that are already making quite a bit of money they don't have a lot of time and they just want content and they want to spend as little time as possible to do that so if you imagine if you have a system like this and you set it up and they've already got a bunch of client calls and a bunch of sales calls then it's very easy for them to have the source content because that's one of the hardest parts is actually getting the source content a lot of founders and CEOs just don't have the time to sit down and write or create content so if there is an easy way for them to just take something that they're already doing like their Zoom calls and convert that into content then you have a solution for them that will alleviate their pain point almost overnight and it's those kind of offers where somebody wants something really bad and you can solve it overnight where you can charge a lot of money the other reason why you want to offer some sort of coaching or service alongside this template is because when you just sell templates people don't really value these templates all that much there are some exceptions of course if you just have a template most businesses especially the busy ones there's nothing they can do with this they're not going to install Nad and set all this up it's just not going to be something that they want to do so the value of this template is really not that much to them because they can't do much with it it's not going to be easy it's not going to alleviate their pain and it's not definitely not going to do it overnight so it's just really not that valuable to them so you've really got a couple of options here you can offer this as some sort of coaching service you do the install for them it's a done for you install and you get the template all set up you set up Nadan with the template and then you show them how or show someone on their team how to use it so that dayto-day they can then actually take use of it and use it and then this is something that you sell as a one-time fee for maybe 5K that's one option and then they get the result they know how to use it themselves maybe they have a few follow-up questions essentially you install it show them how to use it and they're off and running or instead you just offer it as an ongoing service and you charge them an ongoing retainer where it's just completely done for you they don't have to do anything maybe they don't even see or even understand that there is a template they don't want anything to do with it and they just hire you on an ongoing basis to make sure all of their Zoom calls are indexed and you come up with the content strategy you figure out how to repurpose it what are all the different types of content that they need are they articles are they video scripts are they tweets what are all of those different posts is it LinkedIn hash all that out for them so all they have to do is show up on those calls and then every month you just deliver a package of content that they can take and post to social media and have a space where you can talk through how to sell these types of offers and automations make sure to jump into the no code architects community there's a classroom full of templates and courses there's calls with me almost every single day it's an engaged group and you can get dedicated tech support and we make sure to solve 100% of all of our members tech issues would love to see you there either way I hope you enjoyed this video and I'll see you on the next