How I Build a Custom AI Blog Writer | Automate SEO Content…

1



In this video I show you how to automate your SEO content creation and save countless hours on writing high-quality blog posts.

Ready to captivate your audience? Let me craft your next article or post!

✔️Here i show you a top rated social service: Click Here.

✔️And Here i show you more writers.

hi and welcome to this video tutorial where I’m going to show you how you can create your own AI powered content writer that will help you automate the majority of your blog writing tasks and this is going to be directly inside of Google Sheets making it really easy for you to build yourself but the idea here is to create your own content copywriter powered by chat GPT that you can make your own so that it fits your own requirements I’m going to show you how this content copywriter work works that’s powered by GPT and automates the majority of the writing stuff for you so then you can decide if it’s for you and then I’m going to demonstrate how I built it using gp01 preview o1 mini N4 to help me code everything although I don’t understand a single thing about coding this is a great tool to help you write the way that you want to if you find that all the AI writers don’t quite do the thing that you want to do now you can just create your own one if you don’t know me my name is Nico I’m an AI powered SEO specialist and I run an online community called the AI ranking Hub where we help people to maximize search engine optimization with the help of artificial intelligent tools like the one that we’re building at the moment if you want to learn how to do SEO with AI and learn a little bit of automation along the way it’s a great place for you to start that’s completely free if you want to check that out I’ll leave a link to that in a video description below but let’s get started right away with this one so you can see that I’ve already kind of done the first line here but I want to go through everything with you so you can see it in real life in action so in the first cell we’re going to put the keyword or the question that we want to write about previously we did how to train a dog let’s say how to train a cat now how to train a cat for example um we can select here the style of log whether it’s going to be a how-to informational opinion piece I’m just going to do uh a how-to to change it and the additional info this is where you place maybe who you’re writing for your audience so I’m just going to copy this and I’m going to say we’re writing for cat owners in Melbourne approval status that’s in case you’re working with a team member and they want to approve this so that’s everything that you pretty much only have to do these first four components and now you can see at the top here I’ve got a little SEO tool menu which you’re not going to have on your Google Sheets by default and this comes as a result of creating all of this code which I’ll show you how to do in a second you’ll have access to all of this by the way that’ll be inside the community the free community for you if I press the SEO tools I’ve got a bunch of menus that I’ve created and I’m going to generate blog outline and what this is doing is reading the additional information the how-to stuff and the keyword and formulating it into a really nice content outline which then I’ll be able to amend to fit my needs if I don’t like it and see it’s come up here on this uh sheet here uh we can make this a little bit smaller but I’m going to show you that okay I can double click it and then I can see the entire thing and it’s a deta understanding this allows you to kind of make sure that you’re happy with it you can do a little bit of research you can add some secondary keywords within the menus and kind of make it your own but let’s say I’m happy with the outline and then uh what I want to do is do some additional research for some internal links so some pages within my website that are already exist that I want to link throughout the blog which is a really good thing you want for search engine optimization some internal linking and then some external links meaning that you want to reference the source where you’re getting your information from that’s also another really good thing for SEO so for this example I’m going to pretend this is my internal link let’s say I’m writing for this website going to go back to my auto blogger and I’m going to put the internal link and then I found an external link as well that I would like to reference and it’s a really high quality one because it’s from the British psychology Society meaning that it’s a fairly trustworthy link perfect now I’ve kind of got all my components to write the full blog and all I need to do is go back to my SEO tools and then generate full blog outline this is doing a couple of cool things this is creating a Google drive folder and then it’s creating a Google Docs that new Google doc will go in that folder so everything’s kept nice and tidy and then the whole blog that’s that’s being written is going to go on that Google doc file keeping things very organized and then you can send that Google file if you want to someone to read and the and anything else that you want to and it just allows you to keep things a lot more organized and I don’t want to have the whole blog just here and you can see if everything’s been done correctly the blog post has been generated and stored in the Google Doc successfully I’m going to go okay and in a second you’ll see this little link perfect our blog post is ready just like that and now I can read the whole blog post here I’ve said that I want the parameters to be in HTML that’s why it’s like this but you can change that within the code structure and I’ll show you how to do that later on so let’s see say I want to see the how this is going to look and I’ll just copy it into a HTML preview uh it’s even got the meta description perfect how to train a cat introduction uh and it’s backlinking there to the links that we to it to backlink so that’s working fantastic um and then some Advanced trainings I’ve even got an FAQ section and I’ve got another backlink as well so it kind of did everything that we wanted it to do pretty cool now a Blog wouldn’t be much of a Blog without any images so we’re going to ask it to create some prompts for the images which we will then provide to Deli CU I want to make sure that I’m happy with the prompts that it creates for those images so I’m going to say generate image prompts it’ll they’ll come up here in a little while and now I’ve got two image prompts one that says a playful tabby cat eag response to his owner’s command y yada and then the other one in a cozy room a cat owner uses a clicker to whatever that is and then the rest of the actual prompt we’re going to if you want to amend it you can do so I’m going to generate the images here and that’s calling Del and it’s making Del use the first prompt for the first image and the second prompt for the second image you’ll see in a second that we’ll get a success message and the images will be much like the ones up here just in the next box here you should have a success message saying image generated and inserted successfully and we give that a while and there you go there is the first image there is the second image pretty good images if I don’t say myself um you can use flux you can use other image generators but for the example of this tutorial I wanted to I wanted to keep things nice and simple that way we’re only using one API key from open Ai and that’s it great now one another thing that often gets missed out that’s the alt tags for the images you’re going to generate the alt tags and that’s going to look at each one of the descriptions the images and create an ALT tag for each one of the images which will then you insert into the back of your website builder whatever that is WordPress Wix or whatever when you upload that image you also attach the corresponding alt tag to that another really good thing for image SEO that always gets missed out and finally I want my meta description I’m going to click the last button that’s going to read all of the blog structure and create a really high quality meta description that’s between 140 and 150 characters in length with a clear and concise call to action which I’ve got here perfect so now I’ve got a full blog I’ve got uh the outline I’ve got the full blog link that I can go to here I’ve got my images that I can download I’ve got my ALT tags for the images and I’ve Got The Meta description for the blog pretty cool if I don’t say so myself and that didn’t take me too long to actually build this out now this will be accessible all for free with ins inside the free community in our paid Community we’ve got a much more advanced version which uh in incorporates perplexity search which is an AI powered search engine so that it does some preliminary research on the topic and then also integrates that within the content but I’ll keep it nice and simple for this one so how did I that’s the first section I hope you’re with me still how did I build this because I don’t know anything about coding but it works really well and I’m and this kind of works with this code in the backend I use gbt o preview 01 mini and 40 for this whole thing and I know that sounds complicated but I want to show you the prompting structure that I’ve used for this and it works a little bit like this where we use the first first smartest model o1 preview first then 01 mini and then 40 because you can change between the models in the same conversation which is really handy let’s break down this further and then even further so you understand this prompting structure that has worked really well for me in creating more complicated projects like the AI content copywriter the first one is we’re going to use 01 preview as the expert that sets the whole framework and identifies the gaps and creates a comprehensive stepbystep guide of the task so that’s the kind of the master architect let’s call it of the whole project and we do we only want to use we want to use that very sparingly because we only get 50 messages a week with that then we use gp1 mini which focuses on the most complex task and Technical aspects like coding the difficult bits problem solving and then um and we want to leverage this because we also get 50 messages a day for this one so we can use this a little bit more and then we have gbt 40 which is kind of the reliable Workhorse I haven’t run out of daily messages with that and it’s still quite good particularly if we already got the instructions from the earlier smarter models so in detail how does this work well we use at the top of the final of the prompting we use 401 as the overarching expert couple of really important things you need to Define you need to make sure that it defines the parameters of the entire conversation identifying the gaps and components that may be overlooked in regular approaches it sets up the framework for the project so what does a prompt look like in this example so the example prompt here and you get access to this as well create 401 you’re using 401 preview and you asking create an expert level overview for enter the task in hand that you want to create right identify all essential components and challenges and step needed to complete it please break it down into the process into a detailed step by step guide because we want to then give it to 01 mini and O 40 ensuring including hidden aspects or potential gaps in the logic that’s really important highlight the areas where specialized attention will be required and provide guidance for the tools resources methods necessary to address this this prompt should include the instructions for proceeding the next steps to efficiently and then we go to the next one the middle funnel which is gpt1 mini that’ll handle the more complex task of actually doing everything doing the coding and an example prompt can be based on the expert outlines provided above create the code or handle complex tasks identified as critical um that’s doing the majority of the basic work for you and then for o you use as you would regularly code this aspect here the instructions for that I’ll leave links to this all below so how does this work so let’s test this out let’s try and re recreate this for us I’ve got the initial prompt and you do need to think about this so you maximize the chats that you’re having with 01 preview this is the prompt that’s going to ideally start us on the right path to create our AI content copy generator and automator here can you write a Google apps script for me that integrates open their eyes to generate SEO optimized content and images based on prompts I want the script to have the following features a function that sends prompts to open AI GPT models um and return to responses is should handle SEO Focus Generations uh I want Del as well included the script should manage Google Drive folders it should work within Google Sheets uh I’ll have a custom menu in Google Sheets and everything else right so let’s preview that now I’m going to go to chat GPT I’m going to select the right model so for the first funnel of this prompting structure I’m going to use o1 preview and hit enter it’ll take a little while it should really think about the action which is what you want and then if we and then later down the track we’re going to change it to the different models and it’s already starting to give me a bit of the code and that’s quite all right but now because I’ve got the main functionality of it and I don’t want to waste too many calls with o1 preview I can change to 01 mini and I can start having a back and forth conversation with it where do you put this script if you want to generate your own tool within Google Sheets well you’re going to copy the code for example you’re going to go to a brand new Google sheet we’re going to go to extensions and we’re going to go to appscript you all will have that choice of app script there and what we need to do is delete any little bit of code that’s here by default paste it there we want to save it and then we want to save the name for example SEO writer and go rename we want to go back to our Google sheet and if you hit the refresh button you’ll see that the other tab is now gone but I’ve got this little menu item now create blog outline generate full blog post create image H tag and stuff for that now you can go back and forth and ask it to improve things or to change a couple of things or parameters it’s really up to you what I want to do though is let’s go and improve on this one live together so let’s say I wanted to add a a Facebook post related to the blog post that I’ve just created well I’m going to put in here for example Facebook post and you can do whatever you want here if you need to generate an email from the blog post or a message to your CEO saying here’s an example of the blog post whatever that is right the idea is to make this your own we’re going to go to Facebook post here and then we’re going to grab the code which you have access to now because you’ll be able to copy this into your own Google sheet we’re going to go to extensions and we’re going to go to appscript and this is the code that you can have a look at in the back end of the content copywriter you can even probably sell this if you wanted to but I’m going to give this to a new conversation for uh GPT I’m going to use for I’m going to use o1 mini I think this is more than capable to do the majority of the tasks that we need to and I’m going to tell it to understand the app script but I want to add another function and that is on column n to create a Facebook post about the blog post so let’s see if we can do that together and update it and ideally make that happen so I’ve said here’s an appscript from Google sheet that I’ve created I want you to understand the functionalities of the appscript then I want you to add other additional function I would like to generate a Facebook post about the blog post in column n that I can use to post to Facebook and I want you here to understand that you’ve got the prompt now you’ve got the code you can amend this to meet your parameters if you don’t like the tone of the output that it’s generating you can tell it I want to write it in this tone please change the code accordingly and it’ll do that for you CU it’ll understand all of the components perfect and now already o1 has is telling me the objective what it implemented um it generated a new trigger and it should have everything I’m going to copy the code I’m going to go back to my app script I’m going to copy the code that 01 mini gave me I’m going to go back to the app script of my Google sheet I’m going to delete it so I’ve saved the code that’s updated from 01 mini I’m going to go back to my app script I’m going to my Google sheet sorry I’m going to refresh it and hopefully I’ll have a little menu up here fantastic I’m going to go to the Facebook post I see the new item there generate Facebook post and see if it’s done everything correctly Facebook inserted in column o all right well we wanted it in N but that’s all right we can just tell it now to fix that and let’s see what the Facebook post looks like ready to transform the industry yeah perfect now if I don’t like the output of that Facebook post I can tell it to format it in a way that I want to but I’ve just amended this free AI content copywriter tool that is ready and set for you to go and you can make it your own as a couple of other things that you need to know this works with the open with an API key from open AI if you don’t know how to do that how to get it I’ll leave a link to the video description in the video description below on a quick video tutorial on how to get your open AI API key this isn’t technically free you do need to pay for API calls but it is considerably cheaper than even the subscription of $20 a month you probably won’t use $20 worth of API credits a month even if you’re creating probably hundreds of blogs per month so it’s a much cheaper alternative when you copy this sheet from our free community where it’ll be available there for you you’ll be asked to enter your open AI key in a certain parameters let’s try that right away so I’m going to I’m going to click the link that I’ll provide where you can copy the Google sheet automatically and it’s going to give you this diff uh it’s going to give you these it’s going to give you this message copy document appscript file functionality will also be copied yes you need to copy the whole thing you also need to allow access that’s going to allow the images to come through so you need to allow that and then the first time that you use this you need to give it a second and you’ll see another functionality come up here that’s the SEO tools right if I go to test it out the first time and generate the blog outline it’s going to ask me a couple of things it’s going to say do you want to uh authorize this app because it’s not recognized it’s a new one you need to authorize it it’s going to ask you a bunch of questions here as it does you need to just click everything through allow and then once that’s all allowed you need to do it one more time generate blog outline and here it’s going to ask for your API key once you’ve copied the document you need to allow access here that’s going to allow the images to come through and then the first time that you try this I’m just going to delete a couple of things here you’re going to require the authorization you need to go through all the components because this is an app that Google hasn’t seen before and they don’t recognize it you just need to make sure that you’re happy with providing it access and I’m going to again generate uh the blog outline and for you it’ll say set your AP your open AI key not your perplexity key this is the premium one but it’s going to say set your API key you’re going to set it there save it and then you’re good to go next time you go back to this document it’s going to be useable again and that’s it now you have your own custom AI powered content copywriter that’s going to help you automate the majority of your content all the all the things the assets the prompts that we’ve talked about will be available inside the free community and I’ll leave a link to that below the idea here by the way is to use this as a template this blog that it creates Straight Out of the Box shouldn’t just be updated upload it to your website and publish right away it’s for you to for it to write 90% of it but then you need to add your own experience to the blog and you need to add your two cents there that’s what’s going to differentiate this blog from other AI generated fluff here you need to put your input take the time to do that but the idea here is to use this tool as an extension of yourself you can start prompting it to write like you a little bit more within the app script itself I’ve shown you how you can amend that with gp01 mini and now instead of having to go back and forth through gpte or using another AI tool that you don’t really like how it creates the blog you can change this to suit your needs that’s the beautiful thing about this I hope you like this tutorial if you found a lot of value from it all I ask is that you subscribe and give this video a like and if you want to learn more about how to maximize AI tools for SEO I suggest you join our free community again I’ll leave a link in the video description below thanks I’ll see you in the next one

Need compelling content? Get in touch for expertly written articles and posts:
✔️Here i show you a top rated social service: Click Here.

✔️More writers.

Un comentario en «How I Build a Custom AI Blog Writer | Automate SEO Content…»

  1. Unlock Endless Freelance Possibilities

    Hi,

    Have you ever wondered how easy it could be to find the perfect talent for your projects?

    Whether it’s design, content creation, or tech support, This Platform connects you with professionals ready to help Freelancers.

    Curious to see how it works?

    It’s quick, simple, and designed to meet your needs.

    Follow this secure link and explore the possibilities: https://rb.gy/n6nxd1

    Looking forward to hearing your thoughts!

    Best regards,
    Alex Carter
    Creative Advisor

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Entrada siguiente

Gradient Letter L Logo Design in Illustrator|Adobe...

Sáb Ene 11 , 2025
Gradient Letter L Logo Design in Illustrator | Adobe Illustrator CC 2023 #shots #youtubeshorts #viral #illustrator #logo #tutorial … Pida el logo perfecto a precio bajo; para su negocio, empresa, o para revenderlas en otros sitios que pagan el servicio a precios más caros, ganando la diferencia: ✔️Clic aquí para […]

Puede que te guste