Transcript for:
Automating Social Media Content with AI

What is going on guys? It is Jono and today we're going to be talking about how you can make an unlimited amount of Instagram Reels or YouTube Shorts or TikTok videos using artificial intelligence and automation. Take a look at this. This is so freaking cool.

So in front of me, I have this Reel that I created here, right? Let's just listen to this really quickly. The best preparation for tomorrow is doing your best today. So essentially I'm cloning my voice. Right.

And then I'm generating automatically these reels. And instead of me just, you know, going ahead and posting this a thousand times, there's an element of human intervention in here, right? So we have this dashboard and essentially what's going on here is we are automatically generating these quotes here, right?

And you don't just have to generate quotes. You can generate whatever it is you want. But in this case, we're using AI and make.com to generate quotes and then we're adding them into. this Google sheet here, right?

And as long as you like the quote that has been generated, then you can click this generate button here and it's going to automatically generate a video just like this. And if you like the video and you're happy with it, then you can go ahead and click this post button here. And then it's going to essentially send that, uh, real to Instagram or short to YouTube or so on and so forth. Now, the cool thing about this guy's is too. that you can come in for free and download both of these workflows.

All you have to do is click this more button and import the blueprints right in here. And this blueprint is for free down below in the description, both for both of these. And before we begin, just make sure that if you're new to the channel, hit that beautiful, stunning, sexy subscribe button down below the one that you're looking at right now. And if you like content like this, because I will be releasing videos just like this one every single day.

So let's dive into it right now. All right, so let's dive into this. We're going to be using three major software platforms to build this out. The first is going to be make.com.

Essentially, make.com allows you to connect all of these different applications together, like 11 labs to generate the audio file. and ChatGPT to generate the title and the description, and then JSON to video to generate the actual video, right? So we're going to be using make.com to integrate everything together.

We're going to be using something called JSON to video to essentially generate this video asset here. So this thing is going to be generated using JSON to video. And then lastly, we're using 11 Labs to generate an AI clone of your voice to use as effectively a voice in these clips.

So... Let's get started. In make.com, we're going to create a new scenario. If you guys haven't gone ahead and done so, you can sign up for make.com. A link is down below in the description if you want to get started.

It does help me out. By the way, I do make a bit of commission if you guys end up using that link. In make.com, the first thing we want to do is select open AI.

And we're going to start by creating a completion, right? You know, if you guys are new to make.com, think about this like... essentially just using ChatGPT, right? That's essentially you're just using ChatGPT, but instead of using it in ChatGPT, well, you're using it in make.com.

So we're going to select a model here, and it's going to be 4.0 mini. This is because we don't need a lot of power to generate these quotes, but effectively it's just cheaper. And the first step here, just so you guys are aware, is we're going to create this three-part process where we generate ideas and then we push them into a spreadsheet just like this.

So we have a list. The cool thing about this really is that if you're like me, like I, a lot of the times I really struggle with coming up with creative ideas every single day, right? It's challenging.

And the cool thing about using AI is it kind of switched the switches your frames. So then instead of you having to overcome writer's block and always be creative, now you're in the process of just trying to identify what ideas resonate with you best and then creating content around that. So That's really, really cool.

So coming back into make.com here. We're going to add a message and this message is going to be a user message. Now, just to save a bit of time here, I've already actually created this message. So I'm going to paste what I've created in, and then I'm going to read it out to you guys.

So we're going to create 50 inspirational quotes. So we're creating 50 at a time and please, um, uh, output the data in JSON format. If you guys are unfamiliar with JSON format, this is what it. looks like down here.

This is the fundamental building blocks of essentially make.com, but the web at large, most of the time data is transferred using JavaScript. And if you want to think about it conceptually, what it looks like, this is JSON, right? This is just prettified JSON.

So you can see like a key, which is like the sheet name. And then the value is sheet one or the email is the key is email. And the value is John O'Katliff at gmail.com.

Same kind of deal here. This is just unprettified JSON. This is what it looks like. you know, behind the scenes, I guess, I guess that's the best way of describing it. But yeah, we're going to output it as JSON and make sure to not duplicate the quotes.

And that will push should be like this. And the reason we are putting a sample structure of JSON in here is because we want to standardize it, right? Because what happens is, let's say we go and reference in this case, you know, a particular quote to create a video on.

And in one instance, the key is called quote. And next it's called description. Well, if it's called description, then Obviously, we can't reference the quote because now it's titled description.

So it's going to throw an error. So we're just standardizing the process so that every single time we can expect the exact same results. Max tokens, I'm going to put at a thousand. This is essentially how much you spend with ChatGPT.

