Automated Content Creation and Publishing Using Slack, Make.com, and Airtable

in this video I'm going to show you automations that can automatically create and publish content to LinkedIn and Facebook Twitter and X these image carousels to Instagram and vertical videos for Instagram that take b-roll and add captions and AI voiceovers and it's completely 100% automated all by uploading some voice notes into a slack channel that are imported into air table where you can review all of the content and even review it before it's published I'll explain how to build these automations step by step how to create the images the AI voiceovers and the vertical videos with captions using Json to video and how to publish to LinkedIn Facebook Instagram reals and Twitter all automatically I'll even explain how to record these audio notes so it's easy and chill so that you can start creating content and grow your business today it's way more simple than you think I'll show you how to build this all from scratch in make.com airtable and you could have this up and running in the next hour now before we get into actually building out all of these different automations and actually building out this air table system I'm going to build out every single column live from scratch let's talk a little bit about how works it all starts in this slack Channel where I can simply record an audio note using this icon here I simply talk very casually and I tend to ask myself a couple of different prompts which I'll show you later in the video that just makes it super easy there's no pressure sometimes I might even actually go out for a walk and then once I'm done recording this audio then an automation will look for those audio notes and then it will download the file it's going to create a transcript it's going to extract the main points and I'll show you why I do that later and then it creates a a row in air table right here in this table here called speak and then it simply drops that transcription into a row here and so over a period of time you're going to have a bunch of different transcripts in here from your slack recordings from there the automation is going to continue to run and go down these four different paths to create post for LinkedIn and Facebook X and Twitter the carousel images for Instagram and then the vertical video for the Instagram real and so if we jump back over to air table and then we jump to the social side we can see the post that it generated right here here in this column here we have the content then we have the platform the type of content it is and then a status where we can review it approve it and then finally once the automation runs it'll mark it published and we also just keep track of when it was created and last modified now what's nice about the way I built this system is that you don't actually have to schedule any of this content and pick a publish date or anything like that we have a Automation in air table and I'll show you how to build this from scratch but it just runs at some interval that you give it it could run once a day twice a day and then it's going to find a single post that is ready and approved so once we approve something here it's going to look for that content in this published view you can see here we have this automation that is looking for an approved post and then we have this script here which is going to make a call to make.com which is going to then trigger the process to publish it to either LinkedIn Facebook Instagram or Instagram reels or Twitter really based off of this platform and where it's supposed to go some of the automations are more straightforward like LinkedIn and Facebook where we're simply publishing a text post but for Instagram we need to Loop and create images for each page in the carousel if I click here we can see that example here that's what this automation is doing before it finally publishes it and then for the vertical videos and these reels this automation here is taking the content from this here and then it's generating audio in my voice it's uploading it to Google Drive and then it's using this platform here Json to video to take this Boll video that I have here that's stored on Google Drive where it adds the AI voice over mistakes to avoid with AI in your business so and then it adds the captions and then finally after it builds that video it automatically pushes it to Instagram and X is pretty straightforward it just posts one of the tweets that was generated here after you mark it approved and again you can review the content of any of these posts before you actually approve it for publishing where this automation will then trigger and pull it through and send it to this automation which creates the assets and does the publishing and finally the last piece of this automation it simply goes back into a table and marks these post that were approved for publishing to published where then you can then track all of those in this view here all right so let's dig in I'm going to build out these automations from scratch but if you would like access to the entire blueprints to these automations so you can simply import these automations just by clicking a file and uploading it and getting the entire thing built out for you to save a ton of time as well as access to my speak to social air table base that has everything already built out including these automations make sure to check out my new community the no code architects I'm building out a huge template library of automations just like this and you'll be able to get access to these automations and the air table base I've got a link that'll take you right to the community in the description below so let's start from the very beginning I'm now in slack if you don't have a slack account go ahead and create one and then you can create a channel I created one called speak to Social and then I simply used this little icon down here to record some audio notes directly into that channel now keep in mind there's a super easy way to record these audio notes you don't have to be prepared you can go off the the top of your head you can even make mistakes take pauses chat GPT will clean it all up in fact you can just grab your phone and go on a walk and record directly into the slack mobile app and these are the basic prompts that I give myself as I'm recording to produce good content through the automations I just have a statement where I say if you want this thing then I talk about the main problem that people have attaining this thing and then I talk a little bit about why I'm the authority to speak on this topic and the number one mistake people make and then I talk about that there's a better way to do this thing that they want and then finally I give them the steps to achieve this thing so that's a basic format that you can use it makes it super easy super low pressure so you get that audio recording into slack so that we can then continue on with the automations so the first automation we need to add is for slack I'll go ahead and click that and then we're going to watch for private Channel messages if you don't already have a connection you'll need to add that and then for input method you can leave it as a list and we're going to select a private Channel notice you'll see mine here speak to social go ahead and grab that you can leave the limit on two you can go ahead and click okay now you will need to record a test audio so go ahead and do that feel free to use this basic script and prompting method that I gave you earlier if you have something real it's going to make the output of our automations better and then we're going to go ahead and run this automation manually go ahead and right click and say choose where to start go ahead and click choose manually we'll be doing this quite a bit it's going to load up the audio recordings that you have already recorded go ahead and pick that top one click okay and then down here you can say run once that's going to run the Automation and pull in that first audio recording so we can continue to build out the automation the next thing we need to do is is actually download that audio file so go ahead and add another slack module then you can scroll down to download a file and then for this we're going to use the file from Step number one go ahead and click into this go to files and then you can click URL private download and click okay now here you need to add a filter so that we only continue if that file exists add a condition you're going to look for the file and then you just need to make sure that it exists pick exists and then you can go ahead and click okay now the next thing we need to do is create the transcription from the downloaded file so go ahead and go to chat GPT open Ai and then you're going to scroll down to create a transcription make sure not to pick create a translation and then it should automatically detect that we have a file from slack you'll want to use the whisper model you can leave the prompt blank and response format as Json go ahead and click okay and then in this next module we're going to use chat GPT to create the main points of the audio so we're going to look at the audio and just extract all of the main points so so I'm going to go here to create a completion I'm going to use the new 40 model right here for Max tokens you can put in zero I'm going to go ahead and add a system message here and then I'm going to just cut and paste this in from my other automation you are a detail oriented person who can extract all the details from written content and then I'm going to go ahead and add another message this will be a user and then I'm going to cut and paste this in for my other automation template and we're going to extract all the details as bullet points from the text below and we're going to use the result from the transcription so we see here I'm going to go ahead and add the text and then I will go ahead and click okay and now from here I'm going to go ahead and save the automation make sure you're saving periodically as you go because if you leave this page it will be lost and then I'm just going to run everything to make sure everything is okay I'm going to go ahead and go to choose where to start choose manually going to pick that top recording here and then I'm going to go ahead and just click run it was able to get the file it downloaded it now it's creating the transcription and now it's creating the bullet points so if we come in here now and we take a look at the result now we have all of of the main details from the audio transcription and I just like to use this in my future prompts to make sure that chat GPT always uses all the details as it creates content and now the next thing we need to do is actually create the row in air table to store this transcription so I'm going to jump into air table I'm going to create a new base from scratch you have to select a workspace I will select production and this is what a new base looks like I'm going to go ahead and close this I'm going to rename the title here to speak to social demo then I'm going to go ahead and build out this entire table from scratch I'm going to rename this view to spoken word then I'm going to rename the table to speak I'm going to change this main column here which is the primary field to an auto incrementing field I'm going to call it the speak ID I'm going to rename the notes to transcription I'll leave it as a long text I will click save I'm going to go ahead and delete this default field that came in when we created the table I'll go ahead and delete this one as as well and then I'm going to create a new field for created time just to have that as a reference if you leave the field name blank then it will simply just give you one for you so that's all we need now I'm going to jump back to the make.com automation now the next thing we need to do is to create a new row in our air table database create a record next I need to create a connection for the new base I added in air table I'm going to go to air table oo I'm going to give the connection name speak to social demo click save going to expand this window so I can see it better I'm going to add a new base going to look for that base speak to social here it is I'm going to add that base I'm going to Grant access it's going to add that connection then I can select the base speak to social demo then I'm going to select the table speak and I'm simply going to drop in the transcription from the previous step make sure not to grab this one which was the detailed bullet points I'm going to grab the transcription then we can go ahead and click okay then I'm going to zoom back out just a little bit and I'm going to rerun this just to make sure everything's working choose where to start choose manually going to grab that top STP audio recording click okay run the automation what we should see is a new row coming into our new air table base while that's running I'm going to go ahead and delete these default ones that were created come back to the automation looks like it ran to air table so now we have a new row which is our transcription so so far so good I'm going to jump back over to make and then continue to build everything out next what I'm going to do is I'm going to build a router this allows us to create multiple paths for different automations I'm going to add another chat GPT complete here in this case we're going to write the LinkedIn post again I'm going to pick the chat GPT 40 model I'm going to go ahead and add a new message I'm going to go ahead and pick the system roll I'm going to go ahead and copy and paste the prompt from my template automation I'll expand this a bit it just simply tells the automation that you're an expert content and Automation and AI expert you like to create audio brainstorming notes for ideas and convert them into written content and then I give it some guidelines what the post should look like and how it should be formatted and then some additional guidelines that I want to make sure the post has looks like I got a little cut off there so I'm going to come back to my template make sure I got everything I don't want it to include hashtags or emojis so I just detailed everything that I wanted for the Post then I'm going to go ahead and add a new message the roll will be user and then I'm going to cut and paste my prompt from my template into this message here and it simply says take the transcript Below in quotes and write a concise LinkedIn post and then I say use the detailed points below as reference to make make sure you included all the important details and I do need to replace this because it was from a different automation so I'm going to place in the text from the transcription and then I'm going to replace this with the actual details from this previous step here before I can click okay I got to add in the max tokens put in zero and then I'll go ahead and click okay again and then next up what we need to do is we need to create the actual social Post in our air table database so I'm going to jump back to air table and build out the second half of our air table database which is the social side so I'm going to go ahead and create a new table start from scratch we'll call this social go ahead and click save now for the primary column I'm going to make this an auto incrementing field as well I'm going to call this my social ID I'll click save I'm going to rename this to content leave it as a long text go ahead and click save I'm going to go ahead and delete these other columns and then rebuild what I need from scratch next I'm going to add a platforms column I'm going to go to single select I'm going to type platforms then down here I'm going to add a few options I'm going to add Instagram real LinkedIn X Twitter Facebook and Instagram so that we can differentiate between an Instagram post and a real then I'll go ahead and click create field and now we have all of those options here next I'm going to create a column for type so we can keep track of that I'm going to add another select field we'll call it type here we're going to add three options text image and video I'll go ahead and click create field now we're going to create a nether column for the status another single select we'll say review approved and published we'll go ahead and click create field then I'm also going to create a created time roll down here to created time you can leave this blank it make that for you then I'm also going to create a column for modified time scroll down last modified time just so we have that and then finally what we need is a way to link this table back to the speak table because every time we add a transcription we are going to link that transcription with all of the social posts that we create for that transcription so I'm simply going to come here you can do it really anywhere you can add it here if you'd like but just so it's not at the end of the screen I'm going to add it here I'm going to go ahead and insert to the right I'm going to link to another record I'm going to link to speak we don't need to allow to linking to multiple records and I'm simply going to call this field speak I'll create that field you can go ahead and Skip and now we have this column here and now if I jump back to the speak table we're going to see that we also have a link to the social table and both of these you can hide this if you'd like because you don't actually need to see it come back to social we're going to hide this one as well hide field and now we can come back to make and our Automation and we can finally create that row let's add the next automation here we're going to add the air table row we're going to create a record in this case we're going to pick the base we're going to pick the same base again speak to social demo this time for the table we are going to pick the social table for Content we are going to use the result from this previous step you can just grab that result for platforms you can uncheck this and then we can hit LinkedIn now in this case I realized we need to change this field type in air table because we can select multiple platforms so I'm going to come back here going to adjust this to edit and turn this into a multiple select I'll click save come back to the Automation and I'm going to go ahead and refresh but now if I turn off this map it will allow me to add multiple values so we have LinkedIn here I'm going to uncheck this just so I can select it from the dropdown then I'm going to add another item here I'll unselect this again so I can use the drop down and then I'm going to pick Facebook for the type I'm going to unselect this map so that I can select from the drop down I'm going to pick text for the status again I'm going to uncheck this map so that I can select from the dropdown and I'm going to pick review and then here we need to attach this specific record that we're adding to this table social to this previous transcription that we already created so here we are going to add an item and for the record ID we are going to use the record ID that we created in Step six so go ahead and click into that we'll click this ID here and this should be everything that we need we can go ahead and click okay I'm going to go ahead and click save we've done quite a bit of work at this point going to zoom back out a little bit go back to that first module choose where to start choose manually click this first object which is the most latest recording and then I'm going to go ahead and click and run this automation create the transcription then we're going to create the details it created the transcription row now it's creating the actual post and now it created the social Post in our error table database so now we have a new row in in our speak for that transcription and if we jump over to social we are now going to see our new social post and if we click in here we can see the content that was written from chat GPT I'm going to go ahead and remove these blank rows that were created in the beginning I'm going to go ahead and just adjust the sort so that it's always putting the most recent rows on top I'm going to do that on the speak side as well go to the sort go to the speak ID all right so now we're rocking and rolling let's just keep going and get through this automation so now we've got a couple more to build now we're going to go ahead and build out the Tweet so I'm going to create another chat GPT completion here create a completion going to go ahead and use the same model here we're going to use chat GPT 40 going to add a new message for roll we're going to use system going to copy in the prompt from my example basically we're just saying you're an expert social media content writer and some additional guidelines that are very similar to the ones before We'll add another message for the role we're going to use user I'm going to copy this from my template automation we're going to read in the transcription we're going to create one concise tweet for each of the important points that we created here I'm going to have to fix this here and make sure I'm actually grabbing the transcription which was in Step number three so I'm going to use step number three here click on the text then I need to replace this from the automation because I cut and paste it from my other automation which is not here so we're going to use step four right here for Max tokens we're going to put zero and then we can go ahead and click okay and continue now we just need to write this back to air table like we did before I'm just going to go ahead and cl clone this and just change what I need might be a little bit easier I'm going to have to change everything here I have to replace anything that was used in this step I'm going to have to use this step instead so I'm going to grab this result instead of the one that was there that's why it looked the way it did with no color in this case I'm going to delete these two platforms I'm going to add a different platform I'm going to uncheck this this is an X and Twitter tweet the type is text we're going to leave the status in review we can use the same transcription row that we created in air table so that should be good to go I'm going to go ahead and click okay go ahead and click save I'm not going to test now I'm going to go ahead and continue to build all this out and then we'll do one final test and correct any issues that we had at that point so I'm going to create another route there go ahead and align it going to make another chat GPT completion open AI create a completion going to use the model 40 as always going to add a new message in this case I'm going to go ahead and just use a user message and right now what we are doing is we're creating the slide deck messages for the Instagram carousel so I'm going to put in a prompt here say read the transcript below and summarize it into five main points that are 15 words or less so then when we create those slides we'll have a succinct sentence on each one then I need to add the transcript so I'm going to come down here and add that for Max tokens I'm going to go ahead and put zero and then I can go ahead and click okay now we need to create the a table record for that post I'm going to go ahead and clone it add it to this route here then let's change all the information relevant to this again we're going to have to change the content so I'm going to take that out and add the content from here this time it's going to go to Instagram so I'm going to go ahead and remove that add a different platform remove the map and then select it here Instagram make sure not to pick real that's for the video for type we're going to change this to image and the status can stay in review and we can go ahead and click okay so one more automation to add for this first part of this system now I'm going to add one more route chat GPT completion again we're going to use the 4 model we're going to add the message for the roll I'm going to go ahead and use user now in this a here I'm building out the voiceover script for the video that we're going to create for the vertical video on Instagram reals so I'm going to copy over my prompt from the other Automation and I'm going to say read the transcript below and summarize it into a script that if read aloud would be 18 seconds or less and I just said that because the b roll video that I'm going to put this audio on top of is only 28 seconds so I just wanted to make sure it was less than that and then I need to add in the transcript so we have that then I can put in the max tokens to zero go ahead and click okay then we need to add in the air table row I'm going to straighten this out just a little bit clone this air table row connect it up here and we need to fix everything again we need to change the content to the content produced in this GPT here I'm going to change the value of the platform to Instagram real the type is going to be video and the status will come in as review so now I can go ahead and click okay and save it and the reason why I'm not building the graphics or the video in this stage is so that when we add the content to our social table we'll have a chance to update the text and the content before we click approve and that ultimately runs the automation to push it to social media so I'm going to go ahead and save this back out a little bit let's go ahead and run this from the beginning I'm going to choose where to start choose manually I'll pick the most recent voice note click okay and then let's go ahead and run this and see if we have any errors it's creating the transcription now I created the row and air table of that transcription we have that right here actually that was right here now it's actually creating the individual posts and now it's gone through each of the different automations and we can see that we have those five new posts just created right now so now we can format the table just a little bit and then you can always look inside of the various pieces of content that is being created and then you can tweak it you can come back and you can tweak your prompts to generate the type of content that you want we can see what platforms that everything is going to be distributed to once we set up the automations and then we create the new make automations to create the content to create the videos the images and then to actually post everything once we adjust the status to review so on that note just to get ready for the next step I'm going to go ahead and create a couple more views here I'm going to rename this one to approve then I'm going to duplicate this to publish and then finally one more to published and then I'm going to adjust the filters of each of these I'm going to go to approve and add a filter where we only see the status of review and then here we want to make sure that we only see the status for approved and then here we want to see only the status for published that way if we come here and we approve something we'll see it here and then if something's published we'll actually see it right here and by the way if you're finding this video valuable make sure to like And subscribe to the channel it tells me what type of content you want more of all right so now let's build out the rest of the automation all right first let's go ahead and save this automation make sure you do that I'm going to go ahead and rename this to Slack to air table I'll save that then we're going to go ahead and move on to the next automation which is going to do the auto publishing from Air table based on the platform and the type of content it is and once it's approved so I'm going to go ahead and create a new scenario and remember if you want to get access to These Blueprints so you can simply come in and import this and click a couple buttons and have these automations completely built out and ready to go make sure to join my new community link is in the description below now if we're starting from scratch then we're going to start with a web hook so we're going to click that and we're going to go to custom web Hook from here you're going to go ahead and click add you can go ahead and click save it's going to give us a web hook we'll come back and grab that in a second make sure to click okay so that it saves that step once you have this web hook we can jump back over to air table and start building out the automation here we need to build out the auto publish automation that will run at some scheduled time and what's nice about this is that instead of having to pick a scheduled time for all of the content we can simply just create an automation that will pick one of those ready posts and we'll post it at some specific interval that you choose so I'm going to go ahead and pick an interval of one post every day and I'll just pick 8: a.m. you can really pick any interval that you want then we're going to go to the next step and find rows in this case we're going to find rows in the social table and we're going to find records that are based off of a condition and that condition is simply that the status is approved so we're going to adjust that and pick a status approved and then in order to test this automation you can go ahead and click Test action now if you get Zero Records found that simply means that back in the data here and in this social post area we don't have any approved content to publish so I'm going to come back to published I'm going to move everything that might have been here to review so if I come up to review we should have five different posts I'm going to go ahead and start with the LinkedIn and Facebook posts and while I'm here I'm also noticing that I made one mistake here with the Twitter Tweets in that it didn't separate them into individual posts so I'm going to jump back back over to our automation here and I need to add a module here that is going to split up the text from chat GPT and convert it into multiple tweets instead of just one big piece of text so I'm going to add a text parser here we're going to pick match pattern I'm going to copy in this pattern right here we're going to move this to Global match we can select case insensitive we can leave the rest of these as they are and then we'll just want to take the result from the previous step and click okay and now let's go ahead and click click save and then let's back out just a second here and again let's run this automation one more time choose where to start choose manually pick that first option there and click the automation this time when it runs it's going to create multiple Twitter posts in one chat GPT completion and then this is going to break it up and as you can see it added three rows to air table instead of just one so if we come back to air table and we see here the old one that we had we can see the tweets were all added to one piece of content whereas now we have multiple tweets and it broke each of those up into different pieces although I'm seeing one additional bug here that we need to fix in air table we need to use the results from the text parser not this result here so I'm just going to jump in here and for the content going to erase that and add in this dollar sign click save then I'm going to go ahead and choose where we start choose manually click okay and then run once going to run that and then this time when it breaks up those tweets into individual tweets it will save the result from here and put that into air table instead of what I did before which is I even though I broke up the text I still was saving this one into air table so now we're creating those tweets it breaks them apart and now it's actually writing those individual tweets now we have four tweets and they're all different so now that we have the correct results I'm going to go ahead and just delete some of these old rows here just so they're not in our way and now we have a fresh set of results to continue building our automation here so now I'm going to jump back to a table go back to the Automation and let's go ahead and start with the LinkedIn and Facebook post I'm going to go ahead and move this to to approved now it's going to show up in this view here now if I come back to the automation again remember we have a automation that will run every day at 8: a.m. and then it's going to find a approved post so now we can go ahead and test this action and now we have this record so now I'm going to go to the next step here and I'm going to run this script what this script is going to do is that it's simply going to take the information from our row that we just found the approved row and it's going to call this web hook on make.com side so that we can continue on with the automation so to make this work I'm going to edit the code I'm going to copy that code and paste it into this script area right down here and then I'm going to come over here and we're going to add a variable if you want to pause the video and copy this step by step or you can jump into my new community and get the template for this entire database I'm going to type social ID then for the value here I'm going to hit this plus button I'm going to go to this step here find records I'm going to scroll down to air table record ID and now here I want to test that this automation is working so I need to come back to make.com I'm going to go back inside of this automation here and I'm going to grab this web hook I'm going to copy address to clipboard I'm going to jump back to air table and I'm going to add that URL right here where it says web hook URL going to drop it right here in the quotes I'm going to jump back to make I'm going to click okay and I'm going to go ahead and run once so it's waiting for a request jump back to air table I'm going to go ahead and click test the test ran successfully if I jump back to make we're going to see that we have a new request that came in and we're going to see that it passed that record ID into make and now we can go ahead and grab that record from Air table and continue on and if we jump back to air table we can see what's going on here is that we passed the social ID which is that record ID from this step here where we found the record that was approved so it's basically getting the record ID for this row that's approved and it's this script here that calls the remote web hook here and passes This Record ID here that's why we added this variable here so that it can pass it into the script and ultimately pass it to the web hook which allows us to access it here if you don't understand all of that it's not necessary but if you just copy this exactly how I did it it should work just fine and now we can continue on with our automation the next step we need to do here is to load up the record that we are working with so I'm going to go ahead and click air table I'm going to get a record you need to make sure to pick the connection that we are using previously I'm going to use my speak to social demo for the base you're going to pick speak to social for the table you're going to pick social and for the record ID you're going to use use the record from Step number one here record ID then you can go ahead and click okay and now what we're going to do is we're going to create a route so that we can Branch off and post to the various different platforms depending on the platform that was listed in this multi- select variable here so let's go ahead and work on the LinkedIn and Facebook first here I'm going to add a new router here I'm going to use the LinkedIn module you're going to want to create a user text post if you don't already have a connection you'll need to add that here and then for the content you're we going to use the content from Step number three so you can add this right here for media type you can leave that blank visibility public pretty much everything here you can leave as default you can go ahead and click okay we do need to add a filter here so that only the posts that are for LinkedIn will go to LinkedIn so go ahead and click here then right here you want to add platforms from Step number three right here you're going to want to scroll all the way down to the section where it's talking about array operators because this is an array so we need to look inside of that array and make sure it contains LinkedIn then we can go ahead and click okay and now we're going to go ahead and add our Facebook post so you can type Facebook in this case I'm going to post to my Facebook page I'm going to create a post if you don't already have a connection you'll need to add your own connection here then you'll be able to select what page it is I'm going to paste to the content engine for the message you're going to want to use the content from Step number three go ahead and pick content and then you can go ahead and click okay and then you'll need to add the filter for the condition you're going to add the platform and then here again as you did before you're going to scroll down to the array operators contains Facebook and again if we go back to a table you're going to see that that's just matching here LinkedIn and Facebook and that's exactly what we added here that way when this automation runs and it's for a specific platform it only goes to those platforms you can go ahead and click save now let's just incrementally go through each of these so this one's ready to go so if we come back to our Automation and we scroll down we should be able to test this action I'm going to come back to make I'm going to go ahead and run once then I'm going to come back to air table I'm going to test the action come back to make so now it posted to LinkedIn and it posted to Facebook so if I go to LinkedIn and then I go to my feed we can see that that post is right here here is a test I did earlier that I showed you and then if I jump over to Facebook we can see that I just posted to my content engine page the same post that went to LinkedIn so now believe it or not we're getting near the end here so let's just keep moving along now we have to build out the the carousel images for Instagram so now I'm going to go ahead and add a new route I'm going to go ahead and set up this filter up front for the condition again I'm going to pick platforms remember I have to go to the bottom here array operators contains Instagram go ahead and click okay then I need to add an iterator so here's the iterator I need to iterate through each of the different slides that we created in the content here so if we come back to our Instagram post I'm going to go ahead and move this to publish so it's no longer here if I come to the Instagram post here we are going to see that we have three slides that we created in the content so we need to Loop through each of these and separate them to create five different images I'm going to come back to the automation so if we come here to the array and then we go to Strings we can select split so you want to grab that split and then here what you want to do is you want to add the content from this stage here so you'll come back to this star and then we're going to add in the content right there and then you're going to come into this little spot here you're going to come back to the a and you're going to add a new line and then what that's going to do is that it's going to take this content and every time there is a new line here it's going to break that up so that we can create the social media graphic so I'm going to come back to make I'm going to go ahead and click okay now I have to add a new module for Placid I'm going to go ahead and click Placid in this case we're going to create an image then if you don't already have a connection you'll need to add a connection and the way plastid works is that you create various different types of projects notice here I have a project here called social graphics and inside that I've got a few different templates I'm going to be using this one here called the square Carousel and the way their connections work is they end up connecting to a specific project so you can see here in my connections I have three different connections and it's because I enabled three different projects here to be exposed to the API so you want to make sure that you come into the project that you create that has the template that you create and you're going to want to create an API token that allows you to connect up to make.com so now I'm going to go ahead and select the temp template I'm going to pick the square Carousel and then for the text I'm going to go ahead and select the value from the iterator I'm going to leave the text color blank I'm going to go ahead and click okay then I can go ahead and add the next step which is to close out the iteration I'm closing the loop here and so for the source module I'm going to go ahead and pick the first stage of the iterator and I'm going to click okay so in order to properly configure this iterator here I need to add this step so that we can configure it here so I'm going to go ahead and add in the Instagram post right now I'm going to go ahead and click Instagram for business I'm going to create a carousel post if you don't already have a connection you're going to need to add one I've already have my Facebook connection it actually connects through a Facebook page through to your Instagram account there's instructions on how to do that here and here now in order to save this I do need to put in some dummy values here so I'm going to go ahead and add an image and then for the photo URL I'm going to use HTTP test.com image.jpg I'm going to cut in paste this we're going to come back and replace that but we just need this for a second then I'm going to go ahead here and add another item an image I'm going to put that same test here so that I can save it and now I'm going to go ahead and save this automation I'm going to come back up to air table in this case I'm going to move our Instagram post from review to approved so I'm going to come back to the Automation and find record so you need to click find records and we're going to test this action so that it finds the new Instagram post if you don't click test it's going to re use the LinkedIn and Facebook post from before then I'm going to come back to make.com I'm going to go ahead and click run once if you ever get this notice it's just telling you that there's already something in the queue there's something waiting here in this case I'm going to wait for new data so that I don't get old data that may not be what I want wait for new data I'm going to come back to a table I'm going to click this run a script I'm going to test that action going to jump back to make we see that it's now going down the path for Instagram it's creating the images it's going to create all five of those images once it creates those it may try to post that to Instagram but it's going to error out because of the dummy data we gave it you'll see that it AED out which is fine but really what we wanted is we wanted the test data here so that we can properly configure these last two steps so now I'm going to jump into the iterator here and now for Target structure type I'll now be able to add the Instagram for business files array and then we can configure what do we want to send to the media type and in this case we're going to select image and then for that photo URL we are going to use the image from plid so you can use the image URL and then we can go ahead and click okay and now we can come back to this module and properly configure it we can remove these two items then we can move this to map and for this field here we can simply use the array from that iterator and it's going to set up all the data properly so that it'll properly post to Instagram and map in the proper Fields what type of media it is and the image URL from Placid we can go ahead and click okay we can go ahead and click save now I can go ahead and click run once again again again I'm always just going to wait for new data jump back to air table I'm going to go ahead and run that test again jump back to make.com now it's creating the images I'll go ahead and load up Instagram just so it's ready going to go to my profile we already posted a carousel previously today but we should now see another one once this is done creating that fifth image and now it's posting it to Instagram it should just take a second looks like that was successful so if I jump back to Instagram and refresh the page we now see a new Carousel was automatically posted and it's got those five pages that was created from that original audio post that we made way back in slack all right so we're in good shape now now we just got a couple little automations to add I'm going to go ahead and click save now I'm going to jump back to air table I'm going to go ahead and move the Instagram to published and now let's go ahead and move forward with the Instagram reel these tweets are quite easy and I'm going to move this to approved that way we can go into the automation I'm going to move back to find records and I'm going to test the automation so that it pulls in the Instagram reel for testing so now we have that ready for when we want to run the script now I'm going to jump back to make.com I'm going to add another route I'm going to go ahead and start with 11 labs this is going to allow us to create a speech synthesis from AI in this case I have already pre-loaded 11 Labs with my voice so that when I pass it text it will create a audio track with my given voice you can check out how to do that using 11 Labs I'm going to go ahead and select the 11 Labs multilingual version 2 then for the text I'm going to pass it the content and then I'm going to click okay and then before I forget I'm going to add the filter here the condition is on this platform and then I'm going to change this to the array operators contains Instagram re which again is what we have right here Instagram real I'm going to go ahead and click okay I'm going to go ahead and straighten this out and we can continue on with the automation just going to double check that I have everything set up right in 11 la I think on this model here I'm actually going to pick 11 Labs multilingual version 2 this one here not the STS I think that will cause an error I'm going to go ahead and select that here click okay I'm going to go ahead and test where we are right now just to make sure that this works here I'm going to save then I'm going to go down here to run once I'm going to jump back to air table and now that we have our Instagram real in the approved section I'm going to jump to the automation if you haven't already you want to make sure you find that record using the test here make sure that's the one that comes up in Step number two then you can actually run this script here and test it jump back to make.com it's going to run that synthesis you want to make sure that it came back with the actual data now what we need to do is we need to save that audio in Google Drive so I'm going to add a Google Drive connection here I'm going to upload a file if you don't already have a connection you want to add that I'm going to go ahead and just use a folder that I've been using for testing you can create any folder on your Google Drive I have one here from speak to social you grab this ID up here in the URL make sure to grab the entire ID copy that go back to your automation drop that in the folder it should link up the file from the previous step you can click okay then we need to create a public share link for that file so go ahead and add the next step going to go to Google Drive you want to get a share link you can use your drive select your file for file ID we're going to use the step before here in Step 13 file ID the role is reader for type we're going to say anyone with the link we should be good to go there you can go ahead and click okay then in this next step we are going to actually call Json to video you can create an account here to get an API key then on this step here we're going to create an HTTP module we're going to make a request for the URL you can use this here you're going to use the post method for the headers you're going to add in your API key and then for body type you are going to pick raw content type you are going to pick Json and then for the request content you are going to drop in this entire piece of code just like this just for easy copying pasting I will put this in the description below but if you want access to this then make sure to jump into my new community that's Linked In the description I'll give you the make.com files the air table database and all of these different pieces that we're putting into these automations here we do need to replace a couple values in order to create this vertical video I do have this vertical b-roll footage of me sitting at my desk it's just simply me moving around and doing a couple things you can use whatever you want but you do need to grab that ID from that file so if you open this up and you go to share you also want to make sure that you make this publicly available so make sure you change that to anyone with a link and then if you copy that link and then put that into your browser you should be able to copy that ID Straight From Here make sure you copy the ID everything after the slash and up until the slash don't include any slashes so you want to take that ID that you copied you want to replace that ID here right after the equal sign and up until that little Ampersand just remove everything here and paste in your ID and then down a little bit lower where you see the audio and the source you want to copy the link from this previous step the share link from this step here go ahead and copy that in although if you haven't run this automation yet that value might not be there so you can feel free to use the link from Step number 13 which is going to be the web content link you can actually type that in here uh it does look like it's showing up here in Step number 14 so you can go ahead and copy that make sure you click that link so it goes right in between those two quotes put your cursor there click that then you should be good to go you can go ahead and then move this to pars response is yes yes go ahead and click okay now let's go ahead and just click save and make sure everything is working I'm going to zoom back out a bit and then click run once then I'm going to jump back to air table and Trigger this step one more time should come into make and then come down to 11 Labs it's creating the voice it's uploading the file it's creating the share link and now it's calling Json to video if you open this up you should see a status code of 200 that means that you cut and paste the code correctly and you properly replaced the web share links and the Google Drive links for the b-roll video and the audio that you saved from 11 Labs now we can go ahead and continue on I'm going to go ahead and add a sleep to this section here once you call this call here Json de video is going to be building that video in the background so we need to take a quick pause and let that finish so I'm going to type sleep I'm going to go to the tools here I'm just going to go ahead and put 90 seconds and then click okay we're almost done then we need to make one more HTTP call to get the video so that we can actually call Instagram so I'm going to add one more step step here HTTP I'm going to make a request for the URL I'm going to cut and paste this URL here we can leave this as a git for the headers we need to add our API key again you would get that from creating an account at Json to video in this case we need to add a query string for the name we're going to add project and for the value we're going to use something that was returned in this previous step from our test you should see the output just like this because we told make.com to parse the response with a yes so here you're going to use the project and again here you're going to want to use parse response yes and then you can go ahead and click okay and now we can run this manually just to see if the video was properly created by coming over to this response coming back to the data here and grabbing this project ID just select everything there copy it and then come to this and do a run this module only it's going to ask you for that project ID go ahead and paste that in there and click okay should run that module go ahead and open this up should see a status code of 200 I can go into the data here I can go into the movie I can grab this URL straight from this section here copy it I can go to my browser put that in there here the video pops up we can see the captions and it's using the audio from 11 Labs which was my synthesized voice mistakes to avoid in using AI in business first don't ignore AI staying out of the loop sets you back all right let's keep going we're almost done here and then in this last step here we simply need to call Instagram to make that post Instagram for business we're going to create a real post you want to connect up your connection and for the video URL we're going to use the video in the previous step go ahead and go into step 17 movie and there's the URL you can leave the caption and these other things blank you could of course create automations to fill those in if you would like go ahead and click okay now let's go ahead and make sure you save that let's do one final test let's go ahead and run this jump back to air table and run that trigger it's creating that audio calling Json to video now it's going to pause for 90 seconds now that it's done sleeping it's made the request to get that file and now it's making the post to Instagram and might just take a few minutes for that upload to take place looks like that is done so if I jump back to Instagram refresh my page jump down to reals we're going to see that new video was just posted 20 seconds ago we got the b-roll we've got the captions and we've got my AI generated voice over on current AI models be ready to adapt to new advancements quickly Embrace changes and continually amazing all right so let's go ahead and save this make sure you do that and let's just finish this out really quick we w we have a very simple one to add at this point I'm going to add two more routes one of them is just simply to Mark any of these given posts that we're creating as published so that that's done automatically so I'm going to go ahead and add that right now you want to make sure it's this final automation because that's going to be the one that runs last just going to click into here go to a table going to update a record going to pick the base speak to social for table we're going to pick social for the record ID we're going to use the record ID from the web hook and then we're going to just jump down here to status going to remove the map and we will pick published select okay go ahead and save that that rearrange the Automation and now all we need to do here is post our automation for Twitter so I'm going to go in here to the condition and add in platforms and then I'm going to change this down here to array operators contains and then remember for Twitter we go to approve platform is x/ Twitter so I'm going to come back to the automation x/ Twitter I'll go ahead and click okay then I'm going to come back to air table I'm going to go to publish I'm going to move the Instagram real test to published then I'm going to go back to approve and move one of these tweets to approved I'm going to go to the automation I'm going to reselect a new approved automation Test action we should see the Tweet pop up now I'm going to jump back to make going to add the Twitter module right here we're going to create a post Now setting up Twitter is a little bit more complicated make sure to check out these help Pages it will show you how to create an app and connect up to Twitter it's a little confusing but it's not that hard if you'd like another video on that let me know as long as you follow their instructions you should be good now we can come back in here to the text content we're just going to add content we can go ahead and click okay we can click save I'm going to Auto align everything again as well I'm going to go ahead and run this once jump back to aor table go to run a script Let's test this action it's going to come in it's going to send that to Twitter and notice it's also going to move that post out of the publish automatically now it's going to be in published so we don't have to do that on our own here's that now we just need to go to Twitter to see the new Twitter post that we just came came out with 19 seconds ago now what we need to do is come back to air table we're going to go to this automation we're going to turn it on we're going to adjust our schedule as needed going to come back to our original make.com automation that searches for new audio from slack we'll turn that on we'll come back to this automation that we just built we'll turn that on and now the next time we come in here and make a new audio recording that will be loaded up by this Automation and keep in mind that this automation will run every 15 minutes if you want it to run sooner you can adjust that just keep in mind that every time that this automation runs it does use one of your make operations so you want to be conscious of that but that will trigger the entire process it will create the transcription it will create all of the different posts after you review them and approve them this automation Once you turn it on will automatically pull them in at the given schedule and we'll call this automation which will send and create the various pieces of content that we need and publish them to the various platforms and again if you want to just get access to These make.com Blueprints so you can just downlo download them and upload them and just install that air table automation so that you can get this up and running in just a couple minutes make sure to join the no code Architects the link is in the description below click on that join you can get access to these right away this is a brand new community I'm excited to see you there and either way I'll see you in the next video

