[00:02] found this really cool automation to uh to work with jet GPT and your WordPress so instead of making an endless document about how to do it I might as well just
[00:14] create this video um what I did is I'm using make.com I have a free account which has I think a thousand animations which you don't need
[00:26] necessarily and what I did is I made I made a Google and what I did is I made I made a Google Drive sheets with topics in it I'll show you in a little bit then it's sending that information to open AI with the API
[00:39] so not the chat GPT version but the actual open AI actual open AI API and then it uses the information of both the Excel sheet and the open AI generated text from jet GPT to create a
[00:54] WordPress article and one of the reasons why I'm doing this live is because I think we're going to see how many articles this thing is able to create within a certain amount of time time recording is seven past three
[01:08] so this is the Excel sheet that I created I that open I do this as well not using gpt4 because I didn't have access yet so I basically asked for a access yet so I basically asked for a list of keyword ideas for Litecoin
[01:23] um then I asked it to make titles create slugs which are basically you URL friendly titles or keywords and then a small excerpt which is up to 500 characters and I manually inserted the
[01:38] category and the featured image of my WordPress website which I'll get back to in a second then it feeds this automation basically the Excel sheet and I send it to open AI which I set to
[01:53] and I send it to open AI which I set to use the chat completion using GPT 3.5 turbo and the only prompt I gave is write an article about the title and the title is the one from the Excel sheet don't output the H1 title because I'll
[02:08] import that from the Excel sheet itself but do use HTML for the market formatting the reason why I use this is because the output of openai is just one flat like basically one piece of information
[02:22] so it's not possible for WordPress to extract the separate title from it so I rather use the Excel sheet and then we go to Wordpress itself which and then we go to Wordpress itself which needs a plugin from make.com as well
[02:36] where I use the title as title the content is from open AI then I also have the excerpt and the slug in this as well I manually set the
[02:48] category because it's one category only this time and I have the featured image ID which if you go to your WordPress setup and you go to media and you just hover over the image then on
[03:02] the bottom left you'll see the URL and it says post is 86 so the media ID is 86 which I put over here um
[03:14] actually already wrote a couple of Articles so I already did the technical analysis in the Bitcoin one so we have 17 till 56 left which is 40 articles so I'm going to set the Google Sheets
[03:29] so I'm going to set the Google Sheets limits of executions to 40. limits of executions to 40. and to make this more fun I'll put the output um published instead of draft
[03:43] just to see the first one so at the time of writing I have these two posts up light conference Bitcoin and Litecoin technical analysis and it should now do Litecoin price analysis going back to make press run once you
[03:59] can also do this automatically every 15 minutes just keep adding new title ideas and just scrapes the the Google Drive document it already got the information from the Excel sheet and now it's
[04:11] sending it to open AI where you can see the loading bar it also gives you like live updates on the bottom right
[04:28] I think this takes like a couple of seconds not that long actually if we refresh this now Litecoin price analysis
[04:43] it's in the right category it has the featured image which is set for to be the same for each of the Litecoin articles written by me articles written by me April 29 it got the HTML formatting H2S
[04:56] and h3s and that's it basically and it got the excerpt this is the excerpt for the article so it's now working on the second article and it will keep doing so that's number
[05:10] two and it will do so until it's finished with all 40 articles which I think should take about 30 minutes um it's now 11.3 so update you in a bit so it's now about 10 minutes later and I
[05:26] ran into a tiny problem which was basically that the automation was forced to time out after 10 minutes one single run so instead of using a lower number
[05:42] run so instead of using a lower number lower limit and every couple minutes I did all of them in one run which eventually led to a timeout from open eye even though it was working perfectly if we're looking at the amount
[05:57] of articles that are published now I had three published before this and we can now see that I have 21 published and if you look at the site map
[06:09] we can see that it basically did about two articles per minute which is insane and all of them look like this so with the featured image and with the correct category with the excerpt with
[06:25] correct category with the excerpt with the HTML and one thing that I had forgot to include in this specific run is that it can also use internal linking which would be a great addition to this um which you can probably do based on
[06:41] text which I didn't include this time lot of text and Google has a bit of an issue with indexing those Stacks so at the time of creating this Excel sheet it didn't make sense to me to include
[06:56] text but you might be able to use them to do interlinking faster so that might be a nice iteration it's really easy to set up as well you just go to Wordpress you select text and then if you have them in the Excel sheet you
[07:09] can easily just insert the text based on the mapping which you do here I'm going to include whatever you want so that's it for now um I'll do the other ones later this was just a demo case the website is blank
[07:24] other than these articles now um I hope you learned something I think this is really really powerful if you use it wisely don't spend your website with articles but you could potentially also plan them in using the um
[07:38] time scheduler so instead of doing them as published you can also set them as scheduled which means that like in the future that you can publish them on a certain date
[07:51] your Excel sheet so that like every other day you publish an article or like two or three a day I'm not really sure what the threshold would be for SEO but uh I think doing 40 in one day might be a bit Overkill
[08:06] um but who knows with Google right so uh I hope you learned something and see you I hope you learned something and see you next time