0:00
hello everyone my name is jannis and in today's video I want to show you how you can create AI generated PowerPoint
0:08
presentations for any given keyword or for any given URL uh by the way our channel has grow
0:16
to more than 500 subscribers so thank you all who have subscribed um to make
0:22
it more interesting if there are specific automations that you are interested in
0:29
please leave a comment and I will check them and maybe prepare a video uh to
0:35
show you how you can make this automation okay so this is the automation that uh runs from a web hook
0:45
basically the web Hook is integrated in my
0:50
spreadsheet uh once I click this execute um
0:55
checkbox it starts this automation um it updates the row uh
1:02
where I click the checkbox to status
1:07
uh presentations being done uh then there are two Roots so one
1:14
root is if I want to create a PowerPoint presentation from a keyword and the
1:22
second rout is if I want to create a PowerPoint presentation about certain web
1:28
page and then I'm using an cool service called slid speake they have an
1:37
API and with this API I AI generates a presentation from my given
1:46
text or URL uh they have many pre-build themes
1:52
for the presentations as well as you can create your own custom
1:57
templates uh I personally use these ones so next when Once the template is
2:06
generated uh sorry once the presentation is generated it's uploaded to my Google
2:15
Drive I I get a link for this presentation and then I publish the link
2:20
in my spreadsheet so this spreadsheet is not a simple spreadsheet so I have
2:25
created a script so whenever I type in here something for
2:31
example um morning routine I select how many pages I want
2:39
in my presentation let's say five and I
2:45
set the template name so basically one of these can be used so for example I'm
2:52
going to choose Iris uh paste it
2:57
here I'm going to type it down so once I enter all the details a
3:05
checkbox appears so this is done by a script which I will share with
3:10
you and the next step I need to click on
3:18
on so now I'm going to click run once I'm going to wait for new data and I'm
3:25
going to click execute and this should start the scenario for me as you can see the
3:32
status has changed to creating presentation and it has gone through
3:38
this route because I gave only a certain keyword not a URL of a certain
3:45
website so basically what this does this makes the request to slid speak uh there's a timer in the middle I
3:53
have set it for 60 seconds uh and the next module should retrieve the present
4:01
so one while this is working I will explain the bottom one so if I enter a
4:08
URL in here let's say I will give uh one from my
4:14
website uh it's boot destinations and I'm going to give this
4:20
URL here uh I'm going to set it to five and I'm going to use theault
4:31
template so once this is finished I will run the next one to show you how it works with a URL so basically it's very
4:40
similar to the upper part except I access the URL I get the HTML content
4:46
from it then I pass this HTML content to CH GPT to remove all the
4:52
unnecessary uh details from it and to make it Json ready and then again I make
4:58
the same request to generate the the PowerPoint presentation based on
5:05
my page so let's check how what what did we
5:11
get so this is the morning routine as you can see it provides images it
5:18
provides the table of content uh this one this image is not the perfect one but anyway he gives all
5:25
the text here it gives keys to uh key steps in the
5:31
morning he gives us benefits of morning
5:37
routine and statistics and this is just all done from uh one keyword morning
5:44
routine okay so let's run this once so now it went through this rout it
5:52
accessed the page got HTML content from it now CH GPT is preparing the Json for
5:59
the API I call and once that's done it will be sent to
6:05
um slid speak so in this video I'm going to show you how you can build this from
6:12
scratch also I will have a link for the
6:18
slid speak in the description and I also will have a link for the complete um uh
6:24
blueprint of this Automation in the in the description
6:30
as well as I will give you the script to create a template uh to
6:38
create a spreadsheet like this and we're going to also build it um while I'm
6:44
filming this video so now the timer starts um it
6:50
should be finished uh within 60 seconds so basically what your GPD gives
6:58
it gives all the content from uh my uh
7:04
post and using this content uh slid speak generate uh
7:13
presentation yeah so uh by the way if you want to know how to
7:20
set up Google Drive and you are running into some errors well you do it I have a video up here where I show you exactly
7:28
how to remove restricted restricted Scopes error there are also lots of
7:34
comments under the video where our community helps each other uh when somebody runs into issues I try to
7:41
monitor these comments as much as I can and get involved and uh yeah while I'm
7:47
talking to you the automation has finished and let's see what we got from our URL
7:55
so so as you can see this is 22 must visit destinations for fall travel so
8:03
yeah and this is what has been made by slidee so let's build this one quickly
8:08
together it doesn't take a lot of time I've when once I when I started to
8:15
build it it was more complicated but it's going to be easier so let's start
8:21
with a new scenario create a new scenario and we're
8:27
going to start with the web hook uh web hook
8:33
response uh not web hook response sorry we're going to start with web hook custom web hook going to move this timer
8:41
here delete this one and now you need to add a web hook I'm going to click add
8:46
and this is going to be JS automates uh
8:51
slide speak uh web hook and click save and you obtain an
9:00
address we will need this address uh so let's head and create a new
9:08
spreadsheet so this is again will be JS
9:15
automates uh slide speak okay and this will be
9:23
keyword slash URL this will be um what's the name what
9:30
what the name I said here okay it's going to be a number of
9:38
slides so the available values are from 3 to 12 so I don't forget it uh the next
9:47
one be will be template uh and this will be
9:55
execute and this will be uh
10:01
status and this will be Google Drive
10:06
URL okay so once you have this set
10:12
up you need to click on extensions app script
10:19
and I have my script copied here but I will include it in the
10:24
description of this video so you can use it okay
10:30
and uh what you need to do is head back to make now and copy this URL of the web
10:37
hook so copy address to clipboard and head to the script so where's the script
10:42
here is the script and here we have a constant web hook URL and we're going to
10:48
paste the URL here okay replace with your web hook URL so we're going to
10:55
click save and we're going to click deploy new
11:01
deployment uh we're going to click on this um thingy web app new description
11:08
it's going to be JS automates and who has access if this is important you said
11:19
deploy it's creating the deployment so once it has given the
11:25
deployment you need to authorize access so you click on authorize access you select your Gmail
11:31
account uh it's going to drop out this um notification so you click on advance
11:38
and you're going to click go to Untitled project I'm going to
11:45
allo so this deploys the project for our spreadsheet so we're going to click on
11:51
done oh um here is the sheet name so I'm
11:57
I need to call it input sheet so this is going to be rename input sheet okay so
12:03
now the sheet is completely set up the one thing we need in our script we need to head to this
12:10
triggers we're going to add a trigger and everything stays the same
12:16
except the last one which is on edit once we edit something it automatically
12:22
triggers the script so click save
12:29
yeah so the trigger has been done we can run a test okay we're going to click run
12:37
once and now if I enter keyword for example let's say
12:44
ai ai automation I set number of slides and I
12:50
select template default I should have a button here yes
12:55
I execute it and I should receive a data here which I do okay so the next one
13:04
this is not mandatory but I like to do it this way so I'm going to add a Google sheet I'm going to update the
13:10
row and need to choose this JS out of my slid
13:20
speak uh sheet name is input sheet uh row number I will get from my
13:27
web hook which is row number and the status is
13:38
presentation um processing okay uh now I'm going to if
13:48
because I want to do this for keywords and I also want to do this for URLs so
13:54
I'm going to add a router
13:59
here and I will have a two Roots so first one we're going to build the upper
14:05
route so I need to make a request so HTTP make a
14:12
request connect this and here you're going to have
14:18
get the URL that you need to Target is uh this one api. slides. call you can
14:29
get it also from the documentation uh
14:37
here so we need to have a post method
14:42
we're going to add a header and the header will
14:50
be X API key and the value will be your API key so once you register with slide
14:56
speak uh this is a paid uh Tool uh which
15:02
costs $49 per month and you can generate 1,000 slides with this credit
15:10
so you're going to have your API key you're going to paste it
15:18
here uh then you going to have your body type raw content type it's going to be
15:24
Json and the request should look like
15:29
this you can also have this adjacent from the
15:35
website um where is it where is it okay so here I'm going to copy from
15:42
here so it's easier for you to understand so copy this one by the way this is docs.
15:48
slides. co so you get the API documentation here and you paste it here
15:56
so we're going to replace this text with our variable from web hook the
16:03
length also we have number of slides and the theme we also have default or
16:12
whatever uh the theme we also get from web hook Okay click par response and click
16:21
okay next one we going to add a timer
16:26
sleep set the delay time timer to 60 and then we're going to make a get
16:33
request um so we need to have an HTTP
16:38
module make a request get the URL that we need to Target
16:44
is uh slide speak um who who who uh this one API V1
16:53
task like this and um actual URL is this one so
17:02
I'm going to add it uh task status we get from this module which is Task ID
17:09
we're going to use get and we need to add headers the header will be um bum bum bum it's API
17:17
key and your API key and parse response
17:27
okay the next thing that we need to add is get a file
17:33
module but before that we're going to run this module
17:40
only and we're going to run this module only to get uh the actual URL so text
17:48
will be AI automations number of slides four and theme
17:59
in the response we get um task ID copy it paste it here click run once
18:08
and this will give us status spending um but meanwhile we can add an
18:16
HTTP module that will get us the file that we're going to upload uh
18:23
to that we're going to upload to our Google Drive so run this module only
18:29
again maybe it's ready now yeah the data task result and this
18:34
is the URL that we're going to use in our get a file HTTP module so task info
18:42
URL okay now we're going to upload it to our Google Drive so Google Drive upload a
18:50
[Music] file uh folder ID we're going to select
19:02
I'm going to select Janice
19:09
and presentations okay and we're going to
19:14
click on map so the data will be the same we're going to just change the file
19:20
name the file name we're going to use from the part um the web hook module and
19:26
we need to add pptx at the end uh okay on going to click okay again
19:34
so next one we're going to add Google Drive module that's going to give us a URL of the file so it's going to be get
19:43
a share link to get a share link you need uh file ID which we're going to get
19:50
from our upload module and we need to change the type to
19:55
anyone okay and the final one will be Google sheet update a row and what we're
20:02
going to update here is uh bom JS H slid speak we're going to
20:12
have our input sheet row number we're going to get from web hook and uh we're going to update the
20:19
status to done and Google Drive URL will be
20:25
um here um share link from this module
20:31
okay uh and that's about it for the first route so we can test it out I'm
20:36
going to head to the spreadsheet add keyword AI automation number of slides I'm going to
20:42
set to five template to Let's select a template template will be
20:52
itm okay the execute button should appear it does but we need need to click
20:59
run once we're going to wait for new data I'm going to click execute and the
21:05
status should update
21:14
to yep presentation processing yep
21:19
yeah so this is delay the 60c delay so uh
21:25
slide so slid speak has time to generate the
21:35
presentation uh if you are having again if you are having trouble setting up Google Drive I have a video up here
21:41
where I explain how you can avoid these restricted Scopes this video help helped
21:47
many probably you too if you are watching and you watch that video and um
21:54
there is also an active discussion in the comment section because some people run into more errors
22:01
and others try to help them out I also try to get inv involved as much as I
22:07
can uh if you have any questions about the automations you can reach me via
22:13
email I also have my WhatsApp in the description and if you need uh if you
22:19
want to hire me for AI automations like these or any others feel free to contact
22:25
me so this should be done and let's see see what happened so the status is done
22:30
and we have our Google Drive URL we're going to open it so this presentation
22:37
has been made simply from a single keyword AI automation
22:47
right I think it's pretty cool so what we're going to do now we're going to
22:52
select all these modules click copy and click paste
22:59
so we can create the second route for um for if I want to create um a
23:10
presentation from my URL so what we need we need an HTTP
23:15
module it's going to make a request here we're going to add URL we're going
23:22
to add from text so whenever we enter URL it's going to run through this route
23:27
we're gonna have pars response okay the next one module we're going to text
23:34
parser HTML to text so this module will return us an HTML content and we're
23:40
going to pass it to a text to Text data
23:45
okay and the next module is CH GPT module or open AI
23:52
module um that's going to remove all the unnecessary things and create a j for us
24:08
GPT so select the model I'm using J gbd 40
24:15
mini I'm going to set max completions to to to
24:20
1, uh 16,000 and I'm going to add message user
24:25
message and I'm going to copy the message from my my internal um uh
24:35
scenario like this uh so it's quicker for the video the s for the sake of the
24:41
video so I'm just going to replace the variables so text will be this text parser
24:47
module and the length will be from our web hook number of slides and the theme
24:56
will be theme okay and what we what this going to do it's going to give a
25:02
complete article without title images I need plain text to be uh to this text to
25:08
be plain text Escape any special character so this can be placed in adjacent don't add your comments insert
25:15
the response in this Json make sure you respond with the valid Json what I don't
25:20
know why I have this one never add your comments never add these three little thingies Jason at the start and three
25:27
little thingies at the end and the length is number of slides and the theme is theme and so what it going to do it's
25:34
going to take all these three variables and populate this Json that's going to be said to slid
25:41
speake uh service API so we're going to connect it we're going to click on this
25:47
one and we're going to delete the requested content and
25:53
substitute it with the result from CH gbt okay
26:00
and we can align this now we need to set up filters so whenever I enter URL here
26:08
it must go this route if I have a simple keyword it goes this route so here we
26:14
set up condition text and it does not start
26:20
with HTTP and here exactly opposite text
26:28
uh starts with HTTP we click okay and that's about it
26:38
uh we can uh now head to uh I'm going to head to my website
26:49
URL paste it here uh I'm going to set five slides and I'm going to
26:56
choose Nexus this template for
27:04
this and checkbox appears and I'm going to click run once I'm going to wait for
27:10
new data and I'm going to click execute so the status should update yes and now
27:18
the automation is working uh as you can see we entered a URL here so it went through this route
27:26
because this filter filtered out that it starts with an HTTP and this Ro uh filter filtered it
27:34
out so that it does start with HTTP so chat GPT is now populating the
27:41
Json which will be sent to slid speak
27:46
API uh it's going to have this sleep module and then it's going to get the
27:53
actual presentation and upload it to Google Drive
28:00
while we wait for the result um uh if you have any questions about this just
28:05
leave a comment please uh also I have my contact details in the description um
28:12
you can reach out to me if you need certain automations for yourself for your business um also I'm um giving
28:22
consultations uh please uh feel free to contact me don't be sh shy
28:30
um yeah and as I said in the start of the video if you are looking for a
28:37
specific thing that you would like to be automated just leave a comment I will go
28:43
through all of them and um probably uh in some of the future videos
28:49
I will cover the automation for you so you can learn uh how to make it on your
28:55
own so yeah this is this timer is um annoying but if it's run automatically
29:02
you don't uh even notice it so you just click the button execute and uh once the
29:08
result arrives it arrives so it's going to arrive within
29:16
seconds so the status is done and Google Drive
29:24
URL is this exploring attend that's the same thing uh that my article is
29:34
about and as you can see it even add images
29:40
which are not very good because for some reason it took the
29:45
default template uh but anyways it's um I think
29:50
it's very good if you if you can do this type of things
29:55
automatically so yeah this is how you you automatically create PowerPoint presentations using AI from a keyword
30:03
from uh URL and also in this video I
30:08
hope you learn how you can create interesting spreadsheets using App
30:14
scripts if you enjoyed the video please click the like button subscribe to the
30:19
channel and I will see you in the next video thank you for watching goodbye