The more tokens you put in there, the more it's going to cost. And last kind of deal here is we're going to show advanced settings and we need to do one thing here, which is change the response format from text. to JSON, right?

So we're going to make sure that the output is JSON and we want to make sure that it's parsed so that when we're done creating these quotes, it looks something like this on the side here that we can easily reference rather than having something like this up top that we can't reference. And if you guys just make sure please to put in a line like this referencing the output should be JSON because if you don't, it's going to throw an error. So we can click OK.

I'm going to save this and we're going to run this scenario. and this should generate 50 quotes for us. All right, so I've gone ahead and ran this module.

Let's take a look at the results here. So we're going to go into results quotes, and we have all 50 quotes here. If we zoom into any of these, you can see the quote and you can also see the author here, which is super cool. Now, if you guys do receive an error here, and I actually just did receive this, which is that if you don't like get the JSON perfectly like this and you're wondering like oh it's it's not working likely the reason why is that the max tokens here have to be set high enough because if they're not what's going to happen is it's going to cut off the response and then your json will be like cut off from like here down and it'll be incomplete and then you can't proceed forward now just to kind of back up here with this structure here i'm just grabbing this from the results so if you guys want to recreate this you could come into the download section here download the output And then from the quotes section, you could literally just grab two of these, just copy that. And then we'll circle back to coming into ChatGPT here.

And if you wanted to just essentially recreate this, we can delete this, push in quotes here. And then all we'd want to do is just put placeholders here so that we know we're telling ChatGPT, hey, you know, when you generate this content, just make sure you know that these are placeholders. So don't like... actually put in Sam Levinson here and this is the quote like make sure that you put in the quote that you just generated not just putting in exactly the placeholder that I put here so you come in here and be like quote uh placeholder one and then you could you know um put the squiggly brackets or however you want to put this you can there's no right answer to how you put this but then we could also do author um placeholder oops author placeholder and one and so on and so forth. I'm going to cancel out of that just so that I don't spend the next 10 hours trying to figure out how to spell that properly.

And then we're going to go in and we're going to create an iterator here. Now, an iterator means that we are going to take all these results. You can take a look at all these quotes, right?

There's 50 quotes, and we're going to go through them one at a time. right? So we're going to start with quote number one, and then we're going to take the quote and author, and we're going to put that text here. So the quote is going to be here.

The author is going to be in column B, right? And we're going to go one at a time until we go through all 50 quotes and we place them into this Google spreadsheet. So I'm actually just going to delete all these just because we can restart here and let's, let's give it a shot.

So with the iterator, we're just going one at a time through this, because right now this is bundled together. as like one result right so if we were just to put quotes in here it would put all 50 quotes in one cell and obviously we don't want that we want to go through it one at a time and that's where the iterator comes through and we're going to put in quotes here it's important to put quotes and not results because results if you just put results in here it would just give you one response back which would be quotes because quotes is a list containing 50. quotes but you can't just put results in here so you just need to make sure whenever you're dealing with an array which is a fancy way of saying list in javascript you actually put the list and the list is the quotes that contain the 50 quotes in here so we'll go through these one at a time and then we're going to add them into google sheets so we'll create a row So we're going to add a row and we just need to make sure we reference this spreadsheet here. The ID is up in the URL up top here. So I'm going to copy that and I'm going to select from all, and then I'm going to drop this ID in the spreadsheet ID here.

It's going to reference this ID. Oh, it actually didn't. It said 403 permissions denied. Well, that's the end of this video guys. I'm sorry.

I'll see. I'm just kidding. The reason why is because we need to connect to the right. account, right? You can see I have tons of accounts here, but in this particular spreadsheet, I need to reference whatever the main account here is that this spreadsheet exists in.

And once you do that, that arrow go away, you can choose the spreadsheet name here, which is just going to be by default sheet one. It's just right here, right? That's just default.

You can add as many tabs as you want. And then we'll go ahead and we're going to add quote here from the iterator. And then we're going to add author.

Now, keep in mind that these values are dynamic. So for quote one, it's going to tell you, you know, maybe chase your passion, not your pension. And the author will be this. But the next quote it goes through will be the next quote and author. And then the third will be somebody else.

Right. And they'll keep going through over and over and over again. So I'm going to go ahead and do that.

And we're pretty much good to go. One other thing that maybe you want to add in here is. you can add a module in here and you can do Google Sheets. And essentially what you can do is like filter out existing quotes, right? Because maybe you're going through here and you're on autopilot one day and you maybe don't want to have like two quotes by Arthur Ashe that are the exact same. So how we could avoid that from happening is putting in a search step here.

