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

[@EmdadTradingLLC]

Hi Joseph Thank you for this valuable content.. Here's how I benefited from your video: I run a startup that receives RFQs from large service companies, and the process of creating files in Google Drive for each order was very time consuming. Thanks to this tutorial, the program now creates new files automatically for each new RFQs I enter in the sheet. It would be very helpful if you could teach us how we can create a program that can take email subjects and add it to Google Sheet automatically. Thank you

[@khalidkasha]

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

[@RadhikaSharma-e9e]

This was really helpful! is it possible to have a base template file which is then 'made as a new copy' for each new folder?

[@juliajones8591]

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

[@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!

[@dhikahanif]

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?

[@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!

[@EwaIwanko]

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

[@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?

[@LostOrStolen]

So I have an automation that connects my website data with a Google Sheet. It has been working fine in the last couple of months. Now, it works intermittently. I have reached out to my website customer service and google, and the issue persists. Any idea what it could be?

[@ToniBarnes-w9w]

Great video! Thank you!

[@elainegraham-gaynor1224]

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

[@ienapriski]

Greetings from Italy. Really nice to follow you. You are extremely clear. I would like to ask you if the same procedure could be good for Google Earth and also create subfolders with inside each an excel sheet with Date, Time, latitude and longitude. I need to import many folders on Google Earth. With this script I could collect the movement data of my trucks. Each truck has its license plate and I would like to create a unique folder (as in your example with the movie titles) Each license plate will have to have subfolders with an excel sheet for each and with the georeferencing inside to then import them into Google Earth. Can you give me a hand?

[@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?

[@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

[@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 ?

[@juanFinnyD]

great stuff! subbed👌

[@ResidentEddy11]

Great video

[@FarhanShahzada-w3r]

if you are UNABLE to RUN the script, SAVE the project and try agai!!

[@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 : )