Google Apps Script - Create Files and Folders in Google Drive Using Values from Google Sheets
HTML-код
- Опубликовано: 4 авг 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 - Наука
Great video Joseph. Thank you so much. Very clear instructions and logic. Thanks!
Great video! Thank you!
great stuff! subbed👌
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!
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?
Like the video, but I keep getting an error message for the rootfolder function code. Can you assist
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 ?
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 : )