Google Apps Script - Create Files and Folders in Google Drive Using Values from Google Sheets
Vložit
- čas přidán 4. 08. 2023
- 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.com/palumbo/d81f9...
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.app.goo.gl/ZkK1 - along with one of my promotional codes to get 10% off of your first year!!
Business Starter Promotion LCWXMA4CWAEM6XN
Business Standard Promotion P7Y7AMGTQ64KP3V - Věda a technologie
Great video Joseph. Thank you so much. Very clear instructions and logic. Thanks!
Great video! Thank you!
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.
Much appreciated!
great stuff! subbed👌
Hi, could you advice how to copy not 1 cell but more range into doc from sheet? thanks!
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?
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 ?
Like the video, but I keep getting an error message for the rootfolder function code. Can you assist
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?
Great video I am looking for something like this, are you offering any programming service!
Hello @trustier, I am a consultant for hire. Feel red to reach out to me via email or my GitHub profile.
I
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
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 : )