And in this search step, we're just going to search. this exact spreadsheet. Once again, I'm going to have to copy in that URL or that ID up top here, and we're going to search for that. And as long as we don't find it, then we'll proceed onwards with putting that quote into the particular Google sheet. Once again, I got an error here, so I'm going to connect the right account in, enter in the sheet name, and then the search filter here.

What I want to do is I want to search by the quote. and we'll pass in the quote here. Okay.

And then it's just going to search for that quote. And there's two options. Either we find it or we don't find it. And in the instance that we find it, then we want to filter it out.

But if we don't find it, then we want to add the spreadsheet. So, if the row number exists or does not exist, then the filter will be passed and it'll move on to this. If it...

is found then it's going to filter it out. So in other words we're only going to add quotes onto this spreadsheet here if they don't currently exist. So if it generates this exact quote start where you are, use what you have, do what you can but it already exists in the spreadsheet then it's going to filter down. If it doesn't then it'll pass it through.

So that is step one in generating tons and tons of different quotes that you can come into every single day. The last thing here is scheduling. So we have schedule settings every 15 minutes. What I would recommend doing is like every day. So like at a daily interval, it's going to generate 10, 20, 30, however many quotes that you want, right?

Probably realistically, you know, five, six, seven, eight, and then you pick the best three or four to put on, you know, your Instagram account or whatever is probably the best, but you can do however many you want. If you want to do a thousand, 10 billion, whatever you can do that actually probably don't do that many because Instagram is going to block you if you generate like 10,000 trillion different reels at the same time. Do it with taste, something that's like reasonable.

Anytime you're doing any connections in make.com, if you were to send a thousand requests to Google Sheets in two seconds, you'd get blocked, right? For it's called rate limiting. and that would stop you for like 60 seconds or 10 minutes or whatever and then you get access again but just be careful with that kind of stuff as well and that's just software engineering for pretty much any single application out there that exists at all right super common stuff okay so we'll go ahead we'll run this scenario and we're pretty much good to go what we're going to do is generate the second scenario here so we've created all these quotes which is super cool right but now what we want to do is we want to actually turn these quotes into videos just like this one right here, right?

So we can go ahead and do that. There's a couple steps here to execute this properly. First things first, we got to create a new scenario, right? And this new scenario is going to be what actually ends up generating these videos and then ultimately posting them to whatever social media platform that you end up using, right? So...

how we want to go about doing this is we want to make sure that only when we are happy with a quote right it comes out you like it we only generate it if you click the plus button here and then we generate it and then if you like what was generated in terms of video then you only post it if you click the plus button or the the check mark here right so the next step is is that we actually have to go ahead and generate these videos and that's exactly what we're going to be doing in this workflow so we're going to create a um We're going to create a new workflow and the trigger is going to be watch changes. And anytime anything changes for whatever reason on this Google spreadsheet, it's going to trigger here. So we'll go ahead, we'll add a trigger here and I'm just going to call this reels for now. Save this.

It's going to give us this nice little URL here. This URL is unique to that particular scenario. This is the unique identifier. And then this is just like the make.com servers here.

But this URL here is completely unique to this workflow in your account. All you got to do is take that. go into extensions and if you haven't done so already in the add-on section just add make.com in here so at the top here when this eventually decides to load in three decades just search apps and type in make and then go ahead and download this make.com extension that I'm slowly trying to drip out my voice until okay here it comes but yeah there's there's the make.com extension you just have to honestly I think install this one time for your google account and then that's pretty much good to go and then in extensions you'll have access to make for bill sheets and in the settings here all you have to do is take this I this url here which you can copy to your clipboard and just paste it in here. And once you paste it in here, what this is doing is it's giving mate.com access so that anytime anything changes in this Google sheet, it's going to be received in this workflow here, right?

Which is super powerful stuff. Now, the next step here is we want to add a, um, a flow control and specifically we're going to add a router, right? Which is going to have two paths.

Path number one is to generate the video. Right. And path number two is to publish that video on social media if you're happy with it. So in the second path here, we're going to do a couple of things.

We need to use AI to generate not only the audio, but then also to generate the title and the description for that particular post. Right. So that if you post on YouTube or if you post on Instagram or wherever, you're going to have all the information you need. OK. Cool.

So we'll come back to the filters later on. I'm just going to leave these blank for now. But the first thing is, is we need to use something called 11 Labs. And this is going to be the technology to essentially allow you to clone your voice and then use it for these reels. So we're going to use create a speech synthesis.

And if you haven't done so already, you'll have to sign up for 11 Labs. And once you've done that, you can go into the account. I believe you do have to be on a paid plan to be able to clone your own voice. So just keep that in mind as well. All right.

