How to create a trigger for a new file in a Google Drive folder AND subfolders

[marcocevoli]

Hi,
I'm trying to accomplish the following:

1- My workflow starts when a new video file is uploaded into a subfolder of a main Google Drive folder.
2- I'd like to get the new file details and append a new line to a different Google Sheet depending on the subfolder the new file has been uploaded to (let's say we have 3 subfolders, Italian, Spanish, English, or it, es, en). If the new file is uploaded to the Italian folder, I want to append a line to the "Italian" Google Sheet, and so on.
3- Then the video file is passed to an online transcription service, specifying the language - again - depending on the subfolder.
4- Finally, for each new file, I'd like to receive an alert on Mattermost.

I've already created a workflow that does 2, 3 and 4, but the trigger is a Google Drive step, that is, the workflow starts only if I specify a folder, not its subfolders. I thought I can use iteration and then a router step, but I'm not sure how to set them up.

Could you point me to the right solution?

If it's not clear, just let me know and I'll try to better explain.

Kind regards and TIA,

MC

 

[Pabblymember11]

Hey @marcocevoli

To fetch the subfolder from your Google Drive you can use " Google Drive: Get Sub Folders of a Folder " and place it after the trigger.

Kindly try this at your end and let us know if that works.

 

[marcocevoli]

Yes, this works, and I can even put an Iterator step after that to execute actions for each folder, BUT... I don't see any way to trigger a workflow AFTER you have retrieved the subfolders. You can't add a trigger for each item of the iterator, can you?

So, if you need to execute different actions depending on the subfolder, how can you do?

 

[Pabblymember11]

Hey @marcocevoli

You need to create separate workflows according to your subfolder for individuals (Italian, Spanish, English).

 

[marcocevoli]

So, there is no way to check new files in a folder and its subfolders? Right now, anytime a user uploads a file into a language folder, a new subfolder is created.

 

[Pabblymember11]

Hey @marcocevoli

You can use "Google Drive: New File" as a trigger event which will take every new file entered in your Google Drive but then you can use the Filter action step which will only allow the file to process which is coming from your specific Id works same as a specific subfolder.

Kindly try this at your end and let us know if this works for you.