live_tv
Livestream Starting Soon
00
Hours
:
00
Minutes
:
00
Seconds
Up next in 10
In this tutorial, I’ll show you how to automate WordPress content creation using Make.com, integrating tools like Google Sheets, ChatGPT, and DALL-E. 🚀 This workflow covers every step, from generating article content with ChatGPT to creating images using DALL-E and posting them automatically to WordPress. 📝🖼️ I also address common errors such as handling duplicate tags, categories, and ensuring the HTML structure is clean. 💡 Perfect for beginners who want to streamline WordPress posting with AI and automation! 🤖
What You’ll Learn:
• ⚙️ Automating content creation using ChatGPT and Google Sheets.
• 🖼️ Automatically generating images with DALL-E.
• 🗂️ Setting up WordPress categories, tags, and posts through Make.com.
• 🛠️ Troubleshooting common automation issues.
Links (I might get a commission if you sign up using these links):
Sign Up with MAKE using this link - https://www.make.com/en/register?pc=jsautomates
Feel free to contact me for personalized Make.com coaching or to hire me for Make.com automation projects! Whether you’re looking to automate workflows, streamline processes, or learn how to use Make.com and AI tools, I’m here to help.
📧 Email: [email protected]
📱 WhatsApp: +37125340386
AI Automations & Coaching: https://jsautomates.com
Let’s take your automation to the next level! 🚀
Show More Show Less View Video Transcript
0:00
hey everyone my name is Janis and in
0:02
today's video I'm going to show you the
0:04
basics of Wordpress automation using
0:07
make.com platform we're going to create
0:10
a simple blog post I'm going to explain
0:12
you the steps and I hope you learn
0:14
something valuable to start your
0:16
automation Journey so let's get
0:20
started so here we are on a blank
0:24
scenario page and for this video I'm
0:28
going to use
0:30
a Google spreadsheet as my source file
0:33
and I also going to use J GPD to create
0:36
content for the blog as well as Del e to
0:39
create the image for the
0:41
blog uh first we're going to add a
0:44
module Google Sheets module which going
0:48
to watch new
0:51
rows we're going to select our
0:53
connection here if you don't have a
0:56
connection you can add connection to
0:58
your Google account this will
1:00
uh give you access to your Google Sheets
1:04
so we need to select our spreadsheet ID
1:08
which will
1:09
be uh WordPress
1:12
testing our table contains headers yes
1:16
and the sheet name is sheet one this is
1:19
this one sheet one okay so and the limit
1:23
we're going to set to one
1:25
okay and click
1:28
all after this we're going to add a
1:32
WordPress uh actually we're going to
1:36
click run once to get some data in the
1:39
module so yeah as you can see we have
1:43
some data from our spreadsheet and we
1:46
can work now with other modules so the
1:50
next module that we're going to add is
1:54
uh to GPT module open
1:57
AI uh we're going to create a compl
2:02
completion and you need API um for chbt
2:08
to run onm make.com so you can get that
2:12
from open AI
2:14
website uh we going to select a module
2:17
here and it's going to be chud GPT 40
2:20
mini the latest version it's very cheap
2:23
and it's the results are pretty decent
2:25
so for the max tokens I'm going to set
2:29
zero
2:30
and we're going to click add message so
2:33
the role will be system the system is
2:37
like you explained what the chud gbt is
2:40
so for us it's going to be um helpful
2:46
blog
2:47
content
2:53
creator you write uni unique blog
3:03
post using simple
3:07
language as I said this is just only for
3:10
showcase so those who don't know how
3:14
this works this is just an example you
3:18
can use your own prompts use your own
3:21
messages to get better results so the
3:25
next step
3:27
is a user message where we're going to
3:30
ask chbt to write an
3:35
article for our blog
3:38
post for our
3:41
blog and this
3:44
article will
3:49
have
3:52
headers and paragraphs
4:00
the article should be based on our
4:03
keyword from our Google sheet
4:16
so and now on the as you can see here we
4:21
can SE
4:23
select um a variable so we're going to
4:27
select a and from column A we have a
4:31
keyword best cars so this article is
4:34
going to be about the best cars
4:38
so if I type here best
4:42
cats the next time and the article will
4:45
be generated about best cats
4:50
okay okay
4:53
so we're going to run again this row
5:07
okay and the result is like this so here
5:12
we have SIMPLE
5:15
jgpt generated
5:19
article after this we add a WordPress
5:24
module that's going to create a post for
5:28
us
5:30
so I'm going to show you how you can
5:31
connect your WordPress with
5:33
make.com you just simply click add and
5:38
add the name so this will be JS
5:42
automat
5:44
video and we're going to head to our
5:48
WordPress I have a clean installation
5:51
just for the sake of this video so I'm
5:53
going to add a plugin and add new plugin
5:57
and the plugin will be make
6:04
connector install
6:09
now and
6:12
activate so here on the left menu we
6:15
have now this
6:17
make item we're going to click it and
6:21
then we're going to copy our API
6:24
key we're going to paste the API key
6:27
here and here we need to copy our for
6:29
domain name mine is this one because I
6:32
said it's only for this video and then
6:35
we're going to write BP
6:40
Dash
6:42
Json trailing slash save this should
6:46
establish the
6:51
connection okay
6:54
so for the title we're going to use
6:57
title from our
7:01
spreadsheet I created this one so the
7:04
title will be B
7:07
column the content will be the result
7:10
from the chat
7:13
GPT and the type of the post is going to
7:17
be a post where you can create pages and
7:21
all other kind of stuff using this
7:25
module the excerpt will be taken
7:30
from our spreadsheet but you can also
7:33
ask CH GPD to write the excerpt this is
7:37
just so you understand how modules how
7:41
variables work with WordPress uh
7:47
integration so yeah we click slug here
7:51
we have column slug so yeah and we need
7:55
uh before we create a post we're going
7:57
to click okay now we we're going to
8:00
create
8:03
um uh a
8:07
tag
8:10
so for the tag we need to select again
8:14
our connection to our WordPress and the
8:20
name of the tag we're going to
8:23
use this one as you can see column D is
8:28
tag and car will be used as a tag I'm
8:33
going to leave the description and slug
8:35
empty oh I forgot this click
8:38
okay let's do it
8:42
again tag okay and we're going to create
8:46
a category as well so you know how to do
8:50
it so create a
8:53
Cate and uh the name again we use it
8:57
from Google Sheets
9:03
okay we're going to leave description
9:05
blank slug blank and parent category
9:09
blank I'm sorry my light just died but
9:13
I'm going to continue
9:14
filming okay and we also need some image
9:18
for our simple blog post
9:23
so um we're going to use Del e to create
9:27
them featured image so where is generate
9:32
image
9:34
okay uh and we're going to use Del E3
9:38
and we're going to write prompt
9:41
so create image for our for my blog post
9:49
about and here we again use a data from
9:53
our
9:56
spreadsheet okay
10:00
so how does the Del e will generate the
10:04
image but we need to store the image
10:06
somewhere before we upload it to go uh
10:09
to our WordPress so we're g to click on
10:13
plus sign and search for
10:16
HTTP and then we're going to click on
10:18
get a file add to our workflow and the
10:22
URL will be the data from the open I AI
10:28
Deli e um
10:31
module so it when the image is generated
10:35
it gives an URL and this URL will be
10:39
uploaded to make and after that it's
10:41
going to be uploaded to Wordpress so
10:44
click
10:45
okay now we're going to add another
10:49
module from WordPress and this is going
10:52
to
10:54
be create media item
11:01
so
11:03
actually we can get that image directly
11:07
from chat GPD I'm sorry for that uh we
11:10
can delete this
11:12
one so here it's already selected the
11:15
image from chat GPT the title of the
11:18
image we're going to again take from
11:21
spreadsheet let's use this one column B
11:26
okay and let's now head again again to
11:29
our create a post uh
11:35
module okay
11:37
so status we're going to set
11:41
to draft because
11:44
usually if you are if you haven't
11:47
perfected your prompts your um workflow
11:52
then you won't get a very good result
11:55
for example this article that I'm
11:58
generating now I would
11:59
never put it on auto but if I use a
12:04
specific prompt I would consider it it
12:08
publishing straight away so this time
12:10
we're going to set it to draft just so
12:12
you can see how it works
12:15
so okay so categories we're going to map
12:19
click on map and now we can
12:22
select uh category from the one that we
12:26
just created so it's going to be
12:28
category the uh variable here and the
12:32
same for
12:34
tags we're going to use tags
12:38
variable here very easy very
12:41
straightforward and for the featured
12:43
media ID again we select this variable
12:48
from here
12:51
and yeah so that's
12:53
that so basically this is a simple easy
12:58
work flow just to get you
13:01
started uh you can
13:04
um use better prompts you can Implement
13:08
other features in the workflow you can
13:10
use different services to create the
13:12
images for the blog and uh if you are
13:16
interested in more specific or more
13:19
broader uh tutorials please let me know
13:22
in the comments and I
13:23
will create one for you so let's run
13:27
this let's see what we get get and uh
13:30
yeah so choose where to start we're
13:33
going to choose all K and click run
13:37
once
13:42
so while it's running should be fairly
13:45
quickly just the image takes uh a little
13:48
bit longer to
13:49
generate but as you can see it already
13:52
created a tag for us
13:55
so as you can see it's a specific ID for
13:59
it the same for
14:01
category and we got some error here
14:09
so uh okay so now I remember I haven't
14:14
used this for quite a long time so we're
14:17
going to click here show advanced
14:20
settings and you can change
14:23
different different settings here so
14:26
this is the size of the output image
14:28
this is the quality we're going to use
14:30
standard the square one the style is
14:33
vivid or natural we're going to leave to
14:35
Vivid and we need to change the response
14:38
format to image file this way uh we
14:44
don't we we have the image already with
14:48
make.com otherwise if you select URL
14:52
then you need to add the HTTP model that
14:55
I tried to add before so we click image
14:59
file we click okay and now we're going
15:02
to rerun this uh
15:06
again
15:08
yeah choose where to start all okay and
15:12
let's rerun
15:15
this as you can see this is um um very
15:19
simple
15:20
workflow oh and now we have already the
15:23
same tag so you can't have the same uh
15:27
tag name as you have
15:29
already created so we're going to create
15:33
a different we're going to add here
15:38
um so cars to buy so this is another way
15:44
how you can do some stuff you can have a
15:47
variable
15:49
from source file and then you can
15:51
manually add
15:53
some text or some numbers to it and the
15:57
same will apply to category will
16:03
add to the a yeah and now let's rerun
16:10
it and this is
16:12
very this is the great thing about make
16:16
when you run into errors you quickly
16:19
find a solution how to fix them and
16:24
um yeah so as you can see it's very
16:27
quickly generating the article because
16:29
it's very simple article and a very
16:32
short one uh but now because we changed
16:36
the title of the tag it generated the
16:39
tag properly and the same applies to
16:42
category so you can't have uh the same
16:46
tag with the same you can't have two
16:48
tags with the same name and the same
16:50
applies to categories so now the image
16:52
is
16:54
generated the media item the image is
16:58
uploaded to our server and the post has
17:01
been created let's take a look what we
17:03
have so before we go to the Post itself
17:06
we're going to
17:07
quickly uh check uh the tag page as you
17:11
can see we have two tags one is the
17:13
initial one and the second is the one
17:16
that I add add um to buy at the end of
17:20
the variable let's check the
17:23
categories we have three categories
17:25
because uncategorized comes by default
17:28
with WordPress
17:29
but we have two categories that we
17:33
generated with make.com and let's see
17:36
our post so here is the draft the title
17:40
is the best card to buy okay and let's
17:44
head into the
17:47
post okay so as you can
17:50
see here is the article uh here is uh
17:54
the image
17:55
generated uh we could work to have the
18:00
response in HTML or we can phrase this
18:04
response to get H uh 2 H3 headings and
18:10
uh properly
18:13
um coded uh properly set uh paragraphs
18:20
but actually I'm going to publish this
18:22
and then I'm going to show you how to
18:24
fix these so we're going to view post
18:29
so as you can see here is the featured
18:31
image and here is our blog post uh
18:36
actually if we take out these um
18:42
hashtags uh it's looks like pretty good
18:44
article for
18:46
me a simple um thing to start your own
18:51
automated blog so let's tackle these
18:55
ones so we're going to head back to
18:57
make.com and we going Ask Jud
19:00
gbt
19:04
please
19:07
um
19:09
don't
19:13
use
19:15
hashtags
19:17
instead
19:19
and
19:21
H2 or
19:24
age three four titles
19:31
Le ul and B for
19:38
paragraphs okay uh let's add new keyword
19:41
so best cats title will be best cats in
19:46
the
19:47
world category will call
19:51
cats cars will be uh I'm sorry tag will
19:54
be as well cats and the slug will be
19:58
this
19:59
[Music]
20:00
um this is
20:04
a
20:05
simple sample
20:08
slug okay and let's see what happens now
20:14
so uh choose manually this way you can
20:18
choose a specific Row from the
20:20
spreadsheet we're going to use the row
20:22
three okay and let's rerun this and see
20:26
what we get uh do we fix this or not if
20:31
we don't fix it again The Prompt must be
20:38
adjusted so as you can see very quickly
20:40
the article is generated and from the
20:43
result I see that everything's going to
20:45
be okay
20:46
now
20:49
uh the tag has been created the category
20:52
the image the post uh sorry the image
20:55
has been uploaded to our server and the
20:58
post has been created so let's go check
21:00
it out so we're going to head to our
21:02
dashboard
21:04
posts and best cats in the
21:09
world and you can see it's a clean uh
21:12
article we're going to click
21:16
publish and let's view the
21:19
post for some reason it added the same
21:24
image uh to the post but it can be fixed
21:27
as well
21:29
[Music]
21:30
um but yeah here is the article about
21:34
cats so introduction with H1 title H2
21:42
title all
21:44
this uh
21:46
Second and five five best cats in the
21:49
world so and the conclusion so this is
21:54
how simple it is to create a a WordPress
21:57
blog so okay so I hope that this video
22:01
was useful to you to get your automation
22:05
started uh if you need help um
22:08
consultation or you need some automation
22:12
work to be done my contact details are
22:14
in the description I hope you have a
22:16
great great day I hope you learn
22:18
something from this video and I will see
22:20
you in the next video thank you bye-bye
#Business & Industrial