in this video I&#39;m going to show you automations that can automatically create and publish content to LinkedIn and Facebook Twitter and X these image carousels to Instagram and vertical videos for Instagram that take b-roll and add captions and AI voiceovers and it&#39;s completely 100% automated all by uploading some voice notes into a slack channel that are imported into air table where you can review all of the content and even review it before it&#39;s published I&#39;ll explain how to build these automations step by step how to create the images the AI voiceovers and the vertical videos with captions using Json to video and how to publish to LinkedIn Facebook Instagram reals and Twitter all automatically I&#39;ll even explain how to record these audio notes so it&#39;s easy and chill so that you can start creating content and grow your business today it&#39;s way more simple than you think I&#39;ll show you how to build this all from scratch in make.com airtable and you could have this up and running in the next hour now before we get into actually building out all of these different automations and actually building out this air table system I&#39;m going to build out every single column live from scratch let&#39;s talk a little bit about how works it all starts in this slack Channel where I can simply record an audio note using this icon here I simply talk very casually and I tend to ask myself a couple of different prompts which I&#39;ll show you later in the video that just makes it super easy there&#39;s no pressure sometimes I might even actually go out for a walk and then once I&#39;m done recording this audio then an automation will look for those audio notes and then it will download the file it&#39;s going to create a transcript it&#39;s going to extract the main points and I&#39;ll show you why I do that later and then it creates a a row in air table right here in this table here called speak and then it simply drops that transcription into a row here and so over a period of time you&#39;re going to have a bunch of different transcripts in here from your slack recordings from there the automation is going to continue to run and go down these four different paths to create post for LinkedIn and Facebook X and Twitter the carousel images for Instagram and then the vertical video for the Instagram real and so if we jump back over to air table and then we jump to the social side we can see the post that it generated right here here in this column here we have the content then we have the platform the type of content it is and then a status where we can review it approve it and then finally once the automation runs it&#39;ll mark it published and we also just keep track of when it was created and last modified now what&#39;s nice about the way I built this system is that you don&#39;t actually have to schedule any of this content and pick a publish date or anything like that we have a Automation in air table and I&#39;ll show you how to build this from scratch but it just runs at some interval that you give it it could run once a day twice a day and then it&#39;s going to find a single post that is ready and approved so once we approve something here it&#39;s going to look for that content in this published view you can see here we have this automation that is looking for an approved post and then we have this script here which is going to make a call to make.com which is going to then trigger the process to publish it to either LinkedIn Facebook Instagram or Instagram reels or Twitter really based off of this platform and where it&#39;s supposed to go some of the automations are more straightforward like LinkedIn and Facebook where we&#39;re simply publishing a text post but for Instagram we need to Loop and create images for each page in the carousel if I click here we can see that example here that&#39;s what this automation is doing before it finally publishes it and then for the vertical videos and these reels this automation here is taking the content from this here and then it&#39;s generating audio in my voice it&#39;s uploading it to Google Drive and then it&#39;s using this platform here Json to video to take this Boll video that I have here that&#39;s stored on Google Drive where it adds the AI voice over mistakes to avoid with AI in your business so and then it adds the captions and then finally after it builds that video it automatically pushes it to Instagram and X is pretty straightforward it just posts one of the tweets that was generated here after you mark it approved and again you can review the content of any of these posts before you actually approve it for publishing where this automation will then trigger and pull it through and send it to this automation which creates the assets and does the publishing and finally the last piece of this automation it simply goes back into a table and marks these post that were approved for publishing to published where then you can then track all of those in this view here all right so let&#39;s dig in I&#39;m going to build out these automations from scratch but if you would like access to the entire blueprints to these automations so you can simply import these automations just by clicking a file and uploading it and getting the entire thing built out for you to save a ton of time as well as access to my speak to social air table base that has everything already built out including these automations make sure to check out my new community the no code architects I&#39;m building out a huge template library of automations just like this and you&#39;ll be able to get access to these automations and the air table base I&#39;ve got a link that&#39;ll take you right to the community in the description below so let&#39;s start from the very beginning I&#39;m now in slack if you don&#39;t have a slack account go ahead and create one and then you can create a channel I created one called speak to Social and then I simply used this little icon down here to record some audio notes directly into that channel now keep in mind there&#39;s a super easy way to record these audio notes you don&#39;t have to be prepared you can go off the the top of your head you can even make mistakes take pauses chat GPT will clean it all up in fact you can just grab your phone and go on a walk and record directly into the slack mobile app and these are the basic prompts that I give myself as I&#39;m recording to produce good content through the automations I just have a statement where I say if you want this thing then I talk about the main problem that people have attaining this thing and then I talk a little bit about why I&#39;m the authority to speak on this topic and the number one mistake people make and then I talk about that there&#39;s a better way to do this thing that they want and then finally I give them the steps to achieve this thing so that&#39;s a basic format that you can use it makes it super easy super low pressure so you get that audio recording into slack so that we can then continue on with the automations so the first automation we need to add is for slack I&#39;ll go ahead and click that and then we&#39;re going to watch for private Channel messages if you don&#39;t already have a connection you&#39;ll need to add that and then for input method you can leave it as a list and we&#39;re going to select a private Channel notice you&#39;ll see mine here speak to social go ahead and grab that you can leave the limit on two you can go ahead and click okay now you will need to record a test audio so go ahead and do that feel free to use this basic script and prompting method that I gave you earlier if you have something real it&#39;s going to make the output of our automations better and then we&#39;re going to go ahead and run this automation manually go ahead and right click and say choose where to start go ahead and click choose manually we&#39;ll be doing this quite a bit it&#39;s going to load up the audio recordings that you have already recorded go ahead and pick that top one click okay and then down here you can say run once that&#39;s going to run the Automation and pull in that first audio recording so we can continue to build out the automation the next thing we need to do is is actually download that audio file so go ahead and add another slack module then you can scroll down to download a file and then for this we&#39;re going to use the file from Step number one go ahead and click into this go to files and then you can click URL private download and click okay now here you need to add a filter so that we only continue if that file exists add a condition you&#39;re going to look for the file and then you just need to make sure that it exists pick exists and then you can go ahead and click okay now the next thing we need to do is create the transcription from the downloaded file so go ahead and go to chat GPT open Ai and then you&#39;re going to scroll down to create a transcription make sure not to pick create a translation and then it should automatically detect that we have a file from slack you&#39;ll want to use the whisper model you can leave the prompt blank and response format as Json go ahead and click okay and then in this next module we&#39;re going to use chat GPT to create the main points of the audio so we&#39;re going to look at the audio and just extract all of the main points so so I&#39;m going to go here to create a completion I&#39;m going to use the new 40 model right here for Max tokens you can put in zero I&#39;m going to go ahead and add a system message here and then I&#39;m going to just cut and paste this in from my other automation you are a detail oriented person who can extract all the details from written content and then I&#39;m going to go ahead and add another message this will be a user and then I&#39;m going to cut and paste this in for my other automation template and we&#39;re going to extract all the details as bullet points from the text below and we&#39;re going to use the result from the transcription so we see here I&#39;m going to go ahead and add the text and then I will go ahead and click okay and now from here I&#39;m going to go ahead and save the automation make sure you&#39;re saving periodically as you go because if you leave this page it will be lost and then I&#39;m just going to run everything to make sure everything is okay I&#39;m going to go ahead and go to choose where to start choose manually going to pick that top recording here and then I&#39;m going to go ahead and just click run it was able to get the file it downloaded it now it&#39;s creating the transcription and now it&#39;s creating the bullet points so if we come in here now and we take a look at the result now we have all of of the main details from the audio transcription and I just like to use this in my future prompts to make sure that chat GPT always uses all the details as it creates content and now the next thing we need to do is actually create the row in air table to store this transcription so I&#39;m going to jump into air table I&#39;m going to create a new base from scratch you have to select a workspace I will select production and this is what a new base looks like I&#39;m going to go ahead and close this I&#39;m going to rename the title here to speak to social demo then I&#39;m going to go ahead and build out this entire table from scratch I&#39;m going to rename this view to spoken word then I&#39;m going to rename the table to speak I&#39;m going to change this main column here which is the primary field to an auto incrementing field I&#39;m going to call it the speak ID I&#39;m going to rename the notes to transcription I&#39;ll leave it as a long text I will click save I&#39;m going to go ahead and delete this default field that came in when we created the table I&#39;ll go ahead and delete this one as as well and then I&#39;m going to create a new field for created time just to have that as a reference if you leave the field name blank then it will simply just give you one for you so that&#39;s all we need now I&#39;m going to jump back to the make.com automation now the next thing we need to do is to create a new row in our air table database create a record next I need to create a connection for the new base I added in air table I&#39;m going to go to air table oo I&#39;m going to give the connection name speak to social demo click save going to expand this window so I can see it better I&#39;m going to add a new base going to look for that base speak to social here it is I&#39;m going to add that base I&#39;m going to Grant access it&#39;s going to add that connection then I can select the base speak to social demo then I&#39;m going to select the table speak and I&#39;m simply going to drop in the transcription from the previous step make sure not to grab this one which was the detailed bullet points I&#39;m going to grab the transcription then we can go ahead and click okay then I&#39;m going to zoom back out just a little bit and I&#39;m going to rerun this just to make sure everything&#39;s working choose where to start choose manually going to grab that top STP audio recording click okay run the automation what we should see is a new row coming into our new air table base while that&#39;s running I&#39;m going to go ahead and delete these default ones that were created come back to the automation looks like it ran to air table so now we have a new row which is our transcription so so far so good I&#39;m going to jump back over to make and then continue to build everything out next what I&#39;m going to do is I&#39;m going to build a router this allows us to create multiple paths for different automations I&#39;m going to add another chat GPT complete here in this case we&#39;re going to write the LinkedIn post again I&#39;m going to pick the chat GPT 40 model I&#39;m going to go ahead and add a new message I&#39;m going to go ahead and pick the system roll I&#39;m going to go ahead and copy and paste the prompt from my template automation I&#39;ll expand this a bit it just simply tells the automation that you&#39;re an expert content and Automation and AI expert you like to create audio brainstorming notes for ideas and convert them into written content and then I give it some guidelines what the post should look like and how it should be formatted and then some additional guidelines that I want to make sure the post has looks like I got a little cut off there so I&#39;m going to come back to my template make sure I got everything I don&#39;t want it to include hashtags or emojis so I just detailed everything that I wanted for the Post then I&#39;m going to go ahead and add a new message the roll will be user and then I&#39;m going to cut and paste my prompt from my template into this message here and it simply says take the transcript Below in quotes and write a concise LinkedIn post and then I say use the detailed points below as reference to make make sure you included all the important details and I do need to replace this because it was from a different automation so I&#39;m going to place in the text from the transcription and then I&#39;m going to replace this with the actual details from this previous step here before I can click okay I got to add in the max tokens put in zero and then I&#39;ll go ahead and click okay again and then next up what we need to do is we need to create the actual social Post in our air table database so I&#39;m going to jump back to air table and build out the second half of our air table database which is the social side so I&#39;m going to go ahead and create a new table start from scratch we&#39;ll call this social go ahead and click save now for the primary column I&#39;m going to make this an auto incrementing field as well I&#39;m going to call this my social ID I&#39;ll click save I&#39;m going to rename this to content leave it as a long text go ahead and click save I&#39;m going to go ahead and delete these other columns and then rebuild what I need from scratch next I&#39;m going to add a platforms column I&#39;m going to go to single select I&#39;m going to type platforms then down here I&#39;m going to add a few options I&#39;m going to add Instagram real LinkedIn X Twitter Facebook and Instagram so that we can differentiate between an Instagram post and a real then I&#39;ll go ahead and click create field and now we have all of those options here next I&#39;m going to create a column for type so we can keep track of that I&#39;m going to add another select field we&#39;ll call it type here we&#39;re going to add three options text image and video I&#39;ll go ahead and click create field now we&#39;re going to create a nether column for the status another single select we&#39;ll say review approved and published we&#39;ll go ahead and click create field then I&#39;m also going to create a created time roll down here to created time you can leave this blank it make that for you then I&#39;m also going to create a column for modified time scroll down last modified time just so we have that and then finally what we need is a way to link this table back to the speak table because every time we add a transcription we are going to link that transcription with all of the social posts that we create for that transcription so I&#39;m simply going to come here you can do it really anywhere you can add it here if you&#39;d like but just so it&#39;s not at the end of the screen I&#39;m going to add it here I&#39;m going to go ahead and insert to the right I&#39;m going to link to another record I&#39;m going to link to speak we don&#39;t need to allow to linking to multiple records and I&#39;m simply going to call this field speak I&#39;ll create that field you can go ahead and Skip and now we have this column here and now if I jump back to the speak table we&#39;re going to see that we also have a link to the social table and both of these you can hide this if you&#39;d like because you don&#39;t actually need to see it come back to social we&#39;re going to hide this one as well hide field and now we can come back to make and our Automation and we can finally create that row let&#39;s add the next automation here we&#39;re going to add the air table row we&#39;re going to create a record in this case we&#39;re going to pick the base we&#39;re going to pick the same base again speak to social demo this time for the table we are going to pick the social table for Content we are going to use the result from this previous step you can just grab that result for platforms you can uncheck this and then we can hit LinkedIn now in this case I realized we need to change this field type in air table because we can select multiple platforms so I&#39;m going to come back here going to adjust this to edit and turn this into a multiple select I&#39;ll click save come back to the Automation and I&#39;m going to go ahead and refresh but now if I turn off this map it will allow me to add multiple values so we have LinkedIn here I&#39;m going to uncheck this just so I can select it from the dropdown then I&#39;m going to add another item here I&#39;ll unselect this again so I can use the drop down and then I&#39;m going to pick Facebook for the type I&#39;m going to unselect this map so that I can select from the drop down I&#39;m going to pick text for the status again I&#39;m going to uncheck this map so that I can select from the dropdown and I&#39;m going to pick review and then here we need to attach this specific record that we&#39;re adding to this table social to this previous transcription that we already created so here we are going to add an item and for the record ID we are going to use the record ID that we created in Step six so go ahead and click into that we&#39;ll click this ID here and this should be everything that we need we can go ahead and click okay I&#39;m going to go ahead and click save we&#39;ve done quite a bit of work at this point going to zoom back out a little bit go back to that first module choose where to start choose manually click this first object which is the most latest recording and then I&#39;m going to go ahead and click and run this automation create the transcription then we&#39;re going to create the details it created the transcription row now it&#39;s creating the actual post and now it created the social Post in our error table database so now we have a new row in in our speak for that transcription and if we jump over to social we are now going to see our new social post and if we click in here we can see the content that was written from chat GPT I&#39;m going to go ahead and remove these blank rows that were created in the beginning I&#39;m going to go ahead and just adjust the sort so that it&#39;s always putting the most recent rows on top I&#39;m going to do that on the speak side as well go to the sort go to the speak ID all right so now we&#39;re rocking and rolling let&#39;s just keep going and get through this automation so now we&#39;ve got a couple more to build now we&#39;re going to go ahead and build out the Tweet so I&#39;m going to create another chat GPT completion here create a completion going to go ahead and use the same model here we&#39;re going to use chat GPT 40 going to add a new message for roll we&#39;re going to use system going to copy in the prompt from my example basically we&#39;re just saying you&#39;re an expert social media content writer and some additional guidelines that are very similar to the ones before We&#39;ll add another message for the role we&#39;re going to use user I&#39;m going to copy this from my template automation we&#39;re going to read in the transcription we&#39;re going to create one concise tweet for each of the important points that we created here I&#39;m going to have to fix this here and make sure I&#39;m actually grabbing the transcription which was in Step number three so I&#39;m going to use step number three here click on the text then I need to replace this from the automation because I cut and paste it from my other automation which is not here so we&#39;re going to use step four right here for Max tokens we&#39;re going to put zero and then we can go ahead and click okay and continue now we just need to write this back to air table like we did before I&#39;m just going to go ahead and cl clone this and just change what I need might be a little bit easier I&#39;m going to have to change everything here I have to replace anything that was used in this step I&#39;m going to have to use this step instead so I&#39;m going to grab this result instead of the one that was there that&#39;s why it looked the way it did with no color in this case I&#39;m going to delete these two platforms I&#39;m going to add a different platform I&#39;m going to uncheck this this is an X and Twitter tweet the type is text we&#39;re going to leave the status in review we can use the same transcription row that we created in air table so that should be good to go I&#39;m going to go ahead and click okay go ahead and click save I&#39;m not going to test now I&#39;m going to go ahead and continue to build all this out and then we&#39;ll do one final test and correct any issues that we had at that point so I&#39;m going to create another route there go ahead and align it going to make another chat GPT completion open AI create a completion going to use the model 40 as always going to add a new message in this case I&#39;m going to go ahead and just use a user message and right now what we are doing is we&#39;re creating the slide deck messages for the Instagram carousel so I&#39;m going to put in a prompt here say read the transcript below and summarize it into five main points that are 15 words or less so then when we create those slides we&#39;ll have a succinct sentence on each one then I need to add the transcript so I&#39;m going to come down here and add that for Max tokens I&#39;m going to go ahead and put zero and then I can go ahead and click okay now we need to create the a table record for that post I&#39;m going to go ahead and clone it add it to this route here then let&#39;s change all the information relevant to this again we&#39;re going to have to change the content so I&#39;m going to take that out and add the content from here this time it&#39;s going to go to Instagram so I&#39;m going to go ahead and remove that add a different platform remove the map and then select it here Instagram make sure not to pick real that&#39;s for the video for type we&#39;re going to change this to image and the status can stay in review and we can go ahead and click okay so one more automation to add for this first part of this system now I&#39;m going to add one more route chat GPT completion again we&#39;re going to use the 4 model we&#39;re going to add the message for the roll I&#39;m going to go ahead and use user now in this a here I&#39;m building out the voiceover script for the video that we&#39;re going to create for the vertical video on Instagram reals so I&#39;m going to copy over my prompt from the other Automation and I&#39;m going to say read the transcript below and summarize it into a script that if read aloud would be 18 seconds or less and I just said that because the b roll video that I&#39;m going to put this audio on top of is only 28 seconds so I just wanted to make sure it was less than that and then I need to add in the transcript so we have that then I can put in the max tokens to zero go ahead and click okay then we need to add in the air table row I&#39;m going to straighten this out just a little bit clone this air table row connect it up here and we need to fix everything again we need to change the content to the content produced in this GPT here I&#39;m going to change the value of the platform to Instagram real the type is going to be video and the status will come in as review so now I can go ahead and click okay and save it and the reason why I&#39;m not building the graphics or the video in this stage is so that when we add the content to our social table we&#39;ll have a chance to update the text and the content before we click approve and that ultimately runs the automation to push it to social media so I&#39;m going to go ahead and save this back out a little bit let&#39;s go ahead and run this from the beginning I&#39;m going to choose where to start choose manually I&#39;ll pick the most recent voice note click okay and then let&#39;s go ahead and run this and see if we have any errors it&#39;s creating the transcription now I created the row and air table of that transcription we have that right here actually that was right here now it&#39;s actually creating the individual posts and now it&#39;s gone through each of the different automations and we can see that we have those five new posts just created right now so now we can format the table just a little bit and then you can always look inside of the various pieces of content that is being created and then you can tweak it you can come back and you can tweak your prompts to generate the type of content that you want we can see what platforms that everything is going to be distributed to once we set up the automations and then we create the new make automations to create the content to create the videos the images and then to actually post everything once we adjust the status to review so on that note just to get ready for the next step I&#39;m going to go ahead and create a couple more views here I&#39;m going to rename this one to approve then I&#39;m going to duplicate this to publish and then finally one more to published and then I&#39;m going to adjust the filters of each of these I&#39;m going to go to approve and add a filter where we only see the status of review and then here we want to make sure that we only see the status for approved and then here we want to see only the status for published that way if we come here and we approve something we&#39;ll see it here and then if something&#39;s published we&#39;ll actually see it right here and by the way if you&#39;re finding this video valuable make sure to like And subscribe to the channel it tells me what type of content you want more of all right so now let&#39;s build out the rest of the automation all right first let&#39;s go ahead and save this automation make sure you do that I&#39;m going to go ahead and rename this to Slack to air table I&#39;ll save that then we&#39;re going to go ahead and move on to the next automation which is going to do the auto publishing from Air table based on the platform and the type of content it is and once it&#39;s approved so I&#39;m going to go ahead and create a new scenario and remember if you want to get access to These Blueprints so you can simply come in and import this and click a couple buttons and have these automations completely built out and ready to go make sure to join my new community link is in the description below now if we&#39;re starting from scratch then we&#39;re going to start with a web hook so we&#39;re going to click that and we&#39;re going to go to custom web Hook from here you&#39;re going to go ahead and click add you can go ahead and click save it&#39;s going to give us a web hook we&#39;ll come back and grab that in a second make sure to click okay so that it saves that step once you have this web hook we can jump back over to air table and start building out the automation here we need to build out the auto publish automation that will run at some scheduled time and what&#39;s nice about this is that instead of having to pick a scheduled time for all of the content we can simply just create an automation that will pick one of those ready posts and we&#39;ll post it at some specific interval that you choose so I&#39;m going to go ahead and pick an interval of one post every day and I&#39;ll just pick 8: a.m. you can really pick any interval that you want then we&#39;re going to go to the next step and find rows in this case we&#39;re going to find rows in the social table and we&#39;re going to find records that are based off of a condition and that condition is simply that the status is approved so we&#39;re going to adjust that and pick a status approved and then in order to test this automation you can go ahead and click Test action now if you get Zero Records found that simply means that back in the data here and in this social post area we don&#39;t have any approved content to publish so I&#39;m going to come back to published I&#39;m going to move everything that might have been here to review so if I come up to review we should have five different posts I&#39;m going to go ahead and start with the LinkedIn and Facebook posts and while I&#39;m here I&#39;m also noticing that I made one mistake here with the Twitter Tweets in that it didn&#39;t separate them into individual posts so I&#39;m going to jump back back over to our automation here and I need to add a module here that is going to split up the text from chat GPT and convert it into multiple tweets instead of just one big piece of text so I&#39;m going to add a text parser here we&#39;re going to pick match pattern I&#39;m going to copy in this pattern right here we&#39;re going to move this to Global match we can select case insensitive we can leave the rest of these as they are and then we&#39;ll just want to take the result from the previous step and click okay and now let&#39;s go ahead and click click save and then let&#39;s back out just a second here and again let&#39;s run this automation one more time choose where to start choose manually pick that first option there and click the automation this time when it runs it&#39;s going to create multiple Twitter posts in one chat GPT completion and then this is going to break it up and as you can see it added three rows to air table instead of just one so if we come back to air table and we see here the old one that we had we can see the tweets were all added to one piece of content whereas now we have multiple tweets and it broke each of those up into different pieces although I&#39;m seeing one additional bug here that we need to fix in air table we need to use the results from the text parser not this result here so I&#39;m just going to jump in here and for the content going to erase that and add in this dollar sign click save then I&#39;m going to go ahead and choose where we start choose manually click okay and then run once going to run that and then this time when it breaks up those tweets into individual tweets it will save the result from here and put that into air table instead of what I did before which is I even though I broke up the text I still was saving this one into air table so now we&#39;re creating those tweets it breaks them apart and now it&#39;s actually writing those individual tweets now we have four tweets and they&#39;re all different so now that we have the correct results I&#39;m going to go ahead and just delete some of these old rows here just so they&#39;re not in our way and now we have a fresh set of results to continue building our automation here so now I&#39;m going to jump back to a table go back to the Automation and let&#39;s go ahead and start with the LinkedIn and Facebook post I&#39;m going to go ahead and move this to to approved now it&#39;s going to show up in this view here now if I come back to the automation again remember we have a automation that will run every day at 8: a.m. and then it&#39;s going to find a approved post so now we can go ahead and test this action and now we have this record so now I&#39;m going to go to the next step here and I&#39;m going to run this script what this script is going to do is that it&#39;s simply going to take the information from our row that we just found the approved row and it&#39;s going to call this web hook on make.com side so that we can continue on with the automation so to make this work I&#39;m going to edit the code I&#39;m going to copy that code and paste it into this script area right down here and then I&#39;m going to come over here and we&#39;re going to add a variable if you want to pause the video and copy this step by step or you can jump into my new community and get the template for this entire database I&#39;m going to type social ID then for the value here I&#39;m going to hit this plus button I&#39;m going to go to this step here find records I&#39;m going to scroll down to air table record ID and now here I want to test that this automation is working so I need to come back to make.com I&#39;m going to go back inside of this automation here and I&#39;m going to grab this web hook I&#39;m going to copy address to clipboard I&#39;m going to jump back to air table and I&#39;m going to add that URL right here where it says web hook URL going to drop it right here in the quotes I&#39;m going to jump back to make I&#39;m going to click okay and I&#39;m going to go ahead and run once so it&#39;s waiting for a request jump back to air table I&#39;m going to go ahead and click test the test ran successfully if I jump back to make we&#39;re going to see that we have a new request that came in and we&#39;re going to see that it passed that record ID into make and now we can go ahead and grab that record from Air table and continue on and if we jump back to air table we can see what&#39;s going on here is that we passed the social ID which is that record ID from this step here where we found the record that was approved so it&#39;s basically getting the record ID for this row that&#39;s approved and it&#39;s this script here that calls the remote web hook here and passes This Record ID here that&#39;s why we added this variable here so that it can pass it into the script and ultimately pass it to the web hook which allows us to access it here if you don&#39;t understand all of that it&#39;s not necessary but if you just copy this exactly how I did it it should work just fine and now we can continue on with our automation the next step we need to do here is to load up the record that we are working with so I&#39;m going to go ahead and click air table I&#39;m going to get a record you need to make sure to pick the connection that we are using previously I&#39;m going to use my speak to social demo for the base you&#39;re going to pick speak to social for the table you&#39;re going to pick social and for the record ID you&#39;re going to use use the record from Step number one here record ID then you can go ahead and click okay and now what we&#39;re going to do is we&#39;re going to create a route so that we can Branch off and post to the various different platforms depending on the platform that was listed in this multi- select variable here so let&#39;s go ahead and work on the LinkedIn and Facebook first here I&#39;m going to add a new router here I&#39;m going to use the LinkedIn module you&#39;re going to want to create a user text post if you don&#39;t already have a connection you&#39;ll need to add that here and then for the content you&#39;re we going to use the content from Step number three so you can add this right here for media type you can leave that blank visibility public pretty much everything here you can leave as default you can go ahead and click okay we do need to add a filter here so that only the posts that are for LinkedIn will go to LinkedIn so go ahead and click here then right here you want to add platforms from Step number three right here you&#39;re going to want to scroll all the way down to the section where it&#39;s talking about array operators because this is an array so we need to look inside of that array and make sure it contains LinkedIn then we can go ahead and click okay and now we&#39;re going to go ahead and add our Facebook post so you can type Facebook in this case I&#39;m going to post to my Facebook page I&#39;m going to create a post if you don&#39;t already have a connection you&#39;ll need to add your own connection here then you&#39;ll be able to select what page it is I&#39;m going to paste to the content engine for the message you&#39;re going to want to use the content from Step number three go ahead and pick content and then you can go ahead and click okay and then you&#39;ll need to add the filter for the condition you&#39;re going to add the platform and then here again as you did before you&#39;re going to scroll down to the array operators contains Facebook and again if we go back to a table you&#39;re going to see that that&#39;s just matching here LinkedIn and Facebook and that&#39;s exactly what we added here that way when this automation runs and it&#39;s for a specific platform it only goes to those platforms you can go ahead and click save now let&#39;s just incrementally go through each of these so this one&#39;s ready to go so if we come back to our Automation and we scroll down we should be able to test this action I&#39;m going to come back to make I&#39;m going to go ahead and run once then I&#39;m going to come back to air table I&#39;m going to test the action come back to make so now it posted to LinkedIn and it posted to Facebook so if I go to LinkedIn and then I go to my feed we can see that that post is right here here is a test I did earlier that I showed you and then if I jump over to Facebook we can see that I just posted to my content engine page the same post that went to LinkedIn so now believe it or not we&#39;re getting near the end here so let&#39;s just keep moving along now we have to build out the the carousel images for Instagram so now I&#39;m going to go ahead and add a new route I&#39;m going to go ahead and set up this filter up front for the condition again I&#39;m going to pick platforms remember I have to go to the bottom here array operators contains Instagram go ahead and click okay then I need to add an iterator so here&#39;s the iterator I need to iterate through each of the different slides that we created in the content here so if we come back to our Instagram post I&#39;m going to go ahead and move this to publish so it&#39;s no longer here if I come to the Instagram post here we are going to see that we have three slides that we created in the content so we need to Loop through each of these and separate them to create five different images I&#39;m going to come back to the automation so if we come here to the array and then we go to Strings we can select split so you want to grab that split and then here what you want to do is you want to add the content from this stage here so you&#39;ll come back to this star and then we&#39;re going to add in the content right there and then you&#39;re going to come into this little spot here you&#39;re going to come back to the a and you&#39;re going to add a new line and then what that&#39;s going to do is that it&#39;s going to take this content and every time there is a new line here it&#39;s going to break that up so that we can create the social media graphic so I&#39;m going to come back to make I&#39;m going to go ahead and click okay now I have to add a new module for Placid I&#39;m going to go ahead and click Placid in this case we&#39;re going to create an image then if you don&#39;t already have a connection you&#39;ll need to add a connection and the way plastid works is that you create various different types of projects notice here I have a project here called social graphics and inside that I&#39;ve got a few different templates I&#39;m going to be using this one here called the square Carousel and the way their connections work is they end up connecting to a specific project so you can see here in my connections I have three different connections and it&#39;s because I enabled three different projects here to be exposed to the API so you want to make sure that you come into the project that you create that has the template that you create and you&#39;re going to want to create an API token that allows you to connect up to make.com so now I&#39;m going to go ahead and select the temp template I&#39;m going to pick the square Carousel and then for the text I&#39;m going to go ahead and select the value from the iterator I&#39;m going to leave the text color blank I&#39;m going to go ahead and click okay then I can go ahead and add the next step which is to close out the iteration I&#39;m closing the loop here and so for the source module I&#39;m going to go ahead and pick the first stage of the iterator and I&#39;m going to click okay so in order to properly configure this iterator here I need to add this step so that we can configure it here so I&#39;m going to go ahead and add in the Instagram post right now I&#39;m going to go ahead and click Instagram for business I&#39;m going to create a carousel post if you don&#39;t already have a connection you&#39;re going to need to add one I&#39;ve already have my Facebook connection it actually connects through a Facebook page through to your Instagram account there&#39;s instructions on how to do that here and here now in order to save this I do need to put in some dummy values here so I&#39;m going to go ahead and add an image and then for the photo URL I&#39;m going to use HTTP test.com image.jpg I&#39;m going to cut in paste this we&#39;re going to come back and replace that but we just need this for a second then I&#39;m going to go ahead here and add another item an image I&#39;m going to put that same test here so that I can save it and now I&#39;m going to go ahead and save this automation I&#39;m going to come back up to air table in this case I&#39;m going to move our Instagram post from review to approved so I&#39;m going to come back to the Automation and find record so you need to click find records and we&#39;re going to test this action so that it finds the new Instagram post if you don&#39;t click test it&#39;s going to re use the LinkedIn and Facebook post from before then I&#39;m going to come back to make.com I&#39;m going to go ahead and click run once if you ever get this notice it&#39;s just telling you that there&#39;s already something in the queue there&#39;s something waiting here in this case I&#39;m going to wait for new data so that I don&#39;t get old data that may not be what I want wait for new data I&#39;m going to come back to a table I&#39;m going to click this run a script I&#39;m going to test that action going to jump back to make we see that it&#39;s now going down the path for Instagram it&#39;s creating the images it&#39;s going to create all five of those images once it creates those it may try to post that to Instagram but it&#39;s going to error out because of the dummy data we gave it you&#39;ll see that it AED out which is fine but really what we wanted is we wanted the test data here so that we can properly configure these last two steps so now I&#39;m going to jump into the iterator here and now for Target structure type I&#39;ll now be able to add the Instagram for business files array and then we can configure what do we want to send to the media type and in this case we&#39;re going to select image and then for that photo URL we are going to use the image from plid so you can use the image URL and then we can go ahead and click okay and now we can come back to this module and properly configure it we can remove these two items then we can move this to map and for this field here we can simply use the array from that iterator and it&#39;s going to set up all the data properly so that it&#39;ll properly post to Instagram and map in the proper Fields what type of media it is and the image URL from Placid we can go ahead and click okay we can go ahead and click save now I can go ahead and click run once again again again I&#39;m always just going to wait for new data jump back to air table I&#39;m going to go ahead and run that test again jump back to make.com now it&#39;s creating the images I&#39;ll go ahead and load up Instagram just so it&#39;s ready going to go to my profile we already posted a carousel previously today but we should now see another one once this is done creating that fifth image and now it&#39;s posting it to Instagram it should just take a second looks like that was successful so if I jump back to Instagram and refresh the page we now see a new Carousel was automatically posted and it&#39;s got those five pages that was created from that original audio post that we made way back in slack all right so we&#39;re in good shape now now we just got a couple little automations to add I&#39;m going to go ahead and click save now I&#39;m going to jump back to air table I&#39;m going to go ahead and move the Instagram to published and now let&#39;s go ahead and move forward with the Instagram reel these tweets are quite easy and I&#39;m going to move this to approved that way we can go into the automation I&#39;m going to move back to find records and I&#39;m going to test the automation so that it pulls in the Instagram reel for testing so now we have that ready for when we want to run the script now I&#39;m going to jump back to make.com I&#39;m going to add another route I&#39;m going to go ahead and start with 11 labs this is going to allow us to create a speech synthesis from AI in this case I have already pre-loaded 11 Labs with my voice so that when I pass it text it will create a audio track with my given voice you can check out how to do that using 11 Labs I&#39;m going to go ahead and select the 11 Labs multilingual version 2 then for the text I&#39;m going to pass it the content and then I&#39;m going to click okay and then before I forget I&#39;m going to add the filter here the condition is on this platform and then I&#39;m going to change this to the array operators contains Instagram re which again is what we have right here Instagram real I&#39;m going to go ahead and click okay I&#39;m going to go ahead and straighten this out and we can continue on with the automation just going to double check that I have everything set up right in 11 la I think on this model here I&#39;m actually going to pick 11 Labs multilingual version 2 this one here not the STS I think that will cause an error I&#39;m going to go ahead and select that here click okay I&#39;m going to go ahead and test where we are right now just to make sure that this works here I&#39;m going to save then I&#39;m going to go down here to run once I&#39;m going to jump back to air table and now that we have our Instagram real in the approved section I&#39;m going to jump to the automation if you haven&#39;t already you want to make sure you find that record using the test here make sure that&#39;s the one that comes up in Step number two then you can actually run this script here and test it jump back to make.com it&#39;s going to run that synthesis you want to make sure that it came back with the actual data now what we need to do is we need to save that audio in Google Drive so I&#39;m going to add a Google Drive connection here I&#39;m going to upload a file if you don&#39;t already have a connection you want to add that I&#39;m going to go ahead and just use a folder that I&#39;ve been using for testing you can create any folder on your Google Drive I have one here from speak to social you grab this ID up here in the URL make sure to grab the entire ID copy that go back to your automation drop that in the folder it should link up the file from the previous step you can click okay then we need to create a public share link for that file so go ahead and add the next step going to go to Google Drive you want to get a share link you can use your drive select your file for file ID we&#39;re going to use the step before here in Step 13 file ID the role is reader for type we&#39;re going to say anyone with the link we should be good to go there you can go ahead and click okay then in this next step we are going to actually call Json to video you can create an account here to get an API key then on this step here we&#39;re going to create an HTTP module we&#39;re going to make a request for the URL you can use this here you&#39;re going to use the post method for the headers you&#39;re going to add in your API key and then for body type you are going to pick raw content type you are going to pick Json and then for the request content you are going to drop in this entire piece of code just like this just for easy copying pasting I will put this in the description below but if you want access to this then make sure to jump into my new community that&#39;s Linked In the description I&#39;ll give you the make.com files the air table database and all of these different pieces that we&#39;re putting into these automations here we do need to replace a couple values in order to create this vertical video I do have this vertical b-roll footage of me sitting at my desk it&#39;s just simply me moving around and doing a couple things you can use whatever you want but you do need to grab that ID from that file so if you open this up and you go to share you also want to make sure that you make this publicly available so make sure you change that to anyone with a link and then if you copy that link and then put that into your browser you should be able to copy that ID Straight From Here make sure you copy the ID everything after the slash and up until the slash don&#39;t include any slashes so you want to take that ID that you copied you want to replace that ID here right after the equal sign and up until that little Ampersand just remove everything here and paste in your ID and then down a little bit lower where you see the audio and the source you want to copy the link from this previous step the share link from this step here go ahead and copy that in although if you haven&#39;t run this automation yet that value might not be there so you can feel free to use the link from Step number 13 which is going to be the web content link you can actually type that in here uh it does look like it&#39;s showing up here in Step number 14 so you can go ahead and copy that make sure you click that link so it goes right in between those two quotes put your cursor there click that then you should be good to go you can go ahead and then move this to pars response is yes yes go ahead and click okay now let&#39;s go ahead and just click save and make sure everything is working I&#39;m going to zoom back out a bit and then click run once then I&#39;m going to jump back to air table and Trigger this step one more time should come into make and then come down to 11 Labs it&#39;s creating the voice it&#39;s uploading the file it&#39;s creating the share link and now it&#39;s calling Json to video if you open this up you should see a status code of 200 that means that you cut and paste the code correctly and you properly replaced the web share links and the Google Drive links for the b-roll video and the audio that you saved from 11 Labs now we can go ahead and continue on I&#39;m going to go ahead and add a sleep to this section here once you call this call here Json de video is going to be building that video in the background so we need to take a quick pause and let that finish so I&#39;m going to type sleep I&#39;m going to go to the tools here I&#39;m just going to go ahead and put 90 seconds and then click okay we&#39;re almost done then we need to make one more HTTP call to get the video so that we can actually call Instagram so I&#39;m going to add one more step step here HTTP I&#39;m going to make a request for the URL I&#39;m going to cut and paste this URL here we can leave this as a git for the headers we need to add our API key again you would get that from creating an account at Json to video in this case we need to add a query string for the name we&#39;re going to add project and for the value we&#39;re going to use something that was returned in this previous step from our test you should see the output just like this because we told make.com to parse the response with a yes so here you&#39;re going to use the project and again here you&#39;re going to want to use parse response yes and then you can go ahead and click okay and now we can run this manually just to see if the video was properly created by coming over to this response coming back to the data here and grabbing this project ID just select everything there copy it and then come to this and do a run this module only it&#39;s going to ask you for that project ID go ahead and paste that in there and click okay should run that module go ahead and open this up should see a status code of 200 I can go into the data here I can go into the movie I can grab this URL straight from this section here copy it I can go to my browser put that in there here the video pops up we can see the captions and it&#39;s using the audio from 11 Labs which was my synthesized voice mistakes to avoid in using AI in business first don&#39;t ignore AI staying out of the loop sets you back all right let&#39;s keep going we&#39;re almost done here and then in this last step here we simply need to call Instagram to make that post Instagram for business we&#39;re going to create a real post you want to connect up your connection and for the video URL we&#39;re going to use the video in the previous step go ahead and go into step 17 movie and there&#39;s the URL you can leave the caption and these other things blank you could of course create automations to fill those in if you would like go ahead and click okay now let&#39;s go ahead and make sure you save that let&#39;s do one final test let&#39;s go ahead and run this jump back to air table and run that trigger it&#39;s creating that audio calling Json to video now it&#39;s going to pause for 90 seconds now that it&#39;s done sleeping it&#39;s made the request to get that file and now it&#39;s making the post to Instagram and might just take a few minutes for that upload to take place looks like that is done so if I jump back to Instagram refresh my page jump down to reals we&#39;re going to see that new video was just posted 20 seconds ago we got the b-roll we&#39;ve got the captions and we&#39;ve got my AI generated voice over on current AI models be ready to adapt to new advancements quickly Embrace changes and continually amazing all right so let&#39;s go ahead and save this make sure you do that and let&#39;s just finish this out really quick we w we have a very simple one to add at this point I&#39;m going to add two more routes one of them is just simply to Mark any of these given posts that we&#39;re creating as published so that that&#39;s done automatically so I&#39;m going to go ahead and add that right now you want to make sure it&#39;s this final automation because that&#39;s going to be the one that runs last just going to click into here go to a table going to update a record going to pick the base speak to social for table we&#39;re going to pick social for the record ID we&#39;re going to use the record ID from the web hook and then we&#39;re going to just jump down here to status going to remove the map and we will pick published select okay go ahead and save that that rearrange the Automation and now all we need to do here is post our automation for Twitter so I&#39;m going to go in here to the condition and add in platforms and then I&#39;m going to change this down here to array operators contains and then remember for Twitter we go to approve platform is x/ Twitter so I&#39;m going to come back to the automation x/ Twitter I&#39;ll go ahead and click okay then I&#39;m going to come back to air table I&#39;m going to go to publish I&#39;m going to move the Instagram real test to published then I&#39;m going to go back to approve and move one of these tweets to approved I&#39;m going to go to the automation I&#39;m going to reselect a new approved automation Test action we should see the Tweet pop up now I&#39;m going to jump back to make going to add the Twitter module right here we&#39;re going to create a post Now setting up Twitter is a little bit more complicated make sure to check out these help Pages it will show you how to create an app and connect up to Twitter it&#39;s a little confusing but it&#39;s not that hard if you&#39;d like another video on that let me know as long as you follow their instructions you should be good now we can come back in here to the text content we&#39;re just going to add content we can go ahead and click okay we can click save I&#39;m going to Auto align everything again as well I&#39;m going to go ahead and run this once jump back to aor table go to run a script Let&#39;s test this action it&#39;s going to come in it&#39;s going to send that to Twitter and notice it&#39;s also going to move that post out of the publish automatically now it&#39;s going to be in published so we don&#39;t have to do that on our own here&#39;s that now we just need to go to Twitter to see the new Twitter post that we just came came out with 19 seconds ago now what we need to do is come back to air table we&#39;re going to go to this automation we&#39;re going to turn it on we&#39;re going to adjust our schedule as needed going to come back to our original make.com automation that searches for new audio from slack we&#39;ll turn that on we&#39;ll come back to this automation that we just built we&#39;ll turn that on and now the next time we come in here and make a new audio recording that will be loaded up by this Automation and keep in mind that this automation will run every 15 minutes if you want it to run sooner you can adjust that just keep in mind that every time that this automation runs it does use one of your make operations so you want to be conscious of that but that will trigger the entire process it will create the transcription it will create all of the different posts after you review them and approve them this automation Once you turn it on will automatically pull them in at the given schedule and we&#39;ll call this automation which will send and create the various pieces of content that we need and publish them to the various platforms and again if you want to just get access to These make.com Blueprints so you can just downlo download them and upload them and just install that air table automation so that you can get this up and running in just a couple minutes make sure to join the no code Architects the link is in the description below click on that join you can get access to these right away this is a brand new community I&#39;m excited to see you there and either way I&#39;ll see you in the next video

Transcript for:Automated Content Creation and Publishing Using Slack, Make.com, and Airtable

Transcript for:
Automated Content Creation and Publishing Using Slack, Make.com, and Airtable