0:00
if I check this checkbox it will trigger
0:02
a web hook that will start the scenario
0:05
make.com it will send a row number
0:08
column a value column B value column C
0:10
value it will give me the status of the
0:13
scenario and once it's done it's going
0:15
to show here done so let's try it
0:23
out as you can see the automation is
0:26
running once it's finished this will
0:36
hey my name is jiannis and in today's
0:38
video I'm going to show you how you can
0:39
start your meg.com scenarios straight
0:42
from your Google Sheets documents
0:45
without need to go to make.com click run
0:49
once you can just take a checkbox on
0:51
your Google sheet trigger a web hook
0:54
send the data from the current row and
0:57
start this and start the workflow I'm
1:01
going to show you around so basically uh
1:05
when I enter data in column a column B
1:13
will give me a checkbox here so let's
1:16
try it let's type here make.com this is
1:26
description uh here I'm going to write
1:33
and as you can see it automatically adds
1:36
checkbox here and if I check it it will
1:38
run the scenario if I delete value from
1:42
here the checkbox will disappear meaning
1:47
are mandatory for the checkbox to appear
1:51
this is all set up with Google Apps
1:53
scripts I'm going to show you how to do
1:55
it uh also if I uncheck this checkbox I
2:00
can rerun the scenario once
2:03
again so to make this you simply need to
2:10
Sheets uh file new new spreadsheet so
2:15
we're going to start over and I'm going
2:16
to show you how you can do it so let's
2:20
set up everything like I have here it's
2:37
execute and this is this is going to be
2:39
status we're going to receive updates if
2:42
the scenario is running Etc you can uh
2:48
update this however you want so this is
2:53
bold uh then what we're going to do is
2:57
we're going to go to Tool tools uh sorry
3:03
appscript this will open a window for
3:05
you where you can add a code then we're
3:11
GPT uh we're going to write a message
3:21
need right so this is the
3:27
um I'm going to have it in
3:31
um the video description or the comments
3:35
section you will find it uh you can
3:39
adjust it to whatever you need for for
3:42
example in this scenario I need the
3:44
checkbox to appear in column D but you
3:47
can write here let's say column G or
3:53
can set the conditions in this prompt as
3:58
want okay so so uh chpt now going to
4:07
script uh he's just explaining what he
4:09
what he's going to do and here is the
4:13
function that's going to do this for
4:19
us okay so we're going to copy this head
4:25
Sheets sorry to the app script we're
4:27
going to paste here what JB wrote to us
4:30
we're going to REM rename these fields
4:34
so it's easier for us to map them out um
4:38
in make.com so this is going to be
4:41
keyword this going to be
4:47
description and this will be
4:52
email and now I'm going to go to
4:56
make.com I'm going to go to scenarios
4:58
I'm going to create new
5:01
scenario and I'm going to click on web
5:03
Hooks and I'm going to choose a custom
5:08
hook I'm going to add new web hook this
5:11
is going to be my uh Google
5:18
hook I'm going to save it and I'm going
5:20
to copy this URL by clicking this
5:23
button now I'm going to head back to the
5:27
app script Tab and as you can see CH gbd
5:31
here um wrote that I need to replace
5:34
this with the actual web hook URL so I'm
5:37
going to paste the URL
5:40
here and that's it that's all you have
5:43
to do here you can click on
5:46
Save uh after that you need to go to the
5:50
trigger tab um to triggers here and you
5:54
need to add a trigger and this is going
5:57
to be onedit function
6:00
and the even type is going to be on edit
6:03
and we're going to click on Save and
6:05
once you click on save this important
6:07
part it's going to ask you to sign in
6:13
account uh my my Google account is this
6:16
one so I'm going to use that and once
6:18
you see this message don't click back to
6:21
safety but click on Advanced scroll down
6:27
project uh yeah and now you need to
6:30
allow this project to access your uh
6:37
spreadsheets I'm allowing that and it
6:40
should create the trigger
6:43
now okay so what what we're going to do
6:49
to check if this works so we're going to
6:52
firstly rename the spread sheet to
6:54
m.com video web hook or whatever you
6:59
want so this will be keyword will be
7:03
YouTube description will be web
7:06
hook and my email will be
7:17
automatc and now as you can see the
7:19
checkbox appears here let's go to our
7:23
scenario that we just created with the
7:25
web hook we're going to click on Save
7:26
and we're going to click on run once to
7:29
see if the web Hook is
7:32
working okay so let's click
7:39
execute let's head back to and you can
7:42
see here we have our row number keyword
7:45
description and email so how to add
7:48
status updates we're going to have a
7:52
plus sign here go to Google Sheets
7:56
update a row uh we need to find our
7:59
spreadsheet which is make video make.com
8:09
then we need to select the sheet one we
8:14
and the row number we're going to select
8:15
from our web hook response it's going to
8:17
be row number and here where the status
8:20
is I like to write is uh
8:30
and just for the um just the Showcase
8:34
how after this part you would have your
8:37
own scenario I'm going to add a sleep
8:41
timer and just for five
8:47
um to show you how it works so in the
8:51
place of the sleep timer you would have
8:53
your own scenario which you usually go
8:55
to m.com and Trigger by clicking run
8:59
but this in using my method you can run
9:03
it from straight away from Google Sheets
9:05
without need to go to
9:07
make.com and we just going
9:12
module add it after the Sleep module and
9:16
just change the status to
9:20
done okay and we can click
9:23
save uh we can uh switch this on
9:33
on and let's head to our
9:37
spreadsheet uncheck this check box and
9:41
let's uh check it again and this time it
9:45
should show the status scenario running
9:48
and after 5 Seconds it should change to
9:51
done yeah so if I now delete this
9:56
description the checkbox will disappear
10:02
uh whatever U meg.com
10:06
and we're going to have the checkbox
10:09
again in the next row if I add um JS
10:15
automate here description
10:22
email uh the checkbox will appear here
10:27
it and now now it's going to send the
10:30
values of this Row three to uh make.com
10:36
run the scenario and return the status
10:41
done so yeah uh I will have this
10:45
um uh prompt for Jud for Jud gbt in
10:52
description and hopefully
10:56
this um hope hopefully this uh little
11:00
video will save you time going to
11:04
make.com if you have some scenarios that
11:08
manually uh and you use Google Sheets
11:12
you can run the scenario straight from
11:14
your Google Sheets without needing to
11:16
log into to me.com account and to run um
11:21
the workflow for me I use it personally
11:24
I save time um and uh I don't visit mag
11:29
come that much often because I can do
11:33
everything from my spreadsheet so if you
11:35
find the video helpful um make sure you
11:38
subscribe like the video uh in case you
11:41
need help with your automations get in
11:44
touch with me my email my contact
11:48
description uh I hope you have a great
11:50
day thank you for watching see you in
11:52
the next video bye-bye
