# Never Manually Upload to Etsy Again - My Secret Make.com Automation Workflow (FULL Breakdown)

https://www.youtube.com/watch?v=ifbs5v5mP64

[00:00] Hello guys, I'm Andres from Scale Your
[00:02] Pot. Welcome to another video. And in
[00:04] this video, we are going to build an
[00:06] Etsy automation that will run on
[00:10] make.com, a no code workflow platform
[00:13] that will allow you to pretty much uh
[00:15] automate completely your digital
[00:17] listings uploads.
[00:19] So, uh to follow along, you're going to
[00:21] need a make.com account. If you don't
[00:24] have one already, I'm going to leave a
[00:26] link in the description below so you can
[00:28] sign up and follow along. So, uh, one of
[00:31] the biggest advantages of mega.com over
[00:34] other, uh, similar platforms is that it
[00:36] has a free tire that will allow you to
[00:40] test this, uh, right away without
[00:42] submitting any payment info. So uh
[00:45] without further ado, let's take a look
[00:47] at uh the workflow of this scenario
[00:52] uh so you can understand how it goes and
[00:55] processes uh the info without getting
[00:58] into the uh fine details right away. So
[01:02] uh once you have uh your make.com
[01:04] account, you are going to land on a page
[01:07] similar to this one. You just uh need to
[01:10] click on get started free uh sign up and
[01:14] then once you are uh ready uh you need
[01:18] to go to the left tab click on scenarios
[01:22] and build uh a new scenario. You're
[01:24] going to see the bottom uh the button
[01:27] right uh here. So uh once you're ready
[01:31] you are uh ready to start building your
[01:34] scenario. Let's go ahead and take a look
[01:36] as I was saying how this works. So, uh,
[01:39] this, uh, in order to work, you're going
[01:41] to need, uh, a folder, two folders. One
[01:44] folder with subfolders that includes the
[01:47] files you're going to, uh, send to your
[01:50] listings. We're going to call this, uh,
[01:53] the pending uh, depending uh, products
[01:56] folder where you're going to, uh, store
[01:58] all the files that are going to go
[02:01] through this uh, upload scenario. And
[02:05] you're going to need also an uploaded
[02:07] folder where this uh workflow is going
[02:10] to move uh these subfolders into these
[02:13] uploaded folders. So uh it is always uh
[02:17] organized. So uh it starts with a Google
[02:22] Drive module that searches for the
[02:24] subfolders uh that are going to be
[02:27] processed through this workflow. Then uh
[02:30] we have a Google Sheets module that
[02:33] pretty pretty much is a list uh of the
[02:36] of the products that you are going to
[02:39] upload. We're going to see in more
[02:41] detail in a second. So uh this list uh
[02:44] is going to run against uh the Google
[02:47] Drive module that is going to uh search
[02:49] for the folders using this sheet and
[02:52] it's going to complete the product uh
[02:56] details using al as well the columns of
[02:58] the sheet. Then we have a router. So uh
[03:02] the router has two parts. Uh, one of the
[03:05] parts is the module that moves the
[03:09] folder of the product that has already
[03:12] been processed and uploaded. So, it
[03:14] moves it from the pending folder to the
[03:16] uploaded folder. And then we have the uh
[03:20] listing creation and listing updating uh
[03:24] modules uh I mean uh the listing uh
[03:27] creation and updating branch of the road
[03:29] uh rotor. So we first have a Google Docs
[03:34] module where we are going to store the
[03:38] product description. So uh in my case I
[03:41] always use the same product description
[03:44] where I pretty much uh explain uh the
[03:48] limits of the of the product uh such as
[03:51] that it can be resold uh the technical
[03:54] details such as uh the the pixelation uh
[03:58] definition types of files. So uh once uh
[04:03] the workflow gets the description, it
[04:05] goes ahead and create the Etsy listing
[04:08] using the description as well as the
[04:11] title and tax from the sheet. Again,
[04:13] we're going to take a look in a second.
[04:16] Uh then we have uh another Google Drive
[04:19] module that searches for files. So in
[04:22] this case, this modules is going to
[04:24] search for files inside each of these
[04:26] subfolders.
[04:28] Then we have a router where we branch
[04:31] out the different aspects of the uh
[04:35] listing creation. First of all, we have
[04:38] a branch that uploads the main uh
[04:42] thumbnail to the listing. We also have a
[04:44] branch that uh uploads the files that
[04:48] the customer is going to get once he or
[04:51] she purchases the listing. We have a
[04:53] branch that uploads the video to the
[04:56] listing. And we have a branch that
[04:58] uploads the secondary images to the
[05:00] listing. And finally, we have some uh
[05:04] sleep modules here that pretty much uh
[05:07] are there to uh protect us against uh
[05:11] the accumulation of a calls. So for
[05:14] example, say that uh the the workflow is
[05:18] uploading uh the listing photos and it
[05:21] hasn't finished uploading uh when uh
[05:25] this branch the video branch has already
[05:28] uh started. So uh the files could uh
[05:32] converge and create an error. So we
[05:35] create these uh modules here to uh give
[05:39] uh each branch a second or two to
[05:41] finish.
[05:42] So that is pretty much uh the logic of
[05:46] this workflow. So let's go ahead and
[05:48] take a look at each module. So in order
[05:50] to get started, you're going to need
[05:52] this Google Drive module. In order to
[05:55] create a module, you just need to uh
[05:57] rightclick add module.
[06:00] And in this case, uh search for Google
[06:02] Drive. In my case, I already have it
[06:04] here at the top. And once you have it uh
[06:09] you need to go for the search for files
[06:11] and folders module. So I'm going to
[06:13] delete this because I have already
[06:15] created here. So let's see how this is
[06:18] set up. Uh in order to uh get started
[06:22] here, you're going to need uh to add
[06:24] your Google Drive account. So uh the
[06:27] integration is pretty easy. You just
[06:29] need to uh to select uh the Google Drive
[06:33] here, the Google Drive account uh and u
[06:37] make.com is going to prompt you to sign
[06:40] up to the account you're going to use.
[06:42] And once you have that ready, it is
[06:44] integrated and you'll see these fields
[06:46] below. So in my case uh in these models
[06:50] as I said uh I pick the the folder where
[06:56] I have the subfolders of the products
[06:58] that are going to be uploaded. In my
[07:00] case that folder name is Etsy pending.
[07:04] So we are going to retrieve folders.
[07:07] Remember that we we are looking for
[07:09] subfolders here. And we're going to
[07:12] leave search empty because we just want
[07:14] uh the module to uh grab whatever is on
[07:16] the folder. And for the limit uh here I
[07:20] have set three just for uh example
[07:22] purposes. But you can set whatever you
[07:24] want. Uh just remember that the the
[07:28] higher the number is the longer it's
[07:30] going to take for the scenario to uh
[07:32] finish.
[07:33] So once you have that ready you click on
[07:35] save. Then again you need to create
[07:38] another module. Remember that for this
[07:39] you have to click on uh you have to
[07:41] right click and click on other module.
[07:43] In this case you're going to search for
[07:46] Google Sheets and specifically for the
[07:50] search rows module this one right here.
[07:54] So this module uh is going to be linked
[07:57] to one of your uh Google Sheets. So
[08:02] again here you're going to need to
[08:03] integrate your account. It's a pretty
[08:06] straightforward process. You have to
[08:07] just sign up and you're ready. So once
[08:10] you have uh your integration going uh
[08:13] from the search method, you're going to
[08:15] put select from my drive uh here on the
[08:19] uh spreadsheet ID. You're going to
[08:22] search for uh your specific uh Google
[08:26] sheet that you're going to use. Once you
[08:28] put this here, you're going to see once
[08:30] you click, I'm sorry, on the arrow here,
[08:32] you're going to uh see a list of your uh
[08:36] of your Google uh sheet files. So, uh
[08:40] you just need to search here for the one
[08:42] you're going to use. Uh and uh for sheet
[08:46] name, you're going to use the sheet uh
[08:49] that uh you're going to be working on.
[08:51] Probably sheet one like uh in my case
[08:53] here.
[08:55] For the table contains headers option,
[08:57] you're going to put yes. Again, we're
[08:59] going to take a take a look at the sheet
[09:01] that I use uh in a second. For column
[09:04] range, just leave it as it is a 2 to CC.
[09:09] So, uh filter before that let's go ahead
[09:12] and take a look at my Google sheet.
[09:16] So, uh this is the sheet that I'm using.
[09:18] Again, you can use this exact uh format
[09:23] or you can change things around
[09:25] depending on your use cases. But for me
[09:28] and for the scenario that I'm going to
[09:30] explain, this works uh just fine. So,
[09:33] you're going to have on column A uh the
[09:36] column of the folders that I have named
[09:39] it folder name. You're going to have a a
[09:41] titles column, Etsy title, and you're
[09:44] going to have a tax column with Etsy
[09:46] tax. So remember that the description uh
[09:49] is taken care of by the
[09:52] uh Google Docs model here. So that's why
[09:56] we don't have it uh here on the uh
[09:59] sheets. I'm sorry. So why is that?
[10:03] Because as I said, I like to make uh my
[10:05] descriptions uh very detailed. So uh for
[10:09] formatting purposes, that looks much
[10:11] better on um a Google Docs uh file.
[10:16] Uh as and as I said as well I pretty
[10:20] much always use the same description.
[10:22] So uh I can just have one file for that.
[10:26] So uh this is the format that we're
[10:29] going to use for our uh uploader
[10:33] spreadsheet.
[10:34] Now uh let's go back here.
[10:37] So
[10:39] we're going to have a filter set with
[10:42] folder name. So what this means? This
[10:44] means that basically uh the sheet is
[10:47] going to use the name of the folder as
[10:52] uh the source of information. So it's
[10:54] going to search for example in my case I
[10:56] have two uh two type of products. Uh
[10:59] it's going to search for cute Halloween
[11:01] cow and if it's there it's going to map
[11:04] it to the rest of the columns. It's
[11:07] going to search for Halloween squad and
[11:09] if it's there, it's going to tie that up
[11:12] with uh the rows next to it.
[11:15] So, uh that is for filter. You're going
[11:18] to select the folder name column. And
[11:21] here you're going to select the text
[11:22] operator that is equal to name. So, in
[11:26] this case, what is name? This is the
[11:29] name of the folder. Remember? So uh one
[11:33] cue of that is that if you uh select
[11:36] here name you're going to see uh a bit
[11:39] here on the Google drive module that
[11:42] means that the data is coming from this
[11:45] module.
[11:47] So once you have that set up uh you can
[11:50] leave the rest as is. You're going to
[11:52] click on save. Now you need to insert a
[11:55] router. So for that again uh you always
[11:58] have to right click add module and
[12:01] you're going to search for router
[12:04] and once you have it there you just have
[12:06] to uh put it close to the Google sheets
[12:08] module and it's going to link up
[12:10] automatically. So, so from that router
[12:13] you are going to route uh right click
[12:15] and add a route first for the
[12:19] uh for the the branch that moves the
[12:22] subfolders that have been already
[12:24] uploaded and another route for the
[12:27] branch that takes care of the uh listing
[12:30] creation process. So let's first take a
[12:34] look at this uh branch the branch that
[12:36] moves the folder to the uploaded uh uh
[12:39] folder. I mean the branch that moved the
[12:41] subfolders to the uploaded folder.
[12:45] So remember that uh you have already
[12:47] created your Google Drive uh
[12:49] integration. So you won't need to do
[12:51] that here. Now uh let's see how to fill
[12:55] this up. So for choose a drive you need
[12:57] to always use
[12:59] uh the option my drive unless you're
[13:01] using a share drive.
[13:03] For uh select folder file or folder
[13:06] again we're going to use folders.
[13:09] Remember that this model moves
[13:10] subfolders. So here we need to select
[13:13] folder.
[13:16] Uh for folder ID
[13:19] we just need to map the folder here. So
[13:23] let's first collapse this. So we need to
[13:26] find the the the
[13:29] file ID
[13:31] of the folders that are retrieved in
[13:34] this module. So here we're going to
[13:36] search for file ID. So again remember
[13:39] that we are looking for folders. Uh
[13:42] since this module is only retrieving
[13:44] folders the file ID the file ID will
[13:47] correspond to the subfolders retrieved
[13:49] here. So uh don't get confused by this.
[13:51] You need to put the file ID uh data
[13:54] source here.
[13:57] And uh new drive location. We're going
[13:59] to select my drive unless you want to
[14:01] move it again to another drive a share
[14:03] one for example. And the new folder
[14:05] location for me, it it is a folder that
[14:08] I've named Etsy uploaded. Uh that is
[14:12] outside
[14:13] uh of the folder where I have the
[14:16] subfolders of the products on. Uh so
[14:19] here we are going to click on save.
[14:21] Nothing more to touch here. And for the
[14:24] branch that creates the listing. So for
[14:29] the product description,
[14:31] you're going to need an integration here
[14:33] as well. uh get the content of a
[14:36] document by dropdown. Choose drive, my
[14:38] drive again. So uh for the document ID,
[14:41] you're going to also be able to search
[14:42] for the specific Google doc you are
[14:44] going to use. So you you just first need
[14:47] to fill this up. And once you have that
[14:49] file ready, you can retrieve it here.
[14:52] Include types of content. No. So this
[14:54] one is pretty straightforward. You just
[14:56] have to set this up like is like this
[14:59] and hit on save. Now, uh, you're going
[15:02] to click again, right click. Remember,
[15:04] always add a module.
[15:07] Oops, I'm sorry. Let's delete this. Add
[15:11] a module.
[15:12] You're going to type Betsy and you're
[15:14] going to see this one here. So, for
[15:16] this, you're going to need to create an
[15:17] integration as well. And once you have
[15:20] created the module, you need to click on
[15:22] create a listing and connect it with the
[15:25] get description uh module here.
[15:29] So once you have that ready,
[15:33] you uh are going to need to map uh the
[15:36] different fields that are going to be
[15:38] used for this listing. So for title, we
[15:40] are going to map the Etsy uh title
[15:44] column. So again, remember this one here
[15:47] and it's going to come from the module,
[15:50] the Google module that is already
[15:51] beating. Can you see right there on the
[15:53] left? So you need to click here. Let's
[15:57] collapse this to have
[15:59] a closer look at the gulches module.
[16:03] You're going to map it to the column B
[16:06] which is Etsy title right here. For the
[16:10] description, remember that you will need
[16:12] the uh info you have on your Google doc.
[16:16] So for that you're going to map text
[16:19] content
[16:21] that is right over here.
[16:24] So this uh takes the data from uh your
[16:27] Google doc and puts it on the
[16:29] description of the listing. Now for
[16:31] quantity uh that depends of course on on
[16:34] your use case. In my case I always use
[16:37] uh the same uh number and price here for
[16:40] all my uh digital listings. So for
[16:43] quantity I have set 100. For price I
[16:46] have set it to 3.99. Who made this
[16:49] listing? I did when it was made 2020 to
[16:53] 2025. Uh for taxonomy, I always use art
[16:56] and collectibles for my digital
[16:58] listings. Type download, of course. Uh
[17:02] make sure to set this correctly.
[17:05] So, uh shop section ID. You're going to
[17:08] need this as well. In my case, I have a
[17:10] section called PNG digital files. For
[17:14] minimum processing days and maximum
[17:15] processing days, I just set one. Now for
[17:19] tax, this is very important. Uh we're
[17:21] going to need a formula here and we're
[17:24] going to map it to our Etsy tax uh
[17:28] column. So this is the column. Now take
[17:32] a closer look here. I have my tax comma
[17:35] separated without any space.
[17:38] And that is very important in order uh
[17:40] for the create listing module to grab
[17:43] the tax and split them correctly. So
[17:45] again to use this function here such as
[17:49] it is you're going to need your tax
[17:52] comma separated without any space
[17:54] between them. So in order to use uh this
[17:57] formula you you can just uh type this
[17:59] here uh split. Let me show you
[18:04] split.
[18:07] And as you can see uh uh make.com uh
[18:11] inputs the correct formula the formula
[18:14] automatically. So you click inside the
[18:17] parenthesis.
[18:20] Let's collapse all and again search for
[18:23] the Etsy tax
[18:28] and like so.
[18:31] So, uh for styles, we're not going to
[18:33] use any of these
[18:35] of course because this corresponds to
[18:37] physical items in personalization. I set
[18:41] that as no.
[18:44] Uh is supply yes. Customizable no.
[18:47] Should auto renew? That's of course up
[18:49] to you. I just uh use no here because I
[18:53] like to have uh a closer control of my
[18:56] uh digital listing products is taxable.
[18:59] I'm going to leave that as empty. We're
[19:01] going to click on save. And next we have
[19:04] a Google Drive module again but in this
[19:07] module instead of retrieving uh folders
[19:11] we're going to retrieve files. So what
[19:14] this module does is grab the files of
[19:17] the subfolders retrieved here and pass
[19:21] them through the branches that uh adds
[19:24] the content to the listings uh
[19:26] specifically the photos the video and uh
[19:29] the files that the customers are going
[19:30] to get once they purchase. So as always,
[19:34] right click, you search, and in this
[19:36] case, you're going to search again for
[19:37] the search for files and folders subm
[19:40] module. Excuse me. So uh the select
[19:44] method enter manually. Now folder ID,
[19:48] we're going to use
[19:50] again. Let me show you. See how the
[19:53] first module is beating. We're going to
[19:54] use the folder ID gra uh from the module
[19:59] that retrieves the subfolders here.
[20:02] So for that let's collapse all. We're
[20:06] going to use the first uh Google drive
[20:09] module we have used
[20:12] and we're going to use the file ID right
[20:14] here. We're going to map it. The share
[20:16] drive ID
[20:18] uh is also here.
[20:21] Let me try to find it right right here.
[20:27] Okay. So let's collapse all to have
[20:32] a cleaner look. So, you probably saw
[20:35] that before me.
[20:37] But anyway, it's over here. It should be
[20:40] here at the top, I guess.
[20:44] So, I I think I'm a bit blind right now
[20:47] because I can't ah right here. F Drive
[20:51] ID. You need to map it over here. Now,
[20:55] uh once you have that set up, uh you're
[20:57] going to retrieve files, not folders
[20:58] this time.
[21:00] uh you are going to leave search empty
[21:02] and for the limit that depends on the
[21:04] number of files you're going to have per
[21:06] folder. Uh in my case for uh testing
[21:10] purposes and to show you guys how how
[21:11] this works I only have uh I think around
[21:14] five files. So I'm going to leave that
[21:16] as 10 to have some margin. We're going
[21:20] to click on save. And now you need to
[21:22] create another router. So, uh, let's
[21:25] first take a look at the router, uh,
[21:28] that uploads the main thumbnail right
[21:33] here. So, you're going to create in this
[21:35] case another Google Drive module, but
[21:38] you need to search for the download
[21:43] file mo download a file module right
[21:45] here. So, we're going to connect that
[21:47] with a router. So, remember that you
[21:49] need to add branches first.
[21:52] So uh how we set it up?
[21:56] You are going to uh select enter
[21:59] manually for the enter file ID. Now uh
[22:02] here file ID you're going to map it to
[22:06] this module right here.
[22:08] See how that module is speeding up. Let
[22:11] me take
[22:13] right there. You're going to map it to
[22:15] the file ID from this module. So what
[22:18] are we saying here? that uh we're going
[22:20] to pass files through this router and
[22:23] we're going to download a specific file
[22:26] right here.
[22:28] We're going to click on save. So, you
[22:30] might be wondering uh but we are
[22:33] retrieving several files files from this
[22:35] model. So, how do we make sure that the
[22:38] correct file passes through each branch?
[22:40] Well, uh make.com makes it easy with the
[22:43] filters. In this case, each branch of
[22:46] the router, as you can see, has a
[22:48] filter.
[22:49] This one doesn't have any filter. We are
[22:52] going to have filters right here. Now,
[22:55] for the branch that takes care of the
[22:57] thumbnail. In order to add a filter, we
[23:00] need to right click on the uh router
[23:02] branch and set up a filter. So, what do
[23:06] we want here? We want that the file
[23:10] uh named thumbnail png where I'm going
[23:12] to show you uh right now how I have that
[23:15] set up uh that the file named thumb png
[23:20] passes through this branch and only that
[23:22] file that is my condition for this uh
[23:26] branch. So by set setting this up
[23:30] remember that this is a text operator
[23:31] because you're going to uh match against
[23:34] a specific string in this case thumbnail
[23:37] png. By setting this up you make sure
[23:40] that only the file thumbnail png passes
[23:44] through each through uh this branch.
[23:48] So uh before advancing any further let
[23:50] me show you what I mean with that.
[23:53] Okay. So, uh, here I have an example of,
[23:56] uh, a listing subfolder that I'm going
[23:58] to use. So, in order for this workflow,
[24:02] uh, to, uh, work correctly, you're going
[24:05] to have to name each file
[24:07] conventionally,
[24:09] uh, with specific names. For the
[24:11] thumbnail, uh, the branch we have just
[24:14] seen, you're going to have to name the
[24:16] file thumbnail PNG. Of course, you can
[24:19] name it any way uh you want it, but you
[24:21] need to make sure that you use the same
[24:23] name for the thumbnail across all your
[24:26] subfolders. So, the thumbnail, PNG file
[24:29] is the main uh thumbnail of the listing.
[24:32] I also have a PNG file and PDF file that
[24:36] are going to be the files that the
[24:38] customer is going to uh access once he
[24:41] or she purchases the the product. I have
[24:46] my video named video uh MP4 and I have
[24:51] my uh mockup uh or secondary image in my
[24:54] case. I name uh my mockup images mockup
[24:58] 1, mockup 2, mockup 3. So uh we have
[25:02] that uh outside of the way. Uh now uh
[25:07] let's come back here. So
[25:11] the filter uh
[25:15] is set in such a way that only the
[25:17] thumbnail PNG file can go through this
[25:19] branch. Now once we have this ready, we
[25:23] need to set up another Etsy module that
[25:26] is going to branch off uh this download
[25:28] a file Google Drive module. So again, we
[25:32] need to add a module.
[25:34] Search for Etsy.
[25:36] And in this case, we're going to update
[25:39] a listing image
[25:42] right here. Let's delete this.
[25:47] So let's set this up. Uh for listing ID,
[25:51] we're going to map it from the uh Etsy
[25:54] module that creates the listing right
[25:56] here.
[25:58] Notice again how that module is beating
[26:01] uh once I hover my mouse uh over this.
[26:05] So again collapse all here is the name
[26:09] of the module and you're going to search
[26:11] for listing ID and map it right here.
[26:14] Now for file you're going to see this
[26:16] option and you need to click on Google
[26:18] Drive download a file. Uh this pretty
[26:20] much means that it's going to get the
[26:22] file that you download from your Google
[26:25] Drive previous module.
[26:28] Uh that remember again that is the
[26:30] thumbnail PNG file. For listing image
[26:33] ID, you can leave this blank. That is
[26:35] just uh a field for Etsy uh that allows
[26:39] you to reuse images inside the platform
[26:42] if that is what you want. We don't need
[26:44] right now that.
[26:47] Uh now for rank, this is very important.
[26:49] You're going to set rank one for your
[26:52] thumbnail image. This uh tells this
[26:55] module that whatever image is received
[26:59] here, it needs to put is it needs to be
[27:01] put uh first place on the on the image
[27:05] uh carousel and that uh is going to uh
[27:09] make sure that this image shows as the
[27:12] primary image for override you just
[27:14] leave empty. And from watermarked as
[27:17] well again uh I'm going to show you uh
[27:19] that my images are already watermark
[27:22] watermarked. So you don't need that. So
[27:25] that branch is set. Now let's move uh to
[27:28] the secondary
[27:30] uh images branch right here. Now again
[27:33] we have a filter here. Let's take a
[27:35] look, right click, set up filter. So
[27:39] what I am I doing here? uh I am telling
[27:42] this branch that I only want uh images
[27:47] with these names allowed to be uh to be
[27:52] uh allowed allowed access through this
[27:54] branch. So in my case I use mockup 1,
[27:57] mockup 2 and mockup 3. I usually use uh
[28:00] three uh secondary images uh aside of
[28:03] the thumbnail. So how do I do that? I
[28:07] set up again the name. I map it to the
[28:10] name coming from this module.
[28:13] And here I say uh the name needs to be
[28:16] equal to remember text operator equal to
[28:19] mockup 1 or this is very important you
[28:22] need to add an or rule or the name needs
[28:26] to be mockup 2 or the name needs to be
[28:29] mockup 3. So what this does is that it
[28:34] allows uh the files named with these
[28:38] names to pass through. Uh now once they
[28:42] go through again we need another
[28:45] download a file uh download a file
[28:47] module and again we need to map it with
[28:50] the file ID coming from this model right
[28:54] here. Now we need to create another
[28:57] update listing image module
[28:59] that we're going to set uh right like
[29:02] the one we used at the thumbnail. We're
[29:04] going to list uh to map with the listing
[29:06] ID coming from the listing
[29:10] the listing uh the creation uh the
[29:13] create a listing module. I'm sorry.
[29:15] We're going to map it to the download a
[29:17] file module that is uh right next to the
[29:21] uh updated listing module here.
[29:24] And for listing image ID, we're going to
[29:26] leave that empty. Now, this is very
[29:28] important for rank. We are going to set
[29:30] this to two. So, this makes sure this is
[29:34] going to make sure that any image that
[29:36] goes through this branch uh even if this
[29:40] branch uh below here, the thumbnail
[29:42] branch hasn't executed yet. that any
[29:45] image that goes through this branch is
[29:46] going to be set at the rank number two
[29:49] or higher which uh is a safeguard in
[29:53] case again this branch executes first uh
[29:57] the images are going to be put on the
[30:00] secondary place and once the branch of
[30:03] the thumb thumbnail executes is going to
[30:06] put this image in first place and make
[30:08] sure it is a primary image. So, uh, the
[30:11] rest of the fields, we're going to leave
[30:13] them just as the other, uh, module where
[30:17] where we set the thumbnail. We're going
[30:18] to click on save. And now we need to
[30:22] add, uh, a sleep module that is going to
[30:26] give uh, the other branches a couple of
[30:29] seconds before executing uh, to make
[30:31] sure that the images here finish
[30:33] uploading. In order to do that, we right
[30:35] click, add a module, and we're going to
[30:36] look for sleep.
[30:40] right here. Now, uh you can just set
[30:44] here a delay of two. That is more than
[30:46] enough to allow uh your images to finish
[30:49] uploading. You're going to click save.
[30:51] Now, let's go ahead and take a look at
[30:54] the download uh listing uh the the video
[30:59] uh updating branch. We're going to set a
[31:03] a download a file Google Drive here as
[31:05] well.
[31:07] Now again we always use the file ID
[31:10] here. Remember that the drives are
[31:13] coming always from this model. But we're
[31:16] going to set a filter here.
[31:20] In this case we want uh files named
[31:23] video.mpp4
[31:24] to pass through this branch. So we of
[31:27] course always map the name of the file
[31:30] from this branch. And we say here that
[31:33] it needs to be exactly video mp4. If the
[31:37] file is named video mp4, it's going to
[31:39] pass through. It's going to download.
[31:40] And now we need a different type of
[31:43] module here. I'm sorry. So uh we're
[31:47] going to use a module called make an AP
[31:50] call. Now uh why is that? because uh
[31:54] make.com has not already has not yet set
[31:58] a module that takes care of the videos.
[32:02] So here the modules we use uh on the
[32:06] photos only handle images. So for videos
[32:09] we need to make a specific API uh call
[32:13] to take care of that. Let's see how we
[32:16] search for that again. Etsy
[32:19] make an API call. You're going to see it
[32:21] there. Just click on it and connect it
[32:23] to this model drive. Now let's take a
[32:26] look at how we set it up. Now let's take
[32:29] a look at how to set this up. Now uh
[32:32] this is going to be a bit more technical
[32:34] uh than the previous uh the previous
[32:37] modules that we have set up. But uh
[32:40] you'll see it is uh pretty
[32:42] straightforward process
[32:45] and simple enough to follow. So you need
[32:47] to type this exactly as it is. shops
[32:50] slash uh shop ID. You're going to map it
[32:52] from this module. The create listing
[32:54] module slashlistings
[32:57] slashlisting ID that again you're going
[32:59] to map from this module slash videos.
[33:04] Now for the method you're going to use
[33:07] post from the dropdown you need to
[33:09] select post. Uh from headers you're
[33:12] going to click this. So, uh, map is
[33:14] toggle off, toggle on, I'm sorry, but
[33:17] you're going to leave that empty.
[33:22] Uh, you don't need to do anything here.
[33:24] For body type, you're going to click on
[33:25] multiart
[33:27] from data. Select this from the
[33:30] dropdown. Now, for fields, you're going
[33:32] to click on add an item first. This is
[33:35] going to be, remember, this is going to
[33:36] be empty. You're going to click on add
[33:38] an item and you'll see item one. Now for
[33:40] field tap you're going to select file.
[33:44] Uh for key you're going to select video.
[33:46] And for file you're going to use the
[33:48] Google drive download file module that
[33:51] was right before this one. Remember
[33:56] we're talking about this one.
[34:00] Now you're going to add another
[34:03] item and you're going to put a field
[34:05] type text and key. We're going to input
[34:09] name and for value
[34:12] you are going to use
[34:15] the the name of the of the file that we
[34:20] got remember from this module the
[34:22] download a file module.
[34:24] You're going to click on save and that
[34:27] is done.
[34:29] And uh finally for the upload files
[34:32] module you're going to again create a
[34:35] filter in this branch. Let's right click
[34:38] and find out what uh how this this is
[34:41] set up. Now in my case
[34:45] the files that I upload for the
[34:48] customers to have access once they
[34:49] purchase
[34:51] uh are always named uh PDF file for the
[34:55] PDF file and the PNG file for the PNG.
[34:58] Now how do we set this up? We need to
[35:01] map this from the name. Remember the
[35:04] name of the files we get from here.
[35:08] We're going to say that the name needs
[35:10] to be PDF file PDF or
[35:14] PDF or the name should be uh PNG file.
[35:18] We need to use text operators for this.
[35:20] Remember it is important to use the or
[35:22] rule here not the un rule.
[35:26] Uh so once that is ready, we're going to
[35:29] make uh another API call. So we are
[35:33] going to right click and add an Etsy
[35:35] module and search for make an API call.
[35:39] And here we're going to use this URL. So
[35:43] we're going to type uh slashshops slash
[35:47] uh we're going to map it to the shop id
[35:49] from this module slashlistings
[35:53] slash listing ID again coming from here
[35:56] slashfiles remember that it is very
[35:58] important to use both here and the API
[36:01] call to upload the video to type exactly
[36:03] this without any spaces so this is going
[36:07] to give you an error make sure that you
[36:09] have one line here for the method again
[36:12] we're going to use post. Now for the
[36:14] headers,
[36:17] uh we're going to leave this toggle off.
[36:21] Now for uh the items, we're going to
[36:23] click on add item and click uh and fill
[36:26] this up right here with content type.
[36:29] The key is content type and value is
[36:32] application/json.
[36:35] Now body type is again multipart uh
[36:38] /form data
[36:40] and on the fields here we are going to
[36:43] use uh for field type file and the key
[36:47] is file
[36:49] is going to come from the preceding
[36:51] Google drive downloaded file module and
[36:54] we're going to add another item here and
[36:57] fill it in uh such as this field type is
[37:00] text and key is name and the value is
[37:03] again the name of the uh files that are
[37:08] going to pass through this branch.
[37:12] Uh we are going to add uh I think I
[37:15] didn't mention it uh in this previous
[37:17] branch, but in both branches we're going
[37:19] to add uh sleep u models as well to have
[37:24] a two second delay uh in order to allow
[37:26] for the branches to finish.
[37:29] Now uh once we have this ready, we are
[37:32] all done and we can uh start executing
[37:36] our workflow.
[37:39] So now let's go ahead and take a look at
[37:41] my draft uh liftings. As you as you can
[37:44] see,
[37:46] I have zero drafts right now.
[37:51] And I I am going to uh retrieve uh two
[37:55] subfolders.
[37:57] Let me show you the folders first.
[38:01] So, here are my two sub uh my two
[38:04] folders. My Etsy pending uh folder and
[38:08] my Etsy uploaded folder. I have my two
[38:11] uh my two subfolders here. Cute
[38:14] Halloween cow and Halloween squad. As
[38:18] you can see, they are named exactly as
[38:20] they appear in my uh Google Sheets.
[38:25] Now we're going to go ahead and click on
[38:28] run
[38:31] once.
[38:35] So uh the workflow is already executing.
[38:38] It goes pretty fast as you can see. You
[38:41] can see how each branch is working.
[38:44] It only takes a few seconds. uh if you
[38:48] are uploading a few products such as me,
[38:51] we're only dealing with uh two products
[38:53] here.
[38:55] So uh
[38:58] one product is already done. Now it is
[39:00] handling the second product.
[39:03] It is uploading the video.
[39:09] Now it is working.
[39:17] It is working in the uh upload files
[39:20] branch and it is done. Now let's go
[39:23] ahead and take a look at my drafts. So
[39:29] here let me show you first
[39:33] the files
[39:35] that I am using. So uh here we have the
[39:39] mockup that I'm using for one of the
[39:41] products. Here is the the thumbnail.
[39:45] So uh it is important that this image
[39:47] for example is uh used as a primary
[39:50] image on my listings on the respective
[39:53] listing.
[39:56] And this is
[39:58] the thumbnail that I'm going to use for
[40:01] the other uh product.
[40:05] So uh the mers the folders have moved uh
[40:09] correctly. They are both in the
[40:13] pending uh I'm sorry I'm in the uploaded
[40:17] in the uploaded uh
[40:20] folder.
[40:22] Okay. So I have my drafts here. Let's
[40:24] take a look.
[40:29] As you can see uh it did map uh my title
[40:33] correctly.
[40:35] as well as uh the main thumbnail is
[40:39] placed correctly. The video uploaded the
[40:40] mockup the mockup as well.
[40:44] The files as well the description did
[40:46] map correctly all the values that I use
[40:49] as well. So uh a caveat of this is that
[40:53] uh you can only u upload uh the products
[40:57] as drafts. As far as I know, it is not
[41:00] possible to publish them directly.
[41:03] But if you have uh set this up
[41:06] correctly, you just need to uh go to
[41:08] your draft uh page and uh just hit on
[41:12] publish and you're done. So uh it is uh
[41:17] almost completely automated except for a
[41:20] couple of clicks that you need to make
[41:21] to publish the drafts. Now, uh, let's
[41:26] take a look at the other draft. It
[41:29] should be there. Okay, here we are.
[41:33] Let's check it out.
[41:35] We can see that it did map correctly. We
[41:38] have uh the primary image set here. The
[41:41] video is here.
[41:44] The mockup as well. And the files as are
[41:47] there as well. All right, guys. Uh, so
[41:51] uh that is pretty much it. Uh, I hope
[41:54] you enjoyed the video. Now, uh, again,
[41:56] remember that uh, in order to to use
[41:59] this automation, you're going to need
[42:01] uh, your make.com account. The link is
[42:04] there in the description below. If you
[42:07] guys like this video, please uh, don't
[42:10] forget to like it. And if you are
[42:12] looking for more content such as this to
[42:15] automate your print on demand business,
[42:17] your e-commerce business or your digital
[42:20] files business, I'm going to be uh
[42:24] putting out a lot of content uh related
[42:27] to automations and AI. So don't forget
[42:30] to subscribe to be up to date with with
[42:32] my content. Thank you for watching and
[42:35] see you next time.