So inside 11 labs, you can go into voices here and here's all the voices that they have. Our distrust is very expensive. If opportunity doesn't knock, build a door. Just trust yourself.

Then you will know how to live. It's pretty cool. And then you realize.

Hold on a second. I've definitely heard these like a million times before on Instagram and Facebook and all that kind of stuff. You can go ahead and you can create your own voice here in personal, just add a voice. And then it's going to ask you to upload like three or four or five minutes or a few minutes of you talking.

The more time you're talking, the better the results are going to be here. So just keep that in mind. And then once you generate that voice, you can come back into 11 labs and use it.

You will have to add your API key in here. And you can just find this simply by going into API keys here. and then referencing that for 11 Labs.

And once you're good to go there, you can come back in here, right? And then there's tons of different voices to choose from. I'm just gonna choose my own here. And then whatever model you want, I use the 11 monolingual version one model. The version two doesn't work for me.

And then the text that we're gonna use is going to be specifically from this spreadsheet here, right? So if we like a quote and we're like, hey, let's generate a video like. that, right?

It's going, we want to take this quote here that in this case, it says the only way to do great work is to love what you do, right? So we want to obviously take that text there and how we reference that text is in the first module here, right? So whenever we click generate, we are going to have access to the entire row here for that particular Google spreadsheet row. And we can just reference column A there where that quote exists.

So in row values, we'll just pull an A. which is where the text is. And then for stability, I am just going to put like a 0.4 here. Essentially, this is like how monotone your voice is or how crazy it is when you talk. And then similarity boost is like how similar it is to you.

I'm just going to put one. We can skip over optimize streaming latency. We'll click OK. Next deal here is I want to create the title and also I want to create the description.

for this if we end up posting it anywhere and we need that information so we'll go back to chat gpt and we're going to create a completion here in this particular thing we're going to select the model again which i'm just going to go ahead and select chat gpt 40 mini the max tokens here is 500 and this is going to be a super simple one we're going to use a user message and we're just going to ask it to generate us a title please generate uh us a title for this video. And I'm just going to give some context here. You're a social media manager and you're tasked with creating a title for a video. And then I'm just going to say oops please create a generate us a title for this video. and then I'm going to put a colon there and reference once again just the you know the actual text here and then that's pretty much good to go this is going to generate us that that title and then we're going to clone this and we're going to do the same thing but instead of for the title we want to generate a description so all we have to do is come back in here and ask it to generate a description you're a social media manager and you're tasked with creating uh oh my god this is atrocious what have I done all these spelling mistakes, a description for a video, please generate a title for this, please generate a description for this video.

And I'm also going to say, here's the title. And I'm going to paste in the result there. Just one more thing for both of these. I want to add an assistant which says, please don't include an intro or outro, just your response. Click OK, and we can save that.

And I just want to do that for the title, too, because, you know, sometimes it's going to be like, hey, here's your title. No problem. There you go.

And then if you post that, obviously, that's super embarrassing. So we'll click OK, save that. And that's essentially it for the first part here.

OK, so it's looking good so far. The only problem with this 11 labs thing here is that if we kind of like take a look at this, it gives us three values here. It gives us file name, data and file size. which means that the actual audio file it gives back is a file and it's not a link.

So we just need to make sure that we can download that file and then share that file with JSON to video so that we can generate the video using that audio file. So what we need to do in this case is download it using Google Drive and then share that so that we can generate the video using the audio file. So.

in the next step here we're gonna use google drive to download the file so or upload the file my apologies and um i'm just gonna go ahead and choose the right account here holy crap this is a lot of counts this is overwhelming okay just give me one second here sweet so i've connected my google account um connection back in there it did seem to expire and uh you can see here that it's attached to the 11 labs file here which mean this is perfect, which means we don't actually have to do anything in relation to actually uploading this file into Google Drive. And we're going to just put it anywhere you want to in whatever folder. So I'm just going to select from a list here and I'm going to drill down into my test folder here where I just put all the tests for all these videos. And we're going to save it into that file here.

Okay, perfect. We can click OK. And this is going to automatically take that file from 11 Labs, upload it, store it in Google Drive.

And now we just need to make sure we can share that file with JSON to video. And how we do that is coming back in here and creating another Google Drive module. And we're going to create a share link for the file, the audio file that we just uploaded to Google Drive.

So it's going to ask us for a file ID and we just need to reference the file that we just uploaded. And using make.com, we have access to all the previous modules, all the responses that we got back. And in this case, it's giving us the file ID here that we just uploaded. So we can just map that file ID into the file ID section. So we know which file we want to share.

