0:00 what's up everyone it's tin here your no
0:02 code AI automation expert and today
0:04 we're taking a look at this particular
0:07 workflow that basically uses your
0:10 YouTube video transcribes it and then
0:12 sends it to an AI agent that summarizes
0:15 everything writes a blog post for you
0:18 and then at the end sends it to
0:20 Wordpress creates a post in WordPress
0:23 ready to go so this is an entire
0:25 workflow it's a very easy workflow to
0:27 actually set up now this workflow and
0:30 other workflows can be found in our free
0:33 group so if you want to get even more
0:35 workflows done and if you can just go
0:38 and you know go into our group and then
0:40 import them right here from the file and
0:43 you can pretty much import any uh free
0:46 template that we have in our na10
0:49 community or in our school community so
0:52 let's break down exactly how you can
0:55 recreate this particular um this
0:58 particular workflow now let me show you
1:00 how it works now in Google sheet what we
1:03 have is we have an um a sheet that has
1:07 just my YouTube video URL as you can see
1:09 and this is my YouTube video from here
1:11 so this is my YouTube video I put it in
1:14 here and that's the first uh the first
1:17 part now the second part we have a code
1:20 which basically just uses a part of uh
1:24 this right here so it just uses the ID
1:27 of the video uh and then sends that ID
1:30 to an HTTP request which is basically a
1:34 request from this YouTube transcript
1:37 extractor so it basically extracts the
1:40 transcription and then from there what
1:42 we have is we have an AI agent that is
1:44 connected to an AI model open router
1:46 chat model which is a free AI model um
1:49 or actually directory of free AI models
1:52 and that AI agent actually wents in and
1:56 creates a blog post based on the
1:58 transcription uh formats it right here
2:01 uh for the WordPress and then sends it
2:02 to Wordpress so if we test the workflow
2:04 here uh you will see how it works so as
2:07 you can see it's pretty fast as well
2:09 this is the the longest part because the
2:11 AI agent actually needs to actually
2:13 create the blog post uh but as you can
2:16 see you will see it in a second right
2:18 now after the the AI agent is done it
2:22 will send it into a code code will
2:25 basically uh extract the title the slug
2:28 for the WordPress post and the content
2:31 and then it will send out as you can see
2:33 right here in WordPress so if we go into
2:36 our WordPress if we refresh this we'll
2:38 see that we have the the um title here
2:41 as you can see so we have the title if
2:44 we click on it this is how it looks like
2:47 right and obviously you know we have to
2:49 actually go here and format like bolt
2:51 some things and stuff like that but
2:53 overall this is very very uh good right
2:56 and then also as you can see we are
2:58 using some examples here like image
3:01 examples uh we can also go and use that
3:04 and paste it and it's not the blog is
3:06 not that long so what I would recommend
3:08 is if you want a longer blog use claw
3:12 3.7 Sonet uh but as you can see let me
3:15 actually go and let me break down
3:16 exactly how to do this so first thing
3:19 that we want to add is we want to add
3:21 Google Sheets trigger now this is a
3:23 trigger that will be triggered based on
3:25 the row added so make sure to go on
3:29 Google Sheets
3:30 add it as a trigger and make sure to
3:32 connect it so you want to connect it by
3:34 going to the pencil icon sign in with
3:36 Google and that will connect with your
3:39 Google Sheets trigger from there what
3:41 you want to do is you want to obviously
3:43 create Google Sheets something like this
3:45 where you have a video URL and you have
3:48 like a URL as an example uh again this
3:51 is my video but this could be your video
3:54 um make sure it's it's right here so
3:56 this is as you can see the name of it
3:59 and the sheet one because we're actually
4:01 using the sheet one here and once that
4:04 is done make sure it's row edit it
4:06 should look like this in the test output
4:09 when you just fetch test event it should
4:11 look like this so once you have this
4:14 what you will need to do is you will
4:15 need to create a code now obviously you
4:18 can pause the video here you can copy
4:20 this code right
4:22 here but again if you want all of these
4:25 codes can be found in our group along
4:27 with the template so you don't actually
4:29 have to go and you know watch everything
4:31 one by one but this basically code is uh
4:35 using the output so let me just show you
4:38 here it's using the video URL output and
4:41 it's just extracting this part which is
4:44 ID we need this ID to be able to
4:47 transcribe it with our transcription
4:50 software right here okay so that's the
4:52 second second code the third uh or
4:56 second node the third node is HTTP
4:59 request node now this is one of the most
5:00 important notes um so actually let me
5:03 show you how this works so you need to
5:05 go and you need to log in here into
5:08 YouTube
5:09 transcript. as you can see this is the
5:11 the link and you want to go to API and
5:14 as you can see here you will get every
5:16 single thing you need about the API
5:19 requests so how the HTTP uh node works
5:23 is we want to post we want to make sure
5:26 that the method is post because we want
5:28 to post based Bas on the video ID we
5:30 want to post the
5:31 transcription and we want to use this
5:34 endpoint URL and as you can see this is
5:36 the endpoint URL that we're using and as
5:39 you can see this is the parameter which
5:41 is post and then this is how you can
5:43 authorize your API token now as you can
5:47 see I put it here I put non send headers
5:51 and I have authorization basic and then
5:53 this is my API key now don't worry I
5:56 know this is publicly showing the API
5:58 key here I will actually change this API
6:01 key later on and make sure the content
6:03 type is application Json so with this
6:08 when you have all of these you can test
6:10 the step and by the way you can uh you
6:13 can create an account here on this uh
6:17 YouTube
6:18 transcript. and you can go to the
6:21 profile and as you can see here you have
6:23 your API key and you can revoke the
6:25 token any time and keep in mind you get
6:28 50 free transcriptions every single
6:31 month so every single month you can use
6:34 50 of your YouTube videos and turn them
6:36 into blog posts so once you once you
6:39 have that this is how it should look
6:41 like right here and then what you want
6:43 to do is you want to make sure you're
6:44 sending the body because the body will
6:46 actually structure the um the
6:49 transcription so it will know okay which
6:52 video I need to use to transcribe and as
6:55 you can see using Json and then this is
6:58 what you want to copy and inside of this
7:01 right here it should be your video ID as
7:05 you can see I drag and dropped it right
7:07 here inside of these brackets as you can
7:10 see so once you have this you should be
7:13 getting this type of output where you're
7:14 getting a lot of different things and
7:17 don't worry we just need the uh
7:19 transcription so we go and create an AI
7:22 agent node and with AI agent it needs to
7:24 be tools agent and we need to Define The
7:27 Prompt below but before we Define find
7:29 the prom below we want to add a chat
7:31 model now as I said here you can add a
7:33 chat model and you can go for claw 3.7
7:36 Sonet which is the best model out there
7:39 however if you want to go with free one
7:41 with free model I used open router chat
7:43 model and I basically went in and added
7:47 the API key here now in order to add the
7:50 API key you want to go to open router Ai
7:53 and you simply want to create an account
7:55 and go here to keys and then you just
7:58 create a key uh you name it however you
8:00 want you copy it and you can paste it in
8:03 here now from there uh you can obviously
8:06 go here and search for free and you will
8:09 get a lot of different AI models for
8:11 free that can use the the response and
8:14 that can summarize the response and make
8:16 it and turn it into a blog post right so
8:19 I'm using hugging face Zephyr 7B beta
8:23 but again this is just for an example as
8:25 I said if you want better output make
8:28 sure to opt in for claw 3.7 Sonet the
8:31 best model for for a blog post by far
8:34 now from there what I have here is a
8:36 prompt if you go to expression this is
8:39 the prompt I have so write a blog post
8:41 in first person from personal experience
8:43 sharing insights as someone with
8:45 experience in a given topic the tone
8:47 should be engaging easy to understand
8:49 eigh grade level and free from
8:51 unnecessary jargon of or overly complex
8:54 words use this transcription to create a
8:56 blog post and then I put the
8:58 transcription here here which is going
9:01 to be the transcript so we actually need
9:03 to scroll here and this is from the HTTP
9:06 request it's coming from the HTTP
9:09 request and if we scroll here below I
9:13 think it should be somewhere around here
9:17 so bear with me here
9:21 um so yeah you have transcript and
9:24 basically just drag the transcript right
9:26 here and then the title of the video can
9:28 be from your previous node which is let
9:32 me just go here let me move
9:35 this and actually the the the title of
9:38 the video is somewhere around here I
9:40 think uh uh yeah as you can see simple
9:42 text this is the title of the video you
9:44 drag it right here and then I also have
9:46 other you know uh part of the prompt so
9:49 again the better the prompt the better
9:50 the blog post will be this is how it
9:52 should look like on the right side you
9:54 test it out and you should be getting
9:56 output like this one and now what we
9:58 want to do for the ending is we want to
10:00 have another code that will take that
10:03 output and extract the title and extract
10:06 the slug and extract the content out of
10:08 that because in WordPress as you know
10:11 this is the slug this is the title and
10:13 this is the content so we actually want
10:16 to do that and we're doing that with
10:17 this specific um again code that again
10:21 can be found in our free group uh so
10:24 yeah if you want you can use that uh
10:27 code and as you can see we're getting
10:28 the title we're getting the slug and
10:30 content and by the way the slug needs to
10:32 be formatted in a really great way where
10:35 there are no double dashes because
10:37 Google hates double dashes so if you for
10:40 example have something like like this
10:43 right you want to be able to remove it
10:45 and this is what our Co code is doing so
10:48 uh that's the second thing now from
10:51 there it's simple we want to go and we
10:53 want to connect the WordPress here so
10:55 just go on the um add a WordPress and
10:58 you want to go here your username is
11:00 usually your email but it could be your
11:02 username but I'm using email in this
11:04 case because my account has email and
11:07 then WordPress URL is the WordPress URL
11:10 and the password is not actually your
11:12 WordPress password so you want to go in
11:14 WordPress you want to go to edit profile
11:17 and in edit profile what you want to do
11:19 is you want to scroll down until you see
11:22 this right here new application password
11:25 name type in na10 and then just hit add
11:28 new application password from there you
11:31 want to paste it here and it needs to
11:33 say connection tested successfully and
11:36 from there what you want to do is you
11:37 want to put resource to be post
11:40 operation to be create and then title is
11:43 Json title from here content is content
11:47 and then slug is Slug right here and it
11:49 should look like this and this is how it
11:52 should look like in the output and
11:54 that's pretty much it right that's how
11:55 you can create this AI automation
11:58 workflow uh again if you don't want to
12:00 bother with with all of these building
12:01 and stuff like that you can go into our
12:04 free community um I did mention it
12:07 couple of times but that's just because
12:09 we're pretty much putting all the
12:10 templates from our YouTube videos there
12:13 um just so it it's acting like one
12:16 database so uh yeah that's pretty much
12:19 it guys uh again you know for the
12:21 transcriptions you're using the YouTube
12:24 transcript for the um posting WordPress
12:28 and then AI agent and open router for
12:31 writing uh the uh post so that's pretty
12:34 much it it's a very simple workflow if
12:36 you have any comments anything specific
12:39 you want to know comment below or you
12:41 know go into our group and you can ask
12:43 any of our experts including me about
12:46 anything so uh yeah guys thank you guys
12:48 for watching and uh yeah we'll see you
12:50 in the next one
Chrome Extension