Transcription
What's going on, guys? It's Jono. Today we're talking about creating an automatic content machine for your business. Take a look at this.
So, in front of me, I have Semrush. What we're going to do is we're going to use Semrush to find amazing, winning keywords that you can create blog posts around. Right? Keywords that have a high amount of volume and low competition. So that when you publish blog posts—and these blog posts, by the way, look something like this—when you publish these blog posts on Google, you can pretty much rank to rank one for a lot of these keywords on the first day. I know that sounds crazy, but uh, and and honestly, I didn't believe it at first, too. But after doing this for a year, I know it is completely possible. You just need to find the right keywords.
Once we find those keywords, we're going to use a tool called make.com to automatically generate these blog posts using artificial intelligence and automation. And we're also—once these blog posts been created, once again, this is kind of what the blog post looks like—we're going to post it to social media to drive traffic organically over to that blog post. You're going to be posting on Facebook, Instagram, X, Twitter, Tumblr, Pinterest, LinkedIn—all of these platforms.
How this setup works is we're going to be doing keyword research on Semrush. Once we find the gold nuggets, we're going to import them into this marketing spreadsheet here. When you're ready to go to generate a blog post, all you have to do is select, you know, "approved" here. It's going to generate the blog post in column Z. And then once you're happy with this blog post, you upload it into WordPress, and you change everything, and you, you know, you get it SEO optimized. Then what you can do is you can hit this next button here, um, which is "approved," and then it's going to push that content over to social media. So it's going to slightly alter the content to make it friendly for Facebook and Instagram and Twitter and Tumblr and Pinterest and all that kind of stuff and then push it over there.
This works wonders for me. It allowed me to essentially skyrocket the traffic that I get to my website. Just as an example of what that looks like, this is my website. I started around December 2023. I was getting probably like 10 clicks on average a day, maybe 15. Um, and now I'm up to—at the highest point it was 1,500. It's dipped a bit here; it'll keep going up. But yeah, it's essentially just skyrocketed my, my search volume.
And this is cool, right? Because not only do I generate organic leads through this, right, so people inquire about my business, but I'm also driving ad revenue from Google AdSense. For something like this, I think we generate like 500 bucks a month on AdSense revenue. So it's not anything like crazy, but it's also 500 bucks, so I'm not going to turn it down. And, uh, yeah, there's a lot of other things you could do here. Maybe you're driving affiliate sales; maybe you have an online store that you're selling things through. So there are endless possibilities to turn that attention into, uh, money, right? And in this video, we're going to be doing just that.
If you guys are new to the channel, please hit that subscribe button down below because I will be releasing videos just, just like this one, every freaking single day. And also, with all of these blueprints, they are free down below. All you have to do is come into make.com, hit these three dots, and import the blueprint straight into your account. If you guys have never used make.com before, don't worry, we're going to be walking through this step by step. And I also have my, an affiliate link down below. If you guys sign up for make.com, I will send over my top 10 blueprints that have absolutely been game-changing for my business. And I know if, if it's been game-changing for mine, I'm sure you'll find some in there that will also be game-changing for yours as well. So, with that being said, let's dive in and start. [Music] Now. All right.
So the first thing is is we need to use Semrush. Right? The thing about Semrush is it's freaking expensive, man. Like, holy cow, it is very expensive. I've been paying this—it's about like $200 Canadian a month just for one software. Um, but you guys don't have to pay that. They have a free trial here for 7 days. I would just go ahead and create this free trial, and you know, if you need to create another free trial again a year later, you can go ahead and keep doing that as many times as you want, uh, just with different emails. But essentially what we're using Semrush for is keyword research, and this is going to help you find those golden nuggets in the, uh, like the needles in a haystack.
So essentially, in Semrush, when you create that free trial and you log in, you can go over to something called the keyword magic tool. Down below on the sidebar bar here. Now, what the keyword magic tool does is it's like a magic wand. I'm just kidding. It's a tool that allows you to find the best keywords to be able to rank for. So let's say, for example, you are a plumber, okay? And what you can do is you can come in here and you can type in "Plumbing" in the keyword magic tool, and you can choose the different market that you want. I'm just going to stick with the United States because I'm going to assume that that's where the most of you are going to be driving your traffic from. And when you type in "Plumbing," it comes up with 8,48, 8,8, 848,000. Oh my God, that was like shameful how many times it took me to say that. But anyways, there's a lot of different keywords here, right? But not all keywords are created equal. So a couple things are: you can see the keywords, you can see the intent, the volume, and the KD stands for keyword difficulty, right? So there's a couple modifications we want to make on the screen to find those winning keywords that are going to be super easy for you to rank for. The first one is volume. I don't want to waste my time on keywords that are under 100 um in volume, right? Maybe you could go down to 50 to start, especially if your, your website's new. You're going to want to rank for those keywords that nobody else is ranking for. You can start with a volume of 100, right, which means that every single month there's at least 100 people that are searching for this particular keyword, right? If there's 90 people searching for it per month, then it's not going to show up on this list because we filtered it out. The next one is keyword difficulty, right? So you can see how they classify keyword difficulty here: very easy, easy, possible, difficult, and hard. For the majority of small service-based businesses out there, I would not recommend trying to go past 30 on the keyword difficulty score because your website will be competing against other massive websites. There's a lot of the sites out there like WeddingWire, Houzz—or I don't even know if I said that right—or Angie's List, or, or, or whatever, and they're going to dominate the top of the search, and they also write blog posts as well, and you'll be competing against a lot of these people. What you want to do is find keywords that have a difficulty score of 20 or less, but for the purpose of this, I'm just going to type in 30 so you guys can kind of take a look and see what this looks like. And now we're starting to chisel down to the exact kind of keywords we're looking for, but there's key—every keyword um is not created equal, right? There's different intent behind the keywords, and if you're writing a blog post, the intent behind a blog post is it's informational, right? So you're providing an answer to a question that somebody has. With that being said, you want to find the intent to be informational, right? You don't want maybe a transactional keyword because writing a blog post around "Plumbing near me," well, that's not blog post material, right? And it's also not going to rank on Google because the intent is not aligned with the search. It's not that it won't rank; it'll just be much more difficult to rank, potentially, on Google. So we want to filter for informational keywords here and click "Apply." So now we have three separate um filters going on here, and now we can start seeing the keywords that we potentially could rank for. There's 4,997. So, "how to become a plumber," right? That could be a keyword that maybe you want to rank for, but the only problem with this is that this is not the same target audience as a plumber business trying to contact clients, right? So if you're reaching out for clients, probably not the best keyword, but if you're looking to help people get started in the space, maybe it might be. We can sort by the keyword difficulty score here, and we'll start with the easiest and then we'll work our way up to the hardest. So I'm going to just filter this downwards here, and we can just go through. Okay, that uh didn't seem to work here. Let's try that again. Okay, sweet. So, um, here's some really easy ones, right? Um, obviously these are probably not going to be ideal for us right at the, the lowest level, but like, uh, who knows? Like, "brass fittings Plumbing," that might be a business. Uh, what we're going to do here is we're actually going to do a keyword difficulty of five to 30 here just to filter out all of these like companies in here that uh we don't want to rank for. Okay, sweet. So maybe "AI Plumbing" is something that you'd want to rank for; maybe "air chamber Plumbing," "air compressor Plumbing setup," right? So this could be a great one to, to write about. "All-in-one Plumbing"—who knows, maybe that's a company, maybe it's not. Um, and then "copper plumbing tools," "cost of Plumbing for a new house"—this is a great keyword to rank for, right? There's not a lot of—it's, it's very easy; there's enough traffic to make it worthwhile. So you can keep going down the list and just essentially adding all of the uh keywords that you're looking to rank for. So maybe I just want to choose this keyword, and maybe I'll just choose one more where it's like, um, "offset Plumbing trap" or whatever. And tell the plumbers out there, I have no freaking idea what this means. Maybe this is good, maybe it's bad, but you just essentially want to export this list and then dump that list into a spreadsheet like this, right? So I'm going to go ahead, and I'm actually going to create a new spreadsheet here so that I'm not working on my current one, just so we can kind of walk through this together. But I'm going to have a couple things in here, so I'm going to have "Keyword," and then I'm going to also have just, uh, "Create Blog Post," and then "Social Media" here. So I'm going to have three different things here, right? And let's just say for the, the case of this, instead of just, uh, you know, instead of just actually exporting this, I'm just going to copy this one keyword over here just as an example, and we'll paste it in here. Okay, sweet. So I have my one keyword here, which is "cost of Plumbing for a new house." Now, now that we found good keywords to rank for—keywords that once again have high enough traffic but low keyword difficulty score—we probably want to create content around this because it seems to be something that um has been neglected, or not a lot of people are ranking for. And sometimes this is a bit misleading, and sometimes it's not—not always 100% accurate, but by and large it usually is, and this will help you rank really fast for really high-quality keywords.
So we have this keyword now. We want to create a particular blog post around this keyword. So that is where make.com comes in. If you guys are new, you can download or find the affiliate link down below with my top 10 blueprints. And once you're inside, we're going to create a scenario. So in the "Scenarios" tab in make.com, what I want to do is just start off by creating a particular scenario here, and we're going to work around creating this a blog post for this keyword, "cost of Plumbing a new house," right? So automatically the first thing that we have to do is we need to um create a dashboard-like system here where when we find keywords here and we dump them in, then we create them from within this Google spreadsheet. How we do that is—this is probably the simplest way, and the way I like to do it—is just have checkboxes here, right? The cool thing about checkboxes is it's either a true or false value. If it's unchecked, it's false; you can see up here. And if it's uh checked, it's true, right? So when, when this is checked true, then we create a blog post for this particular keyword. Circling back into make.com, how we make this happen is you can see just thousands of different applications—make.com. The one we obviously want to use is Google Sheets here, and specifically we want to watch for changes. So anytime a change is recorded in our Google Sheets, this uh will start this workflow, right? So, um, we have a webhook here, and this webhook is something we're going to have to create. So we'll add a webhook, and maybe we'll just do like "content machine"—you can name this whatever you want; it really doesn't matter. And then after it's been named, it's going to give us this uh link here, right? And if I just take a look at this link, there's two components to it: there is a unique um ID in the link, and then there's the make.com URL, right? Now, the thing is is this make.com URL is just their, their domain, right? It's a subdomain of theirs, but this unique identifier is essentially saying, "Hey, this is unique to your account and to your particular make.com scenario." So if, uh, anytime any change is sent to that URL, it's going to start this particular workflow. So coming into our spreadsheet here, and I'm just going to title this "content machine," what we need to do is two things to set this up properly: we need to go into "Extensions," "Add-ons," and "Get add-ons," and this is something we only have to do one time for your Google Chrome browser. And then once it's done, you never have to worry about it again—again, for hopefully like 5 or 10 years—but you can just type in "make" at the top, and we need to download the Make extension for Google Sheets, which is right here. You can see a ton of people are using it. Once that has been installed on your particular uh Google Sheets or Google uh account, back in "Extensions," we can go to "Make for Google Sheets," and in the "Settings" tab, right, of this, we can enter in that URL that we got from this webhook here and just paste it in the webhook URL. You'll have to scroll down, click "Save"—couple seconds; it's going to automatically save, right? And okay, there we go. And anytime we change anything now, it's going to run. Now, back in this scenario, we can just click "Okay" here, right? And I think my face is probably slightly blocking it, but there is this like massive uh purple "Run once" button down here. Sorry, guys, if my face is blocking it; you just have to click this thing at the bottom left corner—the massive blue button—you can't, or purple button—you can't uh miss. And it's going to push this into test mode where all of a sudden we're going to be able to see live, in real time, the results come in from a test. If I come in here and click this, right, uh, changing the checkbox value to true, it's going to um send the results to this particular make.com scenario, which we can see here—this like cloud-like button is going to show us the results. If we come in here, we can see a couple things about this: first of all, the value is true, right? So the value is what we changed; in this case, it was column C, row 2; we changed this to true, so that is being logged in the value. We can see the range, right? So the column start and end and the row start and end, so it started on row two and it started on column three, which is column C, and it pulls in all of the other values from that particular row. So the cool thing is is coming back in here, if we go to the "row values" and drill down, we can see the keyword there, which is awesome, right? Because we're going to be using this keyword to generate a blog post. And how we do that is we're going to create another particular module here, and we're going to be using artificial intelligence to generate this blog post for us. And specifically that AI—and you can, there's a lot of different models you can use—but for me, I'm going to use ChatGPT, and in, in OpenAI ChatGPT, I'm going to use uh this one right here, which is "Create a completion." Okay, sweet, awesome. Now, if you guys haven't set this up before, you can click "Add," and you have to add in your API key and your organizational ID. If you go to platform.openai.com and you sign in and you go into your settings, which is this right up here, um, you're going to find your organizational ID and your API key from right within it, and you can add that in here. Now, keep in mind this is different pricing structures than just ChatGPT; you do need to add a balance of at least $5 to get started using the API in ChatGPT or OpenAI. Okay, sweet. So now that that's done, the first thing we want to do is we want to create this blog post, and how I've actually done it here is I've broken it up into a couple different modules. The first one is is I want to create an outline for that blog post, and the reason I want to create an outline for that particular blog post is because um a lot of the times—at least at the time of this recording, in the past—when you're dealing with creating blog posts on ChatGPT, it only gives you a certain output of like maybe 800 to a 1,000 words, right? And that's going to improve and get longer in the future, but giving an outline gives it more data to work with, and the more data you have to work with, the better the response is going to be. So I like chunking out the work into steps to feed into ChatGPT to get the most desired outcome possible. So circling back, we're going to create that outline, then we're going to create the blog post, and then we can do SEO optimization on it, and we can also change the tone of voice here to make it feel like it's more in alignment with your brand or your values, right? So, uh, coming back, we're, we have a couple things to fill in here. So the first thing is is the model; I'm just going to go ahead and use ChatGPT 4 0 mini. This is a bit cheaper than like 4 or whatnot. You can also try the newer series; it just came out a couple days ago. And we're going to enter in the max tokens here, which I'll put 2,000. This essentially is anonymous with how long the response could potentially be at a maximum, and it's also cor—it also uh correlates to the amount of money you're spending; the longer the response, the more money you're spending. Awesome. Now, with the message, the role that we want to use is a user role, and we're going to essentially give it a message. Now, I'm just going to copy in this message here to save a bit of time. So what I want to do is say, "Create a blog post outline for this blog post idea," and then we can just enter in that particular keyword that we got in our spreadsheet. Now, remember when you click "Create" whatever in column B, right, it's going to have access to the whole row, so we should have access this keyword in make.com, which it is in "row values" and column A. So that's going to pass in "cost of Plumbing a new house," right? So now we're going to create a blog post around this, and there's just a couple other things that we want to potentially add in here. And the next thing is is I'm going to add "assistant" to the main prompt here, and, um, uh, you know what, I'm just actually going to delete this; that looks good to me for now. So we can go ahead and try this out. Um, so I'll just zoom out here; we'll "Run once," and we will click on one of these, and we'll see the results that we get here. So it's come in, and now it's going to create this blog post outline for us in a couple seconds here. Sweet. So we can take a look at the results, and this looks pretty good to me. It's using markdown language here, which is, you know, these, this is like telling it like this is like a header 2 or whatnot; this is a header 1, which is um for like SEO and titles and all that kind of stuff. Now that we have this particular uh blog outline done, the next step is is I actually want to create a blog for it. So I'm just going to duplicate this by clicking "Clone" down here, and I'm going to move this over, and we're going to change the user message here, which is "create a blog post from this blog post outline," right? So now we're going to take that outline and we're actually going to generate a blog post from that outline, right, which is awesome. And then there's just two more things that I want to do in this particular um scenario, which is I want to optimize this for SEO, and then I also want to change the tone of voice for this particular blog post to keep it in alignment with what uh my writing style is, right? So the first thing is is to optimize this for SEO. Now, in this video, I'm not going to go through everything that you should be doing to optimize it for SEO; I'm just going to cover a couple things, but please keep in mind that you can make this as complicated as you want. I will be going through another video explaining how I generate my blog post, but it's just a bit intense, especially for a video that's encompassing three components, which is the keyword research, the blog post generation, and the social media posts. But this is kind of what my particular blog post looks like. I will literally go through the process of generating external links, internal links, and generating the whole outline for WordPress so that it automatically gets uploaded, or at least it's just one-click upload; it's SEO optimized, and it goes to like a Yoast checklist to make sure everything's perfect, right? So essentially, one click of a button, everything's done. So I will be going through in a later video, but for the purpose of this, just to kind of get you guys up and running, and I did, I did it like as I'm showing it to you now; I, this is how I did it for the first year. I'm currently working on that other part right now, which is why I'm going to save it for a later point in time after it's been completed. But effectively, we're going to do some SEO optimization at this particular point in time, and I'm just going to copy in from my, from my previous module here so that I can show you guys what this looks like. So I want you to rewrite this blog post uh to make it SEO friendly, right? And in the additional messages here, we can add in like assistant messages, and we can add in whatever it is that we're looking for, right? So in this case, I'm just saying, "Make this blog post SEO friendly by including five different keywords this article could rank for. Incorporate these five keywords uh with a keyword density of about 3 to 5%, which means, for example, if the blog post is 1,000 to 1,200 words, there should um oops, there should be between 36 to 60 keywords in the blog post. To make sure the top keyword is in the header of the title and found in the first 150 words of the article." So kind of stuff like that, right? Some of the basics of um SEO optimization. But essentially what you could do is just go through the checklist here on Yoast; it gives you a pretty comprehensive guide on how you should…
Structure your on-page SEO. If you download the Yast SEO plugin for WordPress, or you find something similar, you could use Google Lighthouse. This is a free tool by Google that I use all the time when ranking my sites. This is for on-page SEO and also technical SEO as well. This really helps out; it's just like a free extension that you can add on and run to see how well your site is performing. But this, at a high level, is just going to give you—oops—all the kind of stuff that you probably want to do, like to structure your page in a way that's going to be SEO friendly: outbound links, image key phrases, images, internal links, keyphrase density, keyphrase length, included in the meta description—all of that kind of stuff that's going to help rank. Because it's not good enough just to create a blog post; you need to make sure that it's actually SEO optimized. Otherwise, you're just going to waste your time, and nobody's going to see it because it's not being targeted toward the right audience. We can slightly do this with AI, but then to take it to the next level, you will need to likely spend a bit of time or hire somebody to spend a bit of time to actually improve it. These are things that you could probably get done in a few minutes after the blog post has been created.
Okay, cool. So that's essentially step three of this, and then the last thing I want to do is I just want to actually change the blog post so that it's more in the right vocal tonality for me. So I'm just going to paste in the blog post. Just remember to chain the last blog post to the next step. For example, after the outline has been created, we're going to call that outline here, right? And then, oops, I'm just going to click the results here, and then this for the SEO optimization. Okay, my bad; I was actually looking at the wrong module here. But just make sure that you chain it so that we're always looking at the previous module. For example, we want to create a blog post outline from this, but we don't want to reference the particular keyword in the Google spreadsheet, but rather what we want to do is we want to reference the outline from the previous ChatGPT module. So we'll add in the result there, and then the next step is the SEO optimization, and this we're going to reference from here—the result of the blog post being created, not the outline. And then lastly, for the tone of voice, what we want to do is reference the SEO optimized version of the blog post. So in this, we're just going to say, "Please rewrite"—actually, I'm just going to copy this in so that we can go a bit faster here—"tone of voice." Let's see. Okay, sweet. So I'm just going to copy this and paste it in here: "Please rewrite this blog post with a tone of voice that is fun, lively, and engaging. I want it to be funny at all times, as it seems, and have it seem as though you're smiling while writing this blog post." Now, just as an example, I'm going to add in one more assistant message here, and I'm going to paste in this blog post example, like this excerpt that I like, and it says, "Here's a blog post in a different industry. I want to copy this tone." And this is just—to me, I find this really funny, this kind of writing. So I just want my blog posts to be fun and engaging because, at the end of the day, especially if you're writing about things that are boring, there's nothing worse—like you want to at least keep it engaging and fun to have people actually stay on the page and engage and keep reading because those metrics are good, and it's going to signal to Google that you're writing well, and it's going to rank your blog posts better. If you keep it dry and boring and unengaging, people are going to bounce quickly, and it's not going to help you rank. So what I like to do is connect with people through humor, and that's why I want to change the tone of voice to something that's fun. Usually the stuff is pretty dry and boring, but if you can just change the tone of voice, you'll hopefully keep people on your blog post a bit longer.
So this is kind of what I'm looking for, and then ultimately, speaking with that being said, we can go ahead, and we can just dump this into a Google Doc here, and then we can just upload this into our WordPress website. So this is going to be called the keyword name, which is the row value A, and then the content here is going to be the result that we got from changing the tone of voice, which is the last particular AI module here. So we're going to choose the location for this, and I'm just going to put this in my test folder here, and we can try this out; we can give this a shot. So I'm going to run this once, and we're going to create this blog post here, and let's see the result come through. I'm going to pause this and come back after it's been completed.
Okay, so we've generated this blog post, and we can take a look at it: "The Whimsical World of Plumbing: What to Expect When You're Expecting Pipes." Hey there, future homeowner. So you're about to take the plunge—quite literally—into the world of plumbing for your brand new house. I know, I know; the cost of plumbing a new home isn't the most exhilarating topic on the planet, but bucko up, my friend; we're diving headfirst into the murky waters of pipes, toilets, and the sweet sound of running water, complete with a splash of humor and a dollop of charm. Are you smiling yet? So to me, that's like, you know, pretty awesome, right? This is the tone of voice that I like, and to me, like if I was personally coming across a blog post like this, talking about plumbing—which, once again, sorry to all the plumbers out there—I would want to—I would just find it so dry and so boring to read about pipes, but with, you know, with a tone of voice like this, all of a sudden it's fun; it's engaging; it keeps attention for certainly longer than it would have if, you know, it was written really dry.
Okay, cool. So we have our particular Google Doc here, right? So this is awesome. You can go ahead and change this however you want. If you want to change the output here, maybe, for example, you want to make sure that it's only HTML or Markdown or plain text, you can add in the last ChatGPT module here in assistant where we just say, "Please make sure the output is plain text," and then we can also add another assistant here where we just say, "Please make sure not to include any intros or outros." What this means is, like, you know, you probably don't want at the beginning of the blog post the end being like, "Hey, no problem; I can write your blog post. Here it is," right? You just want to have only the blog post; no intros, no outros, none of that BS—straight to the point, right? So here we have it. From here, you'd essentially just take this, and then what I like to do is I'll have a particular template in my WordPress for blog posts, and I'll just duplicate that template over and over and over again for every single blog post, and then I'll just fill in the blog post with the right information that came up on the AI-generated blog post that we just created here. I do have writers, and these writers will go through and change everything. I do believe strongly in the fact that you should have somebody moderating this content and not just publishing it blindly, right? Not only because you obviously want to represent yourself well, but also because it's going to lead to better results in the end. So personally, have somebody take this, upload it, proofread it, change anything that needs to be changed, make sure it represents my company well, and then, you know, if you want to add in affiliate links, you can go ahead and do that. If you want to add in links to your store to sell products or services, you can go ahead and you can do that as well. If you want to, you know, all of that kind of stuff, you can add AdSense to it as well, and also you can have a call to action at the bottom here where you can get a quote, right, which is awesome. So there's lots of ways that you can monetize these blog posts, and the easiest way to do it is just create a template where every single blog post you generate goes into the same template. It's going to make it nice and easy for you to upload this, and hopefully it's not too long. I also like the call to action up here as well so that it's fixed to the top; as you scroll down, you can have a call to action to push somebody to take, you know, whatever action it is that you're looking for them to take.
Okay, sweet. The last thing we just need to do here is we need to add a filter to the start here, and actually there's two things here: we need to add a module, and this is going to be a flow control and a router, which means that there's two potential paths that's going to go down: path number one is creating the blog post, and path number two is pushing this blog post to social media after it's been completed. So, in other words, we need to filter this so that it only creates the blog post if you click the create button and it only posts it to social media if you click the social media button, right? So let's go ahead and do that. So I'm going to call the first path up top here that we created is "Create Blog Post," and essentially there's two criteria that we need: first of all, we need to make sure that it only changes or it only creates a blog post if column B is the column that the value changed in—like I don't want to change it if somebody changes column A or changes column C; it has to be column B—and I also want to make sure the value is set to true. So if you uncheck this, for example, it's not going to fire; it's only going to fire if you check it true. So those are the two values that I care about: first of all, the column start, right, has to be two—so one and two for column B—so this will equal to two, and the value—so whatever is being changed—once again, if I went and typed this, that would be the value; if I change this to false, that would be the value; if I changed to true, that the value would not be true. I want to make sure the value is true, and you can also change this to case-insensitive, just in case, you know, for whatever reason, "true" is not capitalized.
Okay, sweet. So that's for path one, and then for path two, same kind of deal; we're going to publish to social media, and effectively in this what we want to do here is we want to do the same thing where we make sure the column start is now column three, and the value once again is also true, right? So we're going to do case-insensitive here, and we're going to make sure that this equals to true. Okay, perfect. So now we're on to the second part where we're going to generate these blog or these social media posts from our for our blog, right? So what I want to do here is firstly I want to create an image for this blog post. Now there's a couple ways you can do this. This—right—personally what I have done here is I have this workaround where I grab the first image of the blog post, which is like the main header image, and I use this just for the brevity of this video here. I'm going to generate an image using AI and publish it there. If you guys are interested in how to do this, then I can link it in the description down below as well. Now, with that being said, I'm going to use OpenAI to generate this AI image. There's a lot of different models you can use; you can use Leonardo, you can use OpenAI, you can use tons of different things, but just the easiest one to probably get started with is, once again, ChatGPT. So we'll type in "image," and we'll generate an image here, right? The image is going to be on the model DALL-E 3, and the prompt is going to say—is going to be—"Please generate an image for this blog post," oops, "post," and then the row values will be column A here. Okay, first things first, we're going to generate an image for that particular blog post. Okay, awesome. And then what I also want to do is I want to generate a better title for that blog post as well—something that's going to be a bit better than just the keyword here, which—which is "Cost of a Plumbing; Cost of Plumbing a New House." So we'll come in here, and we'll create a title as the next one, and for this we'll just use ChatGPT-4 mini, which is the same model as before. We can just type in 300 max tokens, and the message is going to be a user message: "Please create a title, a short title, for this blog post," and we'll go ahead, and we'll paste that in here. Sweet. Okay, so now we've gone ahead and created the title as well. Just one other thing: we want to have an assistant message down here saying, "Please don't add in any intros or outros," that way you're not going to get a title going to social media being like, "Sure, no problem; here's your title," and then it's—it goes into the title; that would be super embarrassing. Okay, awesome. And from here on out, what we're going to do is publish this to multiple different social media platforms. Now I'm just going to go over a couple; I'm not going to go over all of them, but I will include a link to this particular workflow as well, so in case you do want to copy and paste for everything you can. I'm just going to go through a couple, and then in the blueprints for free you'll have access to everything else. So the ones I'm going to do are just Facebook and Instagram for this, and we'll start with the flow control, and there's going to be a router, and this router is going to go down two paths here. Okay, the first path is going to be for a Facebook post, and the second path is going to be for an Instagram post. Now we have the output of this blog post, right? You probably don't want to output this blog post completely into Facebook or Instagram, right? Obviously, it's not going to look ideal, so we need to reformat the data in a way that is going to allow you to create a good post on Facebook and Instagram, and especially things like Twitter, for example; you only have a certain character limit, so you need to make it as confined to that—to the amount of space that you have. So in order to do this, we're going to open up ChatGPT one more time, and we're going to create another completion; we're going to once again use the same model here, and the max tokens I'll just put is 1000, and in this instance we want to create that Facebook post. So I'm just going to copy it in from here just to make sure that we go a bit faster here, but in my user message, the message content will be, "As a digital marketing specialist"—so you're providing a role to chat, telling it who it is—"you need to create a post about the following article," and then we'll just paste the title here that we just created. "Ensure the content is very appealing and straight to the point; also make it relatively short; suggest relevant hashtags; suggest relevant hashtags; it should be all—it should also always contain the hashtag whatever maybe that you want," but I'm just going to actually get rid of this, and I'm just going to say, "Here is a summary of the article," and we can go ahead and grab the summary of the article here, right? We actually are going to need to do one thing here to get this to work properly because we don't have access to the summary of the article because it's in Google Docs; we either have to find the Google Doc or we'd have to paste the blog post back in here. So I'm just going to go ahead, and I'm going to type "blog post" here, and when we create the blog post, we're going to paste it back into this particular row here so that now we have that blog post accessible so that when somebody—when you click "Create Social Media Post," then we have access to it here in all of these modules as well. Unfortunately, in Make.com, when you have paths here, you don't have access to these paths, and even if you did, these are being run at separate times anyway, so you wouldn't have access to this information. So we'll go ahead, and we'll choose Google Sheets back up top here, and we're going to update a row, right? The particular row we need to update is the same row that started this workflow, so just make sure to choose the right connection to your account here, and we need to select this spreadsheet manually, so you can select from all, and we need a spreadsheet ID; that spreadsheet ID is actually going to be located in the URL up top here, right? So we'll copy that URL and we'll paste into the spreadsheet ID here. Sweet. And you see how it says "map" here? Just make sure to remove that, and you can choose the spreadsheet name, which by default is "Spreadsheet 1"; this is like the tab on the spreadsheet, right? So you can add as many tabs you want down here, but just by default there's only one available. Yeah.
Okay, cool. So we have the spreadsheet name, and the row number is just what we got from the initial triggering of this workflow, right? Because remember how with these workflows you have access to everything in that row, including the row number as well. So all we have to do is map the row number from the first module here, which is the row start, which is two. Awesome. And the blog post in column D is going to be the result that we got in module 5; module 5 is the tone of voice or the last AI actor that we ran to generate that blog post, right? So this will—if we look at the results here—this will contain the whole blog post, right? Now let's just go ahead and say that we had already published this, right? And I'm just going to paste this in here just to speed up some time; this is kind of what it would look like coming in here. Okay, cool. And we can just essentially access that now by saying, "Here is a summary of the article," and we'll now have access to that in row D of this spreadsheet because essentially the blog post, once it's been created, right, and once we push it to this Google Docs module here and we spit it out here, it's also going to be pushed and updated into the exact same spreadsheet row that we had here. So when we trigger a blog post for the keyword "Cost of Plumbing a New House," it's going to publish that blog post straight within the spreadsheet that we have here, and then we're going to essentially take that value in column D and we're going to pass it into this module here so that we can summarize it, but just make sure that—making sure to turn it into a Facebook post, right? And then the next thing is is we actually want to publish that to Facebook, right? So we'll choose Facebook Pages, and we'll create a photo post with photos. Okay, and just make sure to choose the right connection, and I'm just going to choose—I don't know—whatever; it doesn't matter here. And the photo—if you click "photos"—it's going to automatically pull in the photo from ChatGPT, right? So this photo is going to automatically be placed here. Now just a couple things with this photo: we need to make sure that the output value is the right type. So if we type—if we hit the "Show Advanced Settings" here and we go scroll down, the response format for this photo is URL, but you can't upload the URL into Facebook, so we need to have it as an image file, and now it's going to have like binary code or whatever that can be uploaded into into Facebook. You can also choose a URL; it really just tens. Let's actually take a look and see what Instagram has here. In Instagram, they have a URL option, so we'll just go ahead, and we'll choose "Download Photo from a URL," and then we're going to pass in this URL from here, right? So we're going to have to run this one time to get the results to be able to pass it in here because the URL is not currently available. So let's go ahead and do that. If modules haven't been run before, you're not going to be able to access the data of that run, so we'll just run this one time just to make sure we actually have access to this URL. So we'll change the response format back to URL; we'll right-click over this and run this module once and add row values here. Essentially, we'll just say "Plumbing" for column A—it's pulling in, you know, column A here what it wants to generate the picture about—and we'll just put "Plumbing" here; we'll generate the image, and then we should be able to receive the link—link or the URL—to paste into Facebook and paste into Instagram as well after this has been completed.
Okay, sweet. So in the data section, you can see the URL here. So if we just paste this in, this is kind of the image that it's generated for us, right? So in Facebook Pages, we'll just change this to "Download a Photo from a URL," and we need to make sure that we grab the right URL, and you can see when I hover over this, this kind of starts shimmering over here, so you know that it's the right one, and we just pass in that URL here, and the caption we can pass in from—and you can see this shimmering as well—the results from the Facebook post we just generated, right? So that is how we can go ahead and create a Facebook post. Now what we have to do is do the same thing, but instead this time we're going to do it for Instagram. So I'll clone this; going to delete this here, and we're going to do the same thing, but now just for Instagram. Just to speed up some time here, I'm going to copy in my Instagram prompt; both of the—everything's going to be in the description down below for you guys to use, and we just need to add a couple more things in here: "As a digital marketing specialist, create an Instagram post around the following article," and we're going to paste in that particular title here, which will be here. Okay, sweet. And then, "Here is a summary of the article," and we can just paste in—once again, same kind of deal—above column D, which will be right here. Let's just make sure this worked as well. Okay, sweet, awesome. So that's essentially it, and now we're going to generate that Instagram caption, and we can paste this into Instagram as well. So in Instagram for Business—you need to have a business account for this to work—create a photo post, and choose the page; the URL is going to be the exact same. So in data, we have the URL of the photo from the module we created the photo from, and then the caption is going to be the last result here that we just generated—that Instagram caption from—we can click "Okay," and essentially when we run this now, what's going to happen is one of two things: when we create—when we click "Create" here—it will go down the path of creating a blog…
Post and then, when we click the social media post right, it's going to gener—it's going to turn that blog post into social media posts for Facebook, Instagram. I, I will stop there; however, I will include in the blueprints all of the other social media platforms that you can post this on. And I think there's value in posting it everywhere, especially if you just spent the time generating a high-quality blog post, went through the process of optimizing it, publishing it—all of that kind of stuff—then you definitely want to post it to as many platforms as possible.
Once again, this is just like a rough draft on how you can go about the process of automating the whole content pipeline. If you guys wanted to, this whole process of generating a blog post could be fully automated. Like, that's what I'm doing with my business. Here is: I'm essentially going to uh automate the whole process here, and I will make a video about this. It's just that this is kind of hyper-specific to my use case because I'm using Elementor. And even if you're not using Elementor, or even if you are using Elementor, uh, it—I'm going into the code and changing things specifically for my business use case, so it wouldn't really necessarily be applicable to other people. But I will make a blog post trying to outline as much of this as possible. So use this as a rough case scenario; build on top of this to make sure the specifications are right for you.
This helped grow my online presence tremendously within a year—uh, from like, I don't know, once again, like a couple of clicks every single day to thousands of clicks every single day. And this is just one of many of the websites that I've done using this strategy. And I hope this really helps, guys. If it did, make sure to subscribe to the channel if you're new; give me a thumbs up if you like this video; and yeah, just thank you so much. I hope you have a wonderful day, and I look forward to seeing you guys in the next video. Thanks, and bye-bye.