About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

New Row in Google Sheet creates folders and templates?

  • 31 August 2022
  • 8 replies
  • 45 views
C

I am trying to do the following order of operations, is this possible? 

New Row in Sheet triggers creation of folder and subfolders named after the identified cell

New folder triggers creation of mutliple different templates named after the cell

 

Example: 

New row added: 

Week 4008 20220829 20220830 20220831 20220901 20220902 20220905

 

Creates Week 4008 folder that contains subfolder 20220829; 20220830…

5 different templates go into subfolders named 20220829TEMPLATE NAME 1; 20220829 TEMPLATE NAME 2 etc. 

 

icon

Best answer by Troy Tessalone 2 September 2022, 15:24

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @cdc 

Good question.

Yes, that’s possible.

 

Zap apps available triggers/actions…

GDrive: https://zapier.com/apps/google-drive/integrations#triggers-and-actions

GSheets: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

 

Help article about how to map dynamic variables between Zap steps: https://zapier.com/help/create/basics/set-up-your-zap-action#set-up-your-action

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
C

Ok, I can get the folders to appear in the manner that I want. But I can’t get the documents to appear within the folders. Is there anywhere I can see a Zap example so I know I am setting it up correctly? 

 

Currently I have a multipstep

add the row triggers: 

add weekly folder

add daily folder

copy excel spreadsheet into daily folder

find google doc by name

copy google doc into daily folder (these don’t even appear at all)

Troy Tessalone
Userlevel 7
Badge +14

@cdc 

Please post detailed screenshots with how your Zap steps are configured in order for us to have context, thanks.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
C

 

C

You can see I tried finding the doc and copying the doc into the folder, as well as creating doc from tempate and inserting into folder. Neither works. The document doesn’t appear anywhere. 

 

I figured I would start with just the Monday folder and if I can get that working it’s just a repeat the steps for the following days. 

Troy Tessalone
Userlevel 7
Badge +14

@cdc 

Remove the static “root” in all the applicable steps.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
jesse
Userlevel 7
Badge +9

@cdc Just checking in here! Were you able to try Troy’s suggestion for removing “root” from the folder field for each of those steps to see if that helps get things in the right places? Let us know!

C

apologies for the delay. Yes, that worked. Such a silly error. Thank you so much! 

Terms & Conditions