The only other thing we need to do here is just make sure the type is anyone so that no matter who has this link, they can have access to it. We'll click OK. We're done.

Perfect. So that is essentially, you know, sharing 11 labs with. Text to JSON here. I'm just going to reference back here. Okay, sweet.

And the next thing here is we're actually going to now generate this video using JSON to video, right? So this is the fun part of the video. So before we actually go ahead and call this and create this, what I want to do is actually go ahead and create the particular video that we're going to generate.

So first things first, you need to click the get your API key here, and it's going to send you an email with the API key, and then you just have to sign up for an account. And once you have an account, you can go ahead and log into JSON to video, and we're going to go ahead and create a movie here, right? So how we do that is by heading over to the movie template section. And.

we're going to add a new template in JSON to video. Okay and I just created it here right so we have new template here and I'm going to click Edit here okay and we're now just as a refresher going to create this video right now I like this image and I like having you know my name and my handle and authentication you know the Instagram authentication little icon there as well So what I'm going to do is I'm going to recreate this image in the background, right? And how we can go about doing that is by logging into Canva to create that background image.

Now, just as a disclaimer here, you're going to see a shameless amount of YouTube thumbnail images in my Canva account right now for all of the freaking thumbnails that I've generated. But we're going to create a design here. And this design that we're creating for JSON to video is going to be a custom design. So up at the top here we can just click create a design and then in the custom size here we're going to enter in the width as 1080 and the height as 1920 pixels and we're going to go ahead and create this design here. Okay, sweet.

Now first things first, I'm going to upload an image in the background for myself. And the image I'm going to choose is this exact one here. Sweet. So in the uploads section here, I'm going to drag in my particular image here.

And I'm just going to size it appropriately here. So I'll go ahead, drag it down and give it the look and feel that I want to. This looks good to me.

And then we're going to go ahead and add in my username, my handle, another image here. And then that. little check mark icon here. So in terms of the image, if you go into elements, there's going to be these shapes here. We're going to scroll down and you got these frames here.

My apologies, not shapes. So we're going to drag across the circle thing here. And you're probably thinking like, what the hell? Like a cloud and skies and mountains. This is just a placeholder.

But what we can do with this placeholder is we can actually... essentially use this as like a clipping tool so that whatever image we put in here conforms to the circle so that it gives us that nice circle look for our profile image. So back to uploads here I'm going to add in another image of myself and I like this one right here so I'm just going to drag it over top and then it's going to essentially crop to that and you know this is kind of transparent in the background. I'm going to see if I actually have a different one.

that is more suitable for this. All right, perfect. So I'm going to go ahead and use this one and just drag it on top here. And then I'm just going to...

Nice. It gives it a nice little frame around here so that we can frame it properly on this image. Zooming in here, I want to add my name in here.

So under elements, once again, sorry, under text here. I will go ahead and write my name so add a heading here and I'm gonna write John O'Catliff. Maybe it might look better if this is just on a white like kind of white background just so that it offsets the black sweater that I have on here and cool so that looks good to me. I'll drag this down here maybe increase the height just slightly here.

Okay beautiful duplicate this this time I'm going to add in my handle here which could be like John O'Catliff and maybe I want to decrease the font and you could change the color if you want to but just in the spirit of making this somewhat fast I'm just going to keep it like it is and last thing here is I want to add an element so I'll type in Instagram verification and we should get all different types of graphics here And a lot of these, Canva is going to be like, hey, do you want to pay us money? And Canva, the answer is, is no, of course, I don't want to pay you money. So I'm going to choose the best looking free option here so that me and you guys can save some money doing this.

There was actually a really good Instagram handle here. Maybe it's because I actually used it, but it kind of looked like this. I have it in my library here.

That's probably why. But. I grabbed, okay, screw it. I'm just going to grab another one here.

Okay. I'm just going to use this for now. Just out of the sake of getting this done as quickly as possible so that you guys aren't bored to death with me picking or obsessing over picking the right icon here. Okay, perfect. So I'm going to add this in here.

We're good to go. This looks good to me. We can go ahead, download this, right?

And this is going to be the background that we use for this particular video. So downloading it, I'm going to choose JPEG just so that it compresses the file and it's a bit smaller. Download it.

That looks good to me. Coming back into JSON to video, we've gone ahead into the template we just created and we need to actually go ahead and create this video. So in the first scene, and we're just going to have one scene in this, we need to add an element in here. And the element I want to add is an image, right?

