Automate Blog Content Ideas — Step-by-Step Guide & Transcript

[00:00] so i post blogs regularly and generating the content idea every day is a big pain point for this task page is this automation what this automation is going to do let me just show you

[00:12] that every month first seventh 14th 21st and 27th these are the days of the month at these days open here is going to generate seven days blog content and automatically that content will be

[00:25] added in my spreadsheet with the date, day, blog title, salary keywords, search intent and also the blog brief. And in this video, I will show you how you can also create a weekly blog

[00:37] calendar for yourself using public connect and open AI. For that you just have to open the workflow builder of public connect if you are an existing user like me. But if you are a new user, you just have to log in inside public connect, there are free trials so just avail it

[00:52] and come on your workflow builder for this we will go select it as add trigger button and go select schedule for the event selected as schedule workflow click on this connect how often do you want to run your workflow so you can run it weekly you can go on this days of the week and run it on

[01:07] every sunday too or if you want you can go on dates of the month and select the dates of the month at which you want to run your workflow so at the specific dates of selected the same for the time i am just going to keep it as 3 pm and click on the save button it totally depends upon you how

[01:24] much you want to run this workflow then click on the card action selected as open ui for the event selected as charge equity click on this connect go on this add a new connection it is going to ask you for the token to get this token bonus open your api key payment in the top right corner

[01:40] your windows tv option off this create your secret key button go on this create your key and then simply paste the key right over here in your workflow then click on the save and your open air will be connected with Patrick and I have already created this connection so I just going to go on the select existing connection and then save now choose the AI model of your choice I need to use U2D5 okay so let me just select it

[02:02] right over here now let me just move on further it is in prompt I'm just going to simply copy the prompt from my previous workflow as you can see that this is my prompt and over here I've mentioned all the business details industrial details

[02:15] business focus and the content goal the target audience and the rest of the details if you also want this prompt just comment prompt and i'll just share this prompt with you and ask it to convert

[02:27] a prompt like this for your own business too okay and then once you get the prompt just paste the prompt right over here so as you can see this is my prompt i have simply entered it now let me just correct the formatting of this prompt and then i'm just going to move on folder and click on the save

[02:43] and send test request button once we're going to click on the same and send test request button it is going to take few seconds and then it is going to generate me seven days of blog content in this prompt i have clearly mentioned that give me the details in json format which is in separate fields

[03:01] and i've requested for the six fields which is date daily blog title primary keyword search intent blog brief and meta description like this i want it in separate fields as you can see the

[03:13] previous response like this so that you can map it further i'll just let you know what is mapping further in this video but before that you just have to wait till it is going to generate us all the details over here it is just going to take a minute or so so please be patient till then i

[03:30] will just let you know that if you like fably connect you can move on further and purchase the subscription plan of public connect using my evening discount coupon code RITINVITAY it can get you already have it discount or the subscription plan of public connect apart from that i will just let you know that i am going to use open air trust as example You can use Cloud Gemini or anything else too Totally depends upon you There is a CC response and in this response I have received everything

[03:56] The date, the date and the rest of the details one by one for multiple roles. Now let me just add it in my spreadsheet. So let's just close this and click on this add new action step. For the action applications, select it as Google Sheets.

[04:09] For the event, select it as add multiple roles and click on this connect. on this connect now just go on this add a new connection sign in with google select the gmail account with the help of which you want to build this connection pabli is going to ask you for

[04:21] some permission so click on this allow give pabli all the permissions it is asking for because your data is 100 safe and secure with us now we have to select this spreadsheet and we see it right over here in which we want to enter pdf then one by one enter ppt but over here you don't have to

[04:37] enter ppt or the manually by tab like this but instead we have to map it you might be wondering what is mapping so mapping is a method by babli which means inserting the data from the previous step and when you insert the data from the previous step automatically our data becomes

[04:52] dynamic and changes with every new response received in order to map this data what you have to do is you just have to put a slash then search for the data and map the data right over here in order to add multiple rows put a comma then put a slash then search for the data and

[05:08] map the data like this you have to be very particular that you map it at the perfect sequence like zero date one day two days three days four days five days six days so like this you have to make sure that you map it in the correct sequence like i map the day i'm just

[05:23] going to map the day also right over here we're going to do this one by one for everyone okay so first of all i'm just going to put a slash search for the day so this is day zero which is thursday let me just put a comma let me just search for the next day which is friday so one

[05:37] So one by one I am just going to map all the days right over here The third will be Saturday then it Sunday So one by one let me just map all the details yes it is going to take a bit of a time once but once this is done then you are

[05:51] good to go okay you just have to open your spreadsheet and every week monthly or you can say weekly calendar will be ready for you so i'm going to simply map the tuesday then we're going to go

[06:05] and map these then stay so yes pd's are completed like this you have to master blog title so one by one i'll just map everything and come back as you can see i've mapped everything right over here then you just have to click on the same and send a request button we have received the positive

[06:20] response but the details are added in this spreadsheet and yes once this automation is created then you just have to sit back and relax because every week this automation is going to run as per the schedule. OpenAI is going to generate the content work for seven days and it is going

[06:36] to be added in your spreadsheet. So your seven days content calendar is ready if you also daily generate blogs. You do not have to think about your new idea every day. Go and try this amazing automation yourself and by the time if you have any questions related to the video or the workflow

[06:51] you can directly comment on this video and for the reference I will just type the workflow URL and we will scan coupon code in the description box below do check it out see you in the next video with many more automation tips everyone thank you for watching so not only this but you

[07:06] can connect many more applications using public connect so now if you have any doubts related to pricing you can follow this link if you have any doubts or queries related to sales you can email

[07:19] us at sales at the rate tablet.com both this link and this email address is attached in the description box below you can check it out i suggest you connect and integrate your favorite

[07:32] applications today because right now we are offering a few trials of public connect