Skip to main content
Best answer

Create sub-folder in Google Drive using folder name from Google Sheets

  • August 12, 2021
  • 1 reply
  • 116 views

I am trying to create a GDrive folder hierarchy by using GSheet rows. Creating the root folder works fine, but I can’t get it to create a sub-folder.

So for example if I add a GSheet row called “Test”, the it will create a folder named “Test” (correct!)

But if I add a row called “Test/sub-test” then it actually creates a new folder called (literally) “Test/sub-test”, rather than creating a sub-folder called “sub-test” in the folder “Test”.

Any ideas what I may be doing wrong?

Best answer by Troy Tessalone

Hi @Karlcct 

To create the Sub Folder it needs to know the Parent Folder ID.

NOTE: The Folder names would need to be unique in order to avoid finding the wrong Parent Folder.

Try these steps…

  1. Trigger: ???
  2. Action: GDrive - Find Folder (Parent Folder)
  3. Action: GDrive - Create Folder (Sub Folder) [map the ID of the Folder from Step 2]
View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31284 replies
  • Answer
  • August 12, 2021

Hi @Karlcct 

To create the Sub Folder it needs to know the Parent Folder ID.

NOTE: The Folder names would need to be unique in order to avoid finding the wrong Parent Folder.

Try these steps…

  1. Trigger: ???
  2. Action: GDrive - Find Folder (Parent Folder)
  3. Action: GDrive - Create Folder (Sub Folder) [map the ID of the Folder from Step 2]