And the image we're going to add is what we just created in... Canva here. Okay, so coming back in here, hovering over the image, we should be able to upload this. So in the edit button here, I'm going to choose uploads and upload a file. And it doesn't look like yeah, it's Yeah, it doesn't look like it added it in here.

Sweet. Okay, so I've managed to I just redownloaded the image because Canva failed to upload it. We're good to go here. I have my next image uploaded. I'll save that.

So we're just going to choose this, save it, and scale to cover. Seems good to me. We'll take a look and see what this looks like. And there's a lot of different presets here that you can choose from. But what I'm going to do is I'm just going to leave this blank for now.

And we're going to. add one more element and it's going to be subtitles in here and the subtitles we're going to pass in in this make.com integration from 11 lab so we're taking these 11 lab subtitles and we're adding it to the video here we can go ahead and reload this and let's take a look and see if this comes up okay so it's looking all kind of jumbled up here right so obviously this doesn't look perfect so All we got to do is come into the movie template here and just make sure the resolution is the right resolution, right? So if we select Instagram story, now we have this image here.

It has the subtitles on here. And this looks really, really good. It's starting to come along nicely. So only other thing that maybe I would want to play around with here is in the settings, the position. I want to have this at the mid bottom center so that the subtitles.

you know, they are nicely positioned here, right? So kind of just circling back to playing this again, this is a sample text to test how it's going to work. And maybe one other thing that we could do here, now that I think about it, is in using the subtitles here, if we just hover over to this, what we could do is like classic one word. So if we come here and instead of it being like, it's just one word at a time, right? which is pretty cool.

I like that and maybe we just want to increase the size of this. So font size might be like 50 for example and if we play it one last time, oops we're just going to reload this and take a look. Yeah so maybe maybe we do 100 here and play it again.

So there we go. So that looks good to me. I'm pretty happy with the way this looks.

We got our image, we got the subtitles and the subtitles. It's just putting a boilerplate default on there for now. But when we actually generate it, it's going to be using the exact audio file that we generated using your voice too. So how we go about doing that is coming into we just want to hover over the movie template here and select JSON. And we're going to copy all of this over, right?

And circling back to make.com, we're going to use HTTP request to access JSON to video. They don't have their own built-in native integration in make.com. So we'll use a make a request HTTP module. And just skipping over this now because we just copied this in, we're going to go into the body type. It's going to be raw.

And the content type is going to be JSON application. And we can put in the request content down here. So we're just.

copying and pasting all of this and we're pushing it into here. Now there's a couple other things that we need to do here in order for this to work and simply put I'm just going to search up their API documentation so I think it's always good to walk through this kind of stuff together so that you guys can actually see how it works instead of me just copying and pasting it in. So I'm going to go JSON to video API documentation and they're going to tell us exactly what they want here.

So in API specification Um, There's a couple things that says, hey, you need to include this. And here's the endpoints. So if we want to create a movie, we need to send it to this URL address here.

And we need to make sure that it's a post. Post is sending information and a get is retrieving information, right? So I want to get information. I want to get the film back or I want to post or send to JSON to video so that I can create this. So in the URL, we'll paste that in and the method is going to be post because we're creating a video.

And it also tells us, hey, you need to have authentication here. So the authentication, the key here, x-api-key, we're going to have to include this in the header section here. And we just paste in the name exactly what it is. And then for the actual API key, your API key, you don't copy this in.

You put in your exact API key. I think I have mine somewhere here. So I'm just going to copy and paste this in here. So this is mine. Feel free to use it if you want to.

It's a burner one anyways. And we're good to go, right? So this effectively should generate it. We just need to do one more thing here. And in this HTTP request to JSON to video, we need to add in the audio file that we created from 11 labs.

So in the subtitles section. Here, actually, yeah, what I want to do is I want to add in another line here. So I'm going to copy this line, paste it down.

Now, anytime you're dealing with JSON, right, you want to make sure the last item in a collection like this, this is a collection between these square braces. You never have a comma at the end, just like or else the JSON is just going to fail. You can see here it's like comma, comma, comma, comma, comma, comma, and then there's no comma here.

So just make sure there's never a comma at the end here. And for font size, we're going to change this to SRC, which is essentially the link in HTML or JavaScript or whatever. SRC stands for like essentially the link that you want to pass in so that it knows where to get the content.

And we'll paste in these like we're making sure this is a text, right, by putting in quotations around it. And we'll pass in this web content link. There's two links here.

There's the share link and the web content link, the web content link. is essentially as soon as you hit that link, it's going to download the file, whereas the web content link, you can just view it. Instead of viewing it, we want to download it.

