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?
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!
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?
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?
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 ?
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?
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 : )
Great video Joseph. Thank you so much. Very clear instructions and logic. Thanks!
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!
This was the best app script video I have ever seen!!!
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?
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!
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?
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?
Great video! Thank you!
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?
Hi, could you advice how to copy not 1 cell but more range into doc from sheet? thanks!
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 ?
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?
great stuff! subbed👌
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
Great video
if you are UNABLE to RUN the script, SAVE the project and try agai!!
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 : )