TLDR: I’d like Zapier to search google drive for a client name, if not found, create a client folder, then create a sub folder for the project, then create two more subfolders within that project folder.
Workflow Envisioned:
- Client submits form to Monday.com
- Form triggers Zap
THEN
- Zapier formats the info from the form fields First & Last Name (using formatter) to ensure both names are capitalized correctly.
- Then Zapier combines the first and last name, and returns that to a Monday.com column.
- Using the combined names column, Zapier then searches google drive to see if the client has already worked with us. If not it creates a client folder using their name and returns that URL to a Monday.com column.
- Once this client folder is created I’d like Zapier to create a project folder (using the project title found in Monday.com) and return that URL to Monday.com
- Once that project folder has been created, I’d like Zapier to create (2) subfolders in it, named “Materials” & “Media”.
What do I have so far?
I have completed step 3, but I am unable to create subfolders. When I am able to make a subfolder, instead of being in the project folder, it ends up in the root directory of the shared drive.
Does anyone know how to make subfolders or a workaround for doing so?
Thanks,
-Alex