We'll click''Okay, save this''and we're good to go. This is going to generate us this file. Now, just before we go ahead and run this, I want to build up the rest of this workflow here.

Unfortunately, when you're dealing with API requests using make.com, It's not like custom code where you have a lot of flexibility where you're like, okay, send this request and then wait for it to return. And then once it returns, then you can, you know, essentially retrieve it or you can pull, which is sending a request being like, Hey, are you done yet? Hey, it's like a, it's like, like annoying, like, you know, I don't know, like when your sibling is annoying you, Hey, you done yet?

Hey, you done yet? Hey, you done yet? That's what pulling is.

You can't really do that really easily in make.com. So what we have to do is use something called a sleep function. And a sleep just delays in a matter of seconds until a certain amount of time.

I'm going to put 50 seconds here. And what we're doing here is saying, hey, we're going to wait 50 seconds and this video should be done in 50 seconds. And then after 50 seconds, we're going to see if we can retrieve that video. And in the retrieval process, we're doing another make your request here.

And in this case, it's going to be a get method. And you can see I'm actually going to delete this and I'm going to. clone this module instead so we have all the information again because it's the same URL here. I'm just going to make sure the endpoint is the exact same so we'll copy and paste this in and then the method here is a get request right so we're just requesting that particular file and because we're not posting anything we can just delete all of this and in the query string we all we want to do is just make sure to add in a project here and then we're going to pass in the project from this request.

So I'm going to go ahead and run this right now and we're going to create this. So in order to create this we're just going to have to run effectively the whole scenario here. So I'm just going to zoom out here and click save and let's give this a shot. I'm going to run this and as soon as we generate a response from this sheet, it should fire off everything.

So in this case, Steve Jobs, it's your day today. We're going to generate a quote from you. So we've generated this, we've generated the title, the description, we're saving them to the drive, and we have received an error on this HTTP method, unfortunately, that did not work properly.

Okay, and the reason it didn't work is because I put the SRC in the wrong section here. So if we come down here, I put the SRC in the subtitle section. And that means that I didn't actually include an audio section in this JSON to video. So coming back here, we're going to add an audio element into this. And then we will redo this one more time.

So clicking on the movie template here, copying this, coming back. in here, pasting it in and everything should work pretty much perfectly. It's just this section here, we got to do that one more time. So we're going to change this so that the SRC is here, removing the comma at the end.

And instead of audio, we're going to choose this web content link here, click OK. And now this should work. I'm going to just run one. I'm just going to run this module by itself by copying in the web content link here and running this to see if this works. So we're going to run this one module and it looks like we got a status 200 code, which is essentially the web's way of saying good fricking job.

You did it, man. Amazing work. So that's pretty cool. And coming back, we need to retrieve this file, right? And how we are going to retrieve the file.

is by grabbing the project ID here. So if we zoom in, we can see in the data, it says project. And I'm going to copy this code in here. And we're just going to paste this value right in here. It should say project somewhere here that we have to, yeah, get the status of any movie by passing the project ID in the query parameter, right?

So it tells you right there, hey, in the query parameter, which is the query strings, you need to have a key value pair. The key or the name is project and the value is going to be the actual, well it's going to be the value of the project. Now just one other thing that I realized that I made a mistake on is that we need to make sure that we parse the response here and we give it one more shot because right now it didn't parse that response.

So in other words, it's giving us this JSON data here which is obviously not ideal. So I've just gone ahead and I've copied the SRC again. I'm going to run this module one more time, paste the web content link in here, run it, and it should give us a success again.

And this time the data is parsed, right? So we have project and we have the ID here so that we can just automatically map it to this HTTP module here, right? So in HTTP module, under the project we're not hard coding it in there but rather we're just passing this in as a variable and then clicking okay and saving and this is going to effectively save that id and it's going to be dynamic so every new video that we produce is always going to be something different we're pretty much there we're almost done just a couple last steps here is really we just need to add all this information back into our spreadsheet.

So in Google Sheets, we're going to update the sheet with the link to the video, with the title, with the caption, everything we just generated here. Right. So we're going to update a row and just make sure we have the right connection here.

And once again, I'm going to copy in this ID here and select from all. and enter in the spreadsheet ID. Oh man, spreadsheet name. We're going to un-map that and select sheet one.

This is so tedious. I think I've done this like maybe maybe like 2,000 times in my life. Oh my god, this could be like a full-time job.

Honestly, the amount of times I've done this has been ridiculous. I don't even know if anyone's as certified to be professional at entering in boilerplate. make.com Google Sheets IDs than I am at this point in my career.

