First post and also a total Zapier n00b, so apologies if this is a simple question :)
I’m building Crew, group, cohort-based coaching app that helps people design awesome careers by pairing them with a small group + an executive coach.
I’ve built the app in Adalo but a lot of the work that happens during the group coaching sessions is done using Google Docs. We currently run everything out of Drive with a simple folder/file structure in place. I’m now moving a lot of the logic and experience into the Adalo app, but am running into issues with creating the folder structure in Drive using Zapier.
Here’s the scenario:
I need to create this folder structure
- If a new Program is created in Adalo, then create a Program folder in Google Drive with that name.
- If a new Crew (group) is created and then assigned to a Program in Adalo, then create a Crew folder within the above Program folder.
In Zapier, I can’t figure out how to do this. When I go to create the zap, it only gives me the option to select folders that already exist. What I THINK I need is a dynamic structure.
It would look like this:
Program Folder (e.g “The Visionary”)
- Crew belongs to a program (can be many Crews, so whenever I add a new Crew in my app, I need Zapier/Drive to automagically know which Program folder to save this new folder within)
Does anyone have any thoughts?