Google Apps Script - Create Files and Folders in Google Drive Using Values from Google Sheets

In this video, I show you how to use Google's DriveApp and DocumentApp to create both new Folders and Google Documents using values from a Google Sheet.
Have you ever wanted to create either new folders or documents based on values from a spreadsheet? If you're using Google Workspace, this can be accomplished with less than 30 lines of simple Google Apps Script.
Github Gist: gist.github.co...
WANT TO SAVE MONEY USING GOOGLE WORKSPACES?
If you're interested in maximizing the capabilities of Google Workspace to help organize and run your small business, non-profit, charitable organization, or even your family, you can use my affiliate link - referworkspace... - along with one of my promotional codes to get 10% off of your first year!!
Business Starter Promotion LCWXMA4CWAEM6XN
Business Standard Promotion P7Y7AMGTQ64KP3V

[@juliajones8591]

This was the best app script video I have ever seen!!!

[@khalidkasha]

Great video Joseph. Thank you so much. Very clear instructions and logic. Thanks!

[@bumpersmith]

This is a very good video that explains the content to be the best I've seen for Apps Script. Keep up the good work.

[@jsphpalumbo]

Much appreciated!

[@josephjasperamparo3080]

Thanks for the info. Is there a way I can rename files based on cell values on a daily basis? Say, I need to create multiple google worksheets/make copies for like 6 to 10 new google worksheets and rename it based on Column C2:C12 values? Tia!

[@japhenriquez140]

Good day, I was wondering if its possible to upload a file (pdf / img) to a specific folder created ex. Stranger Things -> at column 7 instead of just description you upload a photo/pdf instead a document and it'll save or upload that file to the Stranger Things Folder?

[@elainegraham-gaynor1224]

Like the video, but I keep getting an error message for the rootfolder function code. Can you assist

[@user-dz3jx3nr9g]

Very helpful. Thankyou 1 question. What if i want to add attachment (pdf / image) based on link that state on the google sheet instead of document description? what script do i need to change?

[@user-bx5vd8kw6z]

Great video! Thank you!

[@user-gd2kd4zf3q]

Hi, could you advice how to copy not 1 cell but more range into doc from sheet? thanks!

[@djweller44]

Thank you.. helpful.. is it possible to reach out to you to get your help with a script I have been struggling with for a few days now?

[@juanFinnyD]

great stuff! subbed👌

[@quinoking]

Hi Amazing video! , i need to create subfolder in the same script how i can do it? And another question, i need to create a script to copy bulk files from a location to another. How i can do it ?

[@trustier]

Great video I am looking for something like this, are you offering any programming service!

[@jsphpalumbo]

Hello @trustier, I am a consultant for hire. Feel red to reach out to me via email or my GitHub profile.

[@12sugengpangestu]

I

[@madsfausing4216]

hey @jsphpalumbo in you video you use the code : var folderId = rootFolder.createFolder(title).getId(); but for me it dosen't work if i got the root file whit: var rootFolder =DriveApp.getFolderById("1234"); I get a parent.mimeType Error... and if I get it whit DriveApp.getFoldersByName I get a Code is not a fuction what is it i do wrong

[@jsphpalumbo]

I created a variable for rootFolder which allowed me to use it to get the ID for another variable. The way you did it, calling DriveApp again, totally works as well : )