Like this is, it's unbelievable. Anyways, enough rambling about that. We're going to grab the row start or the row number, actually from the initial start. If you guys recall the beginning of this, the trigger is the Google spreadsheet row. So we know the exact row and we're just going to reference that right back in here.

And then in the link section, we'll, we'll go ahead and. copy in that information that we have here. So I'm going to manually run this project here. So I'm going to grab the ID just so we have the right information here and we can map it into this Google spreadsheet because right now we don't have the link to the video because we haven't run this module yet.

So we'll run it, enter in the project ID, click OK, and it's going to give us the link to this so we can just map it into this spreadsheet. So under the link section, Oh my god, I just made the same mistake again. We need to make sure this is parsed or else we're not going to be able to access the information properly and run it one more time. I apologize guys, it's like 8pm here.

I'm getting tired. So I'm making some mistakes here. Okay, cool.

And we'll come back in map in that link. So under movies here, we should have the URL. And then we're going to pass in the title and the caption. So if you scroll all the way down here, we generated that title and we also generated that caption here. Right.

Well, click OK, save it. This is going to update the link title and the caption as soon as the image, the video is generated. Right.

And then, you know, let's say that we take a look at the video and we like it. Right. And it looks good to us and we're happy with it.

Well, the next step is posting it on social media. Fortunately, because everything's already done, this should only be one step. The only thing that we need to really do now is just add in filtering. So we have two columns here, one for generating the content, which is actually generating this video, and then one for all generating the social media posts.

And we need to make sure that when we click generate here, it only goes down the generate path. And when we click post, it only goes down. posting path and how we do that is by adding a filter here on the this router so this is going to be generate content and the filter here these are going to be actually pretty similar filters the value which is essentially whatever the value is of the change so if i want like this the value would be this text right here right so whatever the changing value is it needs to equal true and i always like making sure this is case and sensitive And I also want to make sure that the column that's updated is column G.

So this is 1, 2, 3, 4, 5, 6, 7. So column 7. So column start is 7. And lastly, I want to make sure that there's actually a quote here. Because if you click it and there's no quote, it's going to throw an error. So I just want to put a failsafe that whatever is in column A does exist. So there is a quote.

And as long as all three conditions are met, it'll get on this path. And similarly, this is going to be publish content. And I want to make sure, once again, the value is true. And this is case insensitive true. And the column start, I believe, is eight.

I'm just going to double check. One, two, three, four, five, six, seven, eight. Perfect.

And also the URL, which is in column D. exists as well. And as long as all of that is met, then we'll push it past this path.

And really easily, we can just add this to Instagram, right? So Instagram for my business, create a real post, you'll just add in whatever connection you have here. And then the video URL is going to be column D. And then the caption is going to be caption column F, which we generated up top here. So column F is here.

And that's pretty much it, right? As soon as you know, you want to publish it, it's going to go be posted immediately on social media. So that's essentially it, we can go ahead and we can run this and, and just take a look. Actually, before I run this, I'm going to come back in here and actually just view the video just so you guys can see. So We'll actually view it as we're running it.

Oh my god, I can't make up my mind right now. Sweet. Okay, so Steve Jobs, actually, we're going to go to this next one here, the best time to plant a tree is 20 years ago, the second best time is now.

I actually love that freaking quote. I use that all the time. So we're going through and running it.

And we're going to go to render logs here to take a look at the latest video that we did. Let's preview this. Let's play it. The only way to do great work is to love what you do. Perfect.

And there is the reel that we just did, right? And if I was like, Hey, I really liked that. Then we just go ahead and we click post and then it would go over to Instagram or whatever.

So we just generated another video. It's going to wait 50 seconds, retrieve it, send that information, like the link to the video and the title and the caption back in here. And as long as you like that, then you post it.

And that essentially guys is how you can make an unlimited amount of Instagram reels. of TikTok videos, of Instagram, of YouTube shorts, right? The cool thing is, is it's blending AI and automation with manual intervention, right? Because for me, like, and I'm sure you guys probably feel the same way. Like you wouldn't want to clone your voice and just send out a million piece of content on the web without taking a look at it.

So in this case, what you can do is you can generate and step-by-step, if you don't like anything, just toss it aside, generate another one. The cool thing is, is you're generating all these ideas every single day automatically. You come in, you might have 20 or 30 ideas to pick from, you choose five, and then you just automatically publish it to Instagram or whatever. you know, when you're ready to go and, and, and that's it.

So I hope you guys found value in this video. If you did make sure to subscribe to the channel down below, give me a thumbs up, uh, if you liked it. And also if you have questions, leave it in the comment section down below. Thanks once again, guys, and I'll see you guys in the next video. Thanks.

And bye-bye.