0:00
hey I want you to steal this Pinterest automation from me this starts with a source file from Google Sheets then it
0:07
checks all the boards that you have on your account after that if if there is an existing board it uses this board or
0:15
it creates a new board then it analyzes the image you want to pin creates a
0:21
description and title for it creates the pin and updates your Google Sheets to a
0:27
conditional logic so that um you can have multiple data in your sheets with
0:33
multiple links and you never pin the same article over and over again it
0:39
diverses your uh Pinterest schedule so my name is jannis and welcome to JS
0:45
alates uh YouTube channel as I mentioned before in this video I'm going to show
0:51
you a cool complete Pinterest automation that you can use this automation has
0:57
some great features that I'm going to show you it's very very easy to make in this video I'm going to take you step by
1:04
step how you can create one for your own if you don't want to create it I will leave a a link uh in the description so
1:12
you can download this Automation and upload it to your make.com account so
1:19
let's get back to make.com I'm going to show you how it works so starts with a
1:25
search for rows it searches for a status that has pending so for example my first
1:33
line has a status of pending then it checks after five uh rows if I have any
1:41
data if I do have any data then it's going to update um current row to done when the
1:48
pin is done and uh it's going to add um pending one to the second uh row and
1:56
it's going to be easier if I show you here is my account as you can see see I don't have any boards um nothing uh for
2:04
this to work it's required to have um a URL that you're going to have in your pin this is not mandatory but there's no
2:12
point of creating pins without a URL I think thing that we want to do with Pinterest is get traffic to our website
2:18
so um yeah we have article URL we have image URL that we want to pin and we
2:26
have a board name as you can see this one is living room dining room and
2:31
kitchen so let's run this automation once and I show you what what's going to
2:37
happen so as I said I don't have any boards so basically the automation
2:42
should create a board for me and then create a pin in this board so let's run
2:48
it once as you can see it went through this
2:55
route because it checked all the boards that I have in my account and I have
3:00
none of the boards so it created a board analyzed the image created the
3:07
description for it the Pinterest title and created the pin after this it
3:15
updated this row to status done it updated plus four rows to to
3:22
pending and then it checks if um the
3:27
next status is existent for example it checks if this was empty or not if it
3:34
exists it updates the next one if it does not exist it updates plus three
3:39
rows so as you can see this one is set to pending one and this is set to pending so next time I'm going to run
3:47
the uh automation it's going to take this pending row instead of going uh 2 3 4
3:56
because then we're going to have if we don't have these statuses then we're going to have three posts in a row about
4:02
living room which is not good so we have one post about living room then we have one post about dining room then we're
4:09
going to have one post about kitchen and after that the automation will return to living room so let's head to Pinterest
4:17
refresh the feed and see if the pin has been done so yeah here is the
4:22
PIN here I have the URL uh here is the title
4:29
and here is the description which is generated by this uh cool cad GPT mod
4:37
module that analyzes the image basically what I do I'm I say I'm an Pinterest
4:44
expert um about interior and uh I asked CH GPT to write the description and
4:51
title based on the image URL uh and I asked for the response to be in Json for
5:00
title and for the description so let's run this once again
5:06
and then I think I'm going to show you how you can create this from scratch as I said before if you want to you can
5:12
download it from the description okay okay so let's run
5:20
again it's going to check again if I have boards uh I have one board living
5:25
room but I don't have a board called dining room room and as you can see the
5:32
status is being updated let's run again for the
5:39
kitchen now the kitchen will run it again creates a board analyzes
5:47
the image creates the pin updates the sheets okay so let's check the um Google
5:56
Sheets and as you can see it has updated the kit kitchen to done and change the
6:02
next the the second to pending so next time we're going to run it's going to be
6:07
the living room let's head to Pinterest and see if we have three different boards with the three different P pins
6:15
so here are three pins and here are my three boards let's run this once again
6:22
and now it's going to run through different route because we already have the boards here and it's going to filter
6:28
the board that we actually want to post this uh next pin so let's run
6:36
it as you can see it went through the this from for this route and now it's
6:42
creating a pin in already existing board so let's refresh the
6:50
Pinterest and you can see we have two pins in our living room
6:55
board and this one is set to done now and next one will be this one which is
7:02
set to pending so let's head to make and let's make this all completely from
7:08
scratch so I'm going to delete these statuses put this two
7:15
pending and then if it this automation is working we
7:22
can add more data um in here so I I will now
7:30
introduce home decors as well and
7:35
now if the automation is working and we have all our statuses filled in it's
7:41
just going to continue taking next um empty uh rows uh empty cells from uh
7:50
from this um sheet so let's head to make.com and we're going to create this
7:57
one from completely from SC scratch I'm going to explain you everything step by step
8:04
so I'm going to save [Applause] changes let's leave this open in case we
8:11
need some data from it so create new
8:17
scenario and we're going to start with Google Sheets and we're going to search
8:25
rows I'm going to select my account my spreadsheet for Pinterest automation I'm
8:33
going to set the sheet one and what we need to do is status is
8:40
equal to pending and we can set this to case
8:46
insensitive and we're going to set this limit to one the next module that we need we need
8:53
to um check uh if there is existing data
9:00
because it's going to impact our um Automation in the future so we're going
9:07
to get a cell we're going to choose our
9:15
spreadsheet and this sheet one and this cell is going to be
9:23
a and then we're going to use um
9:30
sum and we're going to use
9:35
um a row number from our initial uh uh module
9:46
plus four depending on how many items you
9:52
have per uh URL for example here I have three so we need to check if there is
9:59
something after the third okay um after that we going to
10:09
make a Pinterest module that's going to give us all the boards that we currently
10:15
have in our account so it's list boards we going to use our account and we're
10:23
going to set this to limit so 2,000 because um when you have more boards you
10:29
will for uh forget that you have set the limit and after this we need to add
10:38
a tools module that's going to aggregate uh all the name all the board names for
10:46
us so the source is going to be Pinterest and the text is going to be name here we're going to click on show
10:53
advanced settings and we have um need to
10:59
select row separator and we're going to select other and we're going to click on comma and space and click
11:07
okay why is this yellow I don't know okay I it can't be the last okay so now
11:16
we're going to add a rotor this rotor will give us two Roots
11:22
one root is if we already have a board with the specific name or the second
11:29
route will be if we don't have a board with a specific name so here on the
11:37
first one we're going to add Pinterest module and we're going to add create a
11:47
board and for the name we're going to use
11:53
um VAR uh variable from the Google Sheets which is this one the D column
12:01
I'm going to put this in bold board name is D description we're going to leave empty
12:08
and we're going to click okay so basically here we need to set up a
12:13
filter it's a board filter
12:20
so first we select board name uh and oh no we select um the
12:29
result from our text aggregator where we're going to have all our board names
12:34
we choose this one and then we select um
12:39
does not contain case insensitive uh and the board name so
12:46
basically if this module doesn't not contain our board name it's going to go through this route and it's going to
12:54
create a board here on the other hand we're gonna add again Pinterest module
13:00
to list all the boards because here we're going to set up a filter that if text contains case
13:10
insensitive uh board name then we going to list all the
13:16
boards that we have and we're going to next one is
13:23
going to be CH GPT module that analyze images but before
13:30
that um we need to set up a filter because we need only the
13:36
name um that um for example let's say we have uh
13:45
three um boards here in uh in the response and we need to only filter the
13:51
one that's equal to our board name from the Google sheet so we click this one
13:58
okay so this filter will do that for us the next one we're going to set up the
14:03
GPT analyze image Vision you select your connection and
14:10
here is prompt I'm going to copy the prompt from here because it's going to
14:16
be easier uh basically what it says it's
14:21
analyze the image you are a Pinterest expert your profile is about interior
14:28
you can change this to whatever um Niche you are in and based on the image you
14:34
write description in first person provide a response in Jason in Jason
14:39
give me title for Pinterest pin and Pinterest pin description uh you will never add Jason
14:46
at the start uh of your response and you will never add these uh these symbols at
14:53
the end of the response and um then I at the end I give him um a sample how the
15:00
response should be so it's always title and it's always description
15:06
so the next one we need to add images it's going to be image URL and we're
15:11
going to add image URL from our Google Sheets for the module I'm going to use
15:18
uh GPT 40 mini the latest version and I'm going to set to Max tokens to
15:25
500 after this we need to add
15:30
ajason um module that's going to farce the Json for us so we can get um two
15:37
separate um separate
15:43
variables and after this we're going to add um a Pinterest
15:48
module actually we need to uh let's copy this sample and let's run
15:57
this module only uh to get some data in it okay so as you
16:03
can see because of the Json we get two um variables one is title and one is
16:10
description and because I give the CH GPT exact um example it's always going
16:16
to be title it's always going to be description here if it changes it messes
16:21
up all the automation so now we're going to add a Pinterest module that's going to create
16:27
a pin uh media is going to be image URL and
16:35
the URL again we get from our spreadsheet the board will be we're
16:43
going to choose map and the board we're going to select here is board
16:51
ID here this one uh board section nothing and the title will be this one
16:58
from the Json and the description will be from the [Music]
17:04
Json okay and the link will be from our Google spreadsheet and it's going to
17:11
be IM article URL okay now we're going
17:18
to copy this all copy modules paste them
17:25
here and connect we can remove this filter because this one was to filter out
17:32
existing um uh existing um boards so
17:38
okay here we don't have to adjust anything here as well but we need to
17:45
adjust the Pinterest because the board is going to be this one our newly
17:51
created board so okay and the title will
17:57
be the title will be be this one the same just the board
18:02
ID okay so yeah now we going to need to add
18:08
some conditional Logic for our spreadsheets as I mentioned before so we
18:13
don't get um the same um um the same art
18:20
article URL um pinned um in a
18:25
row so first we're going to add a row
18:31
router here and as I mentioned before we check
18:37
if we have some data in cell plus 4
18:44
so we need two roots in any case we need to update uh
18:50
the C current row to done right so we're going to
18:57
add update Arrow uh choose
19:03
spreadsheet we're going to [Music]
19:09
use Pinterest automation sheet one and the row number
19:17
is um this one and the status will be set to done
19:24
okay now we can clone this this
19:29
module delete this one and we have two Roots again so this root the first one
19:37
will be if the value exists in this um
19:43
condition value exist and the second route will be
19:51
condition value does not
19:56
exist so basically if the if there is some value in this response then it goes
20:04
through root one if not it's going to go to root
20:10
two by the way I had a a different video where I showed um how you can integrate
20:19
Pinterest to get free traffic to your website I recommend you to watch that video as well if you are finding this
20:26
video useful please click the like button below and subscribe to the channel because I'm going to have more
20:32
videos like this in the future um if you have any questions just leave me a comment I will gladly respond to you and
20:40
um yeah let's continue with the workflow so
20:46
basically what we need to add here um because the value was empty we
20:54
now need to search for rose that has a pending one um status so this is this is
21:04
only because when it goes let's say through here so it
21:10
returns to start so this module uh the next one will help us do it just exactly
21:16
that so we're going to search row again we're going to select our
21:25
spreadsheet and we're going to select sheet one and we're going to set status equal to
21:33
pending one okay and limit will be one so it
21:39
returns to the first in the order uh of
21:44
pin uh pending one statuses yeah okay so this one will return us a
21:52
row number which has pending one status and we're going to update the pending
21:58
one one status to pending so next time the automation
22:04
starts it searches for pending and we have this value in our uh spreadsheet so
22:11
uh update a row again choose
22:17
spreadsheet uh Pinterest
22:22
automation sheet name sheet one row number now we're going to select row number from this 7
22:29
module that that's um that had the
22:34
pending one status so row number and we're going to update the status from
22:41
pending one to pending so the next time automation runs
22:47
by the way you can set any time here for this automation to run every uh
22:52
whatsoever minutes just put um let's say every six minutes
22:59
okay and then just remember to switch this to on and then every 60 Minutes
23:04
this automation will create a post to your Pinterest account as long as it has a data in your spreadsheets also please
23:11
remember that you can use any other inputs um than um I do in this sample
23:19
for example you can get the images from your url you can have the images made by
23:25
um Ai and include this image generation in this workflow there are many
23:32
possibilities I'm just showing you how uh how to automate the Pinterest with uh
23:41
correctly because all the automations that I seen on YouTube include only
23:48
creating a board not filtering the existing boards um I think this is very
23:54
useful because it's not kind of useful if you create board for every image you
24:00
are pinning you should structurize categorize your pins into boards uh the
24:07
proper way and also the uh having a board is mandatory to Pinterest you
24:13
can't create a pin without having a board so yeah that's that so we're going
24:19
to continue with our other route that's if the value
24:26
exists for example we now run this one and the automation checks if there
24:32
exists value in this row then we need to update that row to pending one so Google
24:41
sheet update a row choose
24:46
file spreadsheet and Pinterest automation sheet name sheet one and here
24:54
we're going to put some magic because the row number is going to be row number from our initial
25:04
module we're going to select plus sign and we're going to put plus 4 if you
25:12
have uh more than for example I have three so you I need to put plus four if
25:18
you have five um the same URLs you need to put plus uh six if you have six then
25:27
you put plus seven so it's extra one this will add data to plus 4 and it's
25:33
going to set it to um
25:39
bending now we need to check another thing because when you're going to have
25:47
this uh column filled up you're going to run into situation when this one is
25:53
pending and this one is done and we never want to update
25:59
done so what we do is we check
26:06
if there uh exists any data in plus one uh
26:13
row so we're going to get a cell choose file
26:20
again once we done this we just copy this to our second um and that's
26:27
basically it so Pinterest
26:32
automation sheet one cell and the cell is going to
26:42
be um from our initial sheet one uh for
26:47
searching we need D then we head to here click sum here we
26:56
have our initial initial row number and we're going to
27:10
this okay then we're going to add a
27:18
router uh again if data exists or if data does not exist so if data does not
27:33
update a row that's the next one I know it's kind of confusing but once you get
27:40
started um you will see um uh how this works and it's very very very
27:50
efficient so uh here we get
27:56
um our from the first module row number and just
28:04
plus one and we set status to pending
28:13
one that if condition value does not exist okay and here we set a
28:22
filter uh if value exist okay
28:28
we just going to clone this
28:34
here and we're going to change this not to plus one but to plus three so uh like
28:43
this and now what we're going to do is we're going to select all these copy
28:49
modules paste move here and connect to our uh
28:58
Pinterest so now align everything and that's basically it so let's let's
29:07
remove these so I can show you I'm going to copy them okay and
29:19
automation so as we have these three boards now went through the second route
29:27
it updates the data to now as you can see uh it set up the next row to pending
29:35
one and the fifth row to pending so next going to run this one we run
29:45
again again we have this board
29:52
here the dining room and it uses this board
30:00
um updates all the information and sets to pending and pending one and pending
30:07
for kitchen we're going to run this again and here it's going to happen the
30:14
magic this one's going to change to pending and it's going to run this uh
30:21
one the next time automation runs so chat GPT is analyzing the image creating
30:28
a pin and now it went through this route because it checked if we have some data
30:35
here it was empty so it returned to the start so now this one is pending and
30:41
let's now introduce uh another article of
30:46
mine let's run this once this going to change to pending and this is changed to
30:53
pending one so let's run this again
31:08
now it went through this route and the next is going to be home
31:13
decor so we run it and we didn't have home DEC or board
31:23
so it went through this route and created the board for us now it
31:29
just change this one to pending so yeah sorry that the video was
31:36
interrupted for the last couple of minutes uh yeah so that's the automation
31:41
um to automate your Pinterest um completely by creating uh
31:47
boards checking if the board exists um making some logical thinking
31:53
in Google Sheets to diverse the pins you are making so if you have any questions
31:59
just leave a comment down below I will get back to you I hope to see you soon thank you