0:00
hey everyone my name is Janice and in
0:01
today's video I want to share with you
0:03
how you can save Make.com operations
0:05
make.com is a no code automation
0:07
platform if you use it you probably use
0:10
Google Sheets modules as well one of uh
0:12
the most operation consuming modules is
0:15
the add row module because um for every
0:19
addited row it uses one operation so
0:22
let's say here I have created three
0:25
different ways how you can add uh rows
0:27
to your Google sheet here I have an RSS
0:31
feed module this is just for showcasing
0:34
you so I'm going to run this RSS feed
0:37
module and it's going to return me 25
0:39
bundles so let's say I want to add
0:42
information from every bundle as a new
0:46
row so I would add 25 rows i have
0:50
created a spreadsheet it's a simple
0:52
spreadsheet i'm going to take title and
0:54
URL from this module and add to Google
0:57
Sheets module so I'm going to connect
1:00
these two here in a Google Sheets module
1:02
i have selected the title is uh RSS
1:06
title and the link is RSS link from this
1:09
module and I'm going to click run once
1:12
and as you can see it is going row by
1:16
row editing all the information
1:19
here and it's going to take me 25
1:22
operations plus that one operation which
1:25
I don't think doesn't count uh the
1:27
trigger operation but anyway it takes 25
1:30
operations let's say imagine it would uh
1:34
be 1,000 rows it would use 1,000
1:37
operations personally I don't use it
1:40
this way and I save,000 2,000 3,000
1:44
operations per month this way by doing
1:46
it a little bit differently so the other
1:49
method to do it is by making an API call
1:53
here you will need to uh call a specific
1:58
URL and this URL uh goes like
2:02
spreadsheets uh and then this is your
2:04
spreadsheet ID which you can get uh from
2:08
here after the d slash uh this this is
2:13
the spreadsheet ID if you copy it and
2:17
you paste it here so you add your
2:20
spreadsheet ID then it goes like values
2:23
um this is um the sheet name
2:27
here this is what you have here so for
2:30
me it's sheet one so we have sheet one
2:32
in the URL a1 is uh basically um where
2:39
uh from which column to start so let's
2:42
say if I put it here B1 is going to go
2:45
from B column and append is so that it
2:50
adds uh data below the existing data in
2:54
sheets not overrides it and the value
2:57
input option row is that we don't do any
3:00
edits to the um uh to the text that we
3:04
are putting in so how we use it um here
3:08
we need to have a method post and then
3:10
we need to have a header content type
3:13
application JSON and we're going to
3:15
input a JSON so the JSON consists of
3:18
curly brackets values square brackets
3:21
and here is the actual content that we
3:23
are pushing into and this content is
3:26
coming from a text aggregator module and
3:29
just the closing um brackets and that's
3:33
it so how to aggregate the fields that
3:38
we need so I'm going to move this timer
3:40
here so basically these two are all the
3:42
same we need to aggregate um the fields
3:47
of title and URL into uh square brackets
3:51
and every variable should be in its own
3:54
semicolons each of them represents a
3:57
column so if I add here comma space and
4:00
let's say I want to add date updated
4:08
semicolons and we separate these all
4:12
with comma and space uh we don't add
4:16
comma after the last one so I'm going to
4:20
this like I had here before and we need
4:24
to change the row separator to other and
4:28
just add comma here so I'm going to show
4:31
you how it works without me posting to
4:35
uh Google Sheets at the moment so I'm
4:38
once and as you can see this one takes
4:41
one operation and this one takes one
4:43
operation but what it does it combines
4:45
the values from all these 25 bundles
4:48
into one long text string that is
4:51
properly formatted for uh Google Sheets
4:54
API call as you can see all these um
5:02
to have like this so all these fields
5:06
commaepparated yep let's close this and
5:10
let's see here as I mentioned before it
5:14
operations and here we going to
5:19
have two operations and that's it and if
5:22
I go to my Google sheets uh you can see
5:25
we have added another 25
5:28
rows and if I would like to add more
5:31
details from my RSS feed module I just
5:35
going to add comma semicolon and select
5:39
let's say date updated click save click
5:44
run once and now in column C I have the
5:49
date updated but as you saw we used only
5:54
three operations on 25 entries and it
5:57
doesn't matter if we have thousand
5:58
entries we're going to use still three
6:01
operations but if we use only this add a
6:05
row module we would use thousand
6:06
operations so that's a big difference
6:08
three or,000 operations and there's
6:11
another way how to do this there is a
6:14
built-in um Google Sheets module bulk
6:18
add rows we need to again find the
6:22
spreadsheet ID i already show you how
6:25
you can do it and then we just select
6:29
sheet we select column range and here
6:34
where we have rows uh we add array i'm
6:38
going to show you how to set this up uh
6:40
but basically it takes the data from
6:42
array and adds it to Google Sheets this
6:46
is uh easier uh than doing u text
6:50
aggregator and making an API call
6:52
because you don't have to uh do any of
6:55
these coding but here let's say you want
6:58
u uh one row in bold you can do it via
7:02
API call you can do uh different kinds
7:05
of things uh with an API call that you
7:08
can't do with bulcad rows so um let's
7:14
one and here again it added 25 rows with
7:21
operations um let's just uh I'm going to
7:24
show you how you can do this um from
7:27
scratch so let's clone this
7:29
one uh let's add an array
7:33
aggregator here we're going to have
7:36
source module our RSS module
7:39
uh we're going to select uh title and
7:43
URL because these uh these are the uh
7:47
fields that we want to take from our
7:49
bundles from RSSP uh module and then uh
7:53
we're going to add Google Sheets
8:02
advanced we're gonna have our um
8:04
connection and then we just as I
8:07
mentioned before come here copy the
8:10
spreadsheet ID paste it here um it's
8:14
going to find the spreadsheet you can
8:16
select the sheet name just untuggle this
8:19
map thing then you can select the column
8:22
range is uh A to Z and the rows this is
8:27
the array of data to be added and we're
8:31
going to select this array and we're
8:33
going to keep it unforatted there are
8:36
some advanced uh settings that you can
8:40
adjust for example you can override
8:43
existing data like from the you always
8:47
override what you have on your sheet or
8:49
you can insert new rows and this you can
8:52
leave user entered click save
8:56
then come back to your array aggregator
8:58
module and you can you see this field
9:02
target structure type you can access it
9:06
after you have set up the Google Sheets
9:09
book add rows module like I done just
9:11
now i'm going to click here for rows and
9:15
then I can add the values to the rows so
9:19
column one this is usually column A uh
9:22
we're going to have our
9:24
title and column B we have going to have
9:29
URL we're going to click save run once
9:35
operations uh 25 new rows so this will
9:39
always use three operations it doesn't
9:41
matter if you have 10,000 rows or
9:44
thousand rows that you need to add
9:46
you're going to always use three
9:48
operations and that's a big difference
9:50
from uh comparing to this other row
9:53
module that is usually used by most of
9:58
the users if you find this video helpful
10:01
please subscribe to the channel if you
10:03
have any questions leave a comment i
10:05
will get back to you my contact details
10:08
are in the video description i hope to
10:10
see you in the next video thank you for
