Amazing video I just want to ask that I have a folder in google drive and a sheet in it by using this method how can I add data of that sheet in my current spreadsheet
Hello, would you like to use api for the following: I have a wordpress site, I put files for download, I put the link to my google drive, the user clicks on the link and this file is added to his account? Thanks
Great stuff. I'm looking for a way to watch a folder and (if) someone, in our organization) uploads a file there in that folder then I get a flagged cell in Spreadsheets or a message/email/hangout anything. We have thousands of NULL folders and it's time consuming to constantly chase people or manually go through the folders to see if team members have sent in requested files. P.S. most of these people work in construction so aren't going to have time to link drive files and send emails.
Hi all. It might be worth pointing out that sometimes you can't see the results in the folders right away. I ran the script without issues yesterday but the small and large folders appeared to be empty. When I checked out the folders today to tinker the script I noticed that the files were copied were they belong. I suppose it might have something to do with my bandwidth.
Hi... i'm not a seasoned code writer so please understand if my question is too basic. Could you let me know how to select specific file names within the Drive folder. I'm trying to automate moving files that contain the text "Notes" from one folder to another. I figured out how to move the file; just can get how to select the file(s)
On my code the line: var folder = folderIter.next(); it's getting me this error message: [20-06-17 09:20:21:049 CDT] TypeError: folderIter.next is not a function at moveFiles(Test 3:5:27) . Would it be because I don't have any files? I am trying to get the files submitted from a Form to a specific folder. The Form automatically sends the files to a particular folder but I need these files to land in a created folder name which the code has been written to create folder if specific information is selected and the folder creation works. All I need is to move the files to the created folders. Can anyone help? Thanks!
Hi, I have some files attached to a google sheet, and there is a column for files url in the sheet. I need to extract the names of these files into a separate column in the sheet. Any help will be appreciated.
Hello, How to convert photos to OCR as a group using Google Drive? because only one photo is converted to text at each step (through conversion by Google Doc).
Hi Thanks for all your videos, very useful. One use case I could not find in your videos is to upload a file to google drive from GAS web application. if it's already available please point me to it OR it will be very helpful if you could add it. Thanks.
Hi again. Was wondering if it is possible to make an App Script macro in Google sheets to extract the list of folders/sub-folders (tree) and also a list of people that they are shared with, their access level... Or just point me in the right direction. Many thanks
@@ExcelGoogleSheets Yes! Some script that would pull the metadata. For start, it would be useful to have an input field for entering the link to the folder and then the script runs and returns a table with all the metadata. Is that even possible?
It should be possible, not saying it will be easy though. This may require recursion if you don't have limited level of folder depth in mind, which is a difficult subject on its own. Additionally, I'm not sure how you would get those results in a table, because depending on how many folders you have and the number of folders & files in each folder, this table can get enormously large. But in short you would need one function that gets you folders in a folder, and then recursively call that same function on all folders. I'm not sure whether Google has limit on recursive call stack. Old javascript version does, which Apps Script seems to be using, but then it's a modified version of it, so who knows. You'll have to try and see. I'd say search "javascript recursion" and see if you can wrap your head around it.
Thank you for the vide, this helped me out so much. I do have a question, which I hope you can answer. I have Google advance drive enabled on v2 as I am trying to disable users from being able to download my files. The following code fails stating that my filename which is shown and correct cannot be found: ---- var filename = file.getName(); var labels = { 'labels': {restricted: true} };
Drive.Files.update(labels, filename); ----- Any advice would be so helpful.
Hi, I'm searching how to automatically store gmail attachments into specific google drive folder and then overwrite the same file with the same name. Would you mind to make the script tutorial? I've been searching here and there but found no result. Thank you very much for your attention.
Great video, I am trying to do the same but for over 20K images, it is very slow while looping through all those images. Do you have any suggestions to follow for large amount of images? thanks! : )
Can you help me, I can not find how to do it, I am starting in KODULAR, how can I get DWG files (Autocad) or JPG files from GOOGLE DRIVE and download them to the cell phone by pressing a button in the application, thank you very much.
Dear i tried to find files contains sepcific word . it works fine with root folder but if i try in subfolder its not working. Will you please guide further. thanks.
How can I use a function from the different google script file in the same project or may be in a different project ? Please help ! I guess ScriptApp can be used. But i didn't find anything . If you are not free enough to do a video. Just share link or anything. That might help !
Code seems to run perfectly for me but when shared it returns "Cannot retrieve the next object: iterator has reached the end" - Only occurs with people i have shared file with . Hoping for a quick solution. thanks
Hey I like your videos, I'm working on a script but I can't get it to work properly, I have tried some sample code and modified it. I want to copy sheet to a new sheet in my database log, however i don't want to bring every formula just the fixed values when my script runs. If its possible, what do I need to change in the formula? the comment on top is using contentsOnly:true but when i use it dos not work. Thanks alot // var targetSheet = ss.getSheetByName("CLOSED"); // var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1); // s.getRange(row, 1, 1, numColumns).copyTo(target, {contentsOnly: true}); // s.deleteRow(row); function onOpen() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var pasteSheet = [ {name: "Paste Sheet", functionName: "copySheet"}]; ss.addMenu("Copy to Spreadsheets", pasteSheet); } function copySheet() { var source = SpreadsheetApp.getActiveSpreadsheet(); var sheet = source.getSheets()[0]; var sourceFile = DriveApp.getFileById(source.getId()); var sourceFolder = sourceFile.getParents().next(); var folderFiles = sourceFolder.getFiles(); var thisFile; var date = Utilities.formatDate(new Date(), "GMT+1", "dd/MM/yyyy"); var endDate = date; while (folderFiles.hasNext()) { thisFile = folderFiles.next(); if (thisFile.getName() !== sourceFile.getName()){ var currentSS = SpreadsheetApp.openById(thisFile.getId()); sheet.copyTo(currentSS); currentSS.getSheets()[currentSS.getSheets().length-1].setName('THIS WAS COPIED'+" "+endDate); } }; } The plan is to run this every day and make a daily copy at the same time then be able to analyze the change in data.
Hi ! My name SARETH, I would like to request help. By using Google sheet as database. 1- How to use app script to automatically create google sheet files in particular folder and base on the name ? For example, we want to create Travel Authorization for 40 people only one time and all information containe in the sheet the same but separated files. 2- I want to create Vehicle fleet management system and the system can produce monthly report. In the report containes about: Vehicle ID, DATE of filling fuel, Odometer start, Odometer end, Projects, distance which used for each project. Many thanks for your help
Is there a way to copy my sheet as a pdf to a dropbox folder? What if the dropbox file is different from computer to computer? Or maybe if there is a folder with the name in cell A1 save it to that folder, if not save it to a new folder with the name in A1. Is something like this even possible? thank you
lol, if you hate curly brackets so much you should probably stay away from programming. Well, I guess you could program in Python, no curly brackets there ;)
just spent 2hrs turning this into something i wanted for ages - once again thanks very much for these videos
Just one word for this video!! WOW!!! Really apps scripts is wonderful tool for management
this is on another level - GOD BLESS YOU!!!!!!!!!!
Great videos the best for Google SpreadsheetApp learning
Glad you liked it
Damn! It's always a great pleasure learning with your videos. This is a new topic for me and i'm very happy to find you having it covered!
You are a hero...We love you man !!!
Super video and very easy to follow
could you do a quick video on how to upload a file (image maybe) using App Script from a Web App?
Very few views. I'm glad to be a nerd learning things. Thanks for the video. It is gonna help me on a project I'm working on
interesting explanation!!!
Great piece of teaching!
Thanks for this tutorial!!
Great tutorial as usual. please share more videos on google sheet and drive app together.
Great video
Beautiful! Thank you for this!
You are awesome thank you!
Great. Thank you.
This is awesome.
Great, very useful video! Thank you
Awesome Video
Thank you. Could you tell me please what screen recorder you use for making your videos in that high quality?
this guy is fabulous, it will be good if he live neighborhood.
Thank you so much for your all efforts
Sir Please upload daily videos
sir when i use this in sheet using retrun method showing me error message "you dont have permission to getfolderbyId" kindly guide how to solve this
Amazing video I just want to ask that I have a folder in google drive and a sheet in it by using this method how can I add data of that sheet in my current spreadsheet
thumbs up for this! thank you.
Thank you!
Thank you
Thank you, good script
Hello, would you like to use api for the following:
I have a wordpress site, I put files for download, I put the link to my google drive, the user clicks on the link and this file is added to his account? Thanks
"if you don't know what you're doing" haha yep good advice
Thanks for the video
thanks for the video!
Thanks
Great stuff. I'm looking for a way to watch a folder and (if) someone, in our organization) uploads a file there in that folder then I get a flagged cell in Spreadsheets or a message/email/hangout anything. We have thousands of NULL folders and it's time consuming to constantly chase people or manually go through the folders to see if team members have sent in requested files. P.S. most of these people work in construction so aren't going to have time to link drive files and send emails.
Hi all. It might be worth pointing out that sometimes you can't see the results in the folders right away. I ran the script without issues yesterday but the small and large folders appeared to be empty. When I checked out the folders today to tinker the script I noticed that the files were copied were they belong. I suppose it might have something to do with my bandwidth.
Good tip!
Hi, can you tell us about continuationtoken when folder with subfolders are need to be scaned for files?
Hi... i'm not a seasoned code writer so please understand if my question is too basic. Could you let me know how to select specific file names within the Drive folder. I'm trying to automate moving files that contain the text "Notes" from one folder to another. I figured out how to move the file; just can get how to select the file(s)
figured it out.....
On my code the line: var folder = folderIter.next(); it's getting me this error message: [20-06-17 09:20:21:049 CDT] TypeError: folderIter.next is not a function
at moveFiles(Test 3:5:27)
. Would it be because I don't have any files? I am trying to get the files submitted from a Form to a specific folder. The Form automatically sends the files to a particular folder but I need these files to land in a created folder name which the code has been written to create folder if specific information is selected and the folder creation works. All I need is to move the files to the created folders. Can anyone help? Thanks!
How can I take a set of images from a google drive folder, like you're doing here, and automatically make a Google slides out of them?
Thank you! Please make a lesson about the input data (external web form )?
Good job. I enjoy your videos. Now that it is done, does the script run automatically when add a photo to that folder?
Awesome tutorial. How could I insert the found pictures into the cells with the made while loop?
Hi, I have some files attached to a google sheet, and there is a column for files url in the sheet. I need to extract the names of these files into a separate column in the sheet. Any help will be appreciated.
so you added the file names to the spreadsheet but how do you actually add the image itself to the cell.
Hello, How to convert photos to OCR as a group using Google Drive? because only one photo is converted to text at each step (through conversion by Google Doc).
Hi Thanks for all your videos, very useful. One use case I could not find in your videos is to upload a file to google drive from GAS web application. if it's already available please point me to it OR it will be very helpful if you could add it. Thanks.
Hi again. Was wondering if it is possible to make an App Script macro in Google sheets to extract the list of folders/sub-folders (tree) and also a list of people that they are shared with, their access level... Or just point me in the right direction. Many thanks
access to what? folders, files in folders?
@@ExcelGoogleSheets Yes! Some script that would pull the metadata. For start, it would be useful to have an input field for entering the link to the folder and then the script runs and returns a table with all the metadata. Is that even possible?
It should be possible, not saying it will be easy though. This may require recursion if you don't have limited level of folder depth in mind, which is a difficult subject on its own. Additionally, I'm not sure how you would get those results in a table, because depending on how many folders you have and the number of folders & files in each folder, this table can get enormously large. But in short you would need one function that gets you folders in a folder, and then recursively call that same function on all folders. I'm not sure whether Google has limit on recursive call stack. Old javascript version does, which Apps Script seems to be using, but then it's a modified version of it, so who knows. You'll have to try and see. I'd say search "javascript recursion" and see if you can wrap your head around it.
It would very much help if could make video regarding file upload to the google drive folder with help of apps script.
🙏🏻
can I increase or program a minimum access limit?
Thanks Sir, how to reduce that file size suppose I upload an image with size 5 MB and I want to reduce it to 500 KB ?
Thank you for the vide, this helped me out so much. I do have a question, which I hope you can answer. I have Google advance drive enabled on v2 as I am trying to disable users from being able to download my files. The following code fails stating that my filename which is shown and correct cannot be found:
----
var filename = file.getName();
var labels = {
'labels': {restricted: true}
};
Drive.Files.update(labels, filename);
-----
Any advice would be so helpful.
Hi
Nice video as usual, Is there a way that i can move files from my Drive to Team drive folder?
How would u add video files to a spreadsheet?
Hi, I'm searching how to automatically store gmail attachments into specific google drive folder and then overwrite the same file with the same name. Would you mind to make the script tutorial? I've been searching here and there but found no result. Thank you very much for your attention.
Great video, I am trying to do the same but for over 20K images, it is very slow while looping through all those images. Do you have any suggestions to follow for large amount of images? thanks! : )
I'm not sure exactly what you're trying to do with your files. Using something like Google Colab may help, but again, depends on many factors here.
Yep.
Thank you very much. How do I open a file using google apps script?
Hi
I tried to upload a file using the Firefox browser.
But, the file is not uploaded correctly.
can you help me -please?
Can we get files from a shared with me folder?
Can you help me, I can not find how to do it, I am starting in KODULAR, how can I get DWG files (Autocad) or JPG files from GOOGLE DRIVE and download them to the cell phone by pressing a button in the application, thank you very much.
Is there a way to add a file name in a cell? For example I open a file and I want that file name in cell a1
Hi, how we can create a sheet inside a spacial folder using Google Apps Script?
Dear i tried to find files contains sepcific word . it works fine with root folder but if i try in subfolder its not working. Will you please guide further. thanks.
How can I add a new row in Google spread sheet when I Add a new folder inside parent folder
How can I use a function from the different google script file in the same project or may be in a different project ?
Please help !
I guess ScriptApp can be used. But i didn't find anything . If you are not free enough to do a video. Just share link or anything. That might help !
This function works well from the console but from a document, the call to Driveapp... does not work, why? What's left to define? SORRY FOR MY ENGLISH
it would be super awesome if we could automatically(once per day) save folders from Goggle drive to our pc and then delete them
can you please show how you can upload files from a web app and into a google sheet?
another question: can you access the hard drive files rather than Google Drive?
Not using Google Scripts. Use NodeJS or Python instead.
How to hire you for Google app script assignment?
Sir please make a video how to automatically rename a file uploaded in Google form based on fields in Google form
Is it possible to with app script to change the photo names?
Sure
@@ExcelGoogleSheets Would it be setName instead of getName? Any hint would be great!
How we contact you if face problems sir
How can we create folder to user login then create folder then select that, pls help. im subs btw, thank you!
Code seems to run perfectly for me but when shared it returns "Cannot retrieve the next object: iterator has reached the end" - Only occurs with people i have shared file with
. Hoping for a quick solution. thanks
it's using driveapp and other users probably don't have permission to access the folder in google drive.
You'll need to share the folder as well.
how to uplaod a file to my drive folder by ID?
Hey I like your videos, I'm working on a script but I can't get it to work properly, I have tried some sample code and modified it. I want to copy sheet to a new sheet in my database log, however i don't want to bring every formula just the fixed values when my script runs. If its possible, what do I need to change in the formula? the comment on top is using contentsOnly:true but when i use it dos not work. Thanks alot
// var targetSheet = ss.getSheetByName("CLOSED");
// var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
// s.getRange(row, 1, 1, numColumns).copyTo(target, {contentsOnly: true});
// s.deleteRow(row);
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var pasteSheet = [ {name: "Paste Sheet", functionName: "copySheet"}];
ss.addMenu("Copy to Spreadsheets", pasteSheet);
}
function copySheet() {
var source = SpreadsheetApp.getActiveSpreadsheet();
var sheet = source.getSheets()[0];
var sourceFile = DriveApp.getFileById(source.getId());
var sourceFolder = sourceFile.getParents().next();
var folderFiles = sourceFolder.getFiles();
var thisFile;
var date = Utilities.formatDate(new Date(), "GMT+1", "dd/MM/yyyy");
var endDate = date;
while (folderFiles.hasNext()) {
thisFile = folderFiles.next();
if (thisFile.getName() !== sourceFile.getName()){
var currentSS = SpreadsheetApp.openById(thisFile.getId());
sheet.copyTo(currentSS);
currentSS.getSheets()[currentSS.getSheets().length-1].setName('THIS WAS COPIED'+" "+endDate);
}
};
}
The plan is to run this every day and make a daily copy at the same time then be able to analyze the change in data.
how can i insert images in cells using this script
Is there a book that I can learn all this in?
How to download this file present in Google Drive folder through the app script?
The short answer: you can't because Apps Script runs on the server.
It's possible with Google Drive API and Node or other programming environment.
How to get files URL next to the file name?
Hi !
My name SARETH, I would like to request help. By using Google sheet as database.
1- How to use app script to automatically create google sheet files in particular folder and base on the name ? For example, we want to create Travel Authorization for 40 people only one time and all information containe in the sheet the same but separated files.
2- I want to create Vehicle fleet management system and the system can produce monthly report. In the report containes about: Vehicle ID, DATE of filling fuel, Odometer start, Odometer end, Projects, distance which used for each project.
Many thanks for your help
I Want to segeregate MY ilages stylcode wise Folders
How to get photos from google photos plz help
How to get folder list with folder name or folder id?
I want to get all folder from root and sub folder..
The short answer is, use recursion
@@ExcelGoogleSheets I searched on google related to this and did not find it until now. Can you share the code, sir?
I found this www.labnol.org/code/19923-google-drive-files-list, but the coding seems to be showing not only folders but files
@@ExcelGoogleSheets For simplicity, I want to get jpg files in the root folder and subfolders without defining the folder name or folder id
I thought you wanted the folder? Or do you just need the JPG files?
Is there a way to copy my sheet as a pdf to a dropbox folder? What if the dropbox file is different from computer to computer? Or maybe if there is a folder with the name in cell A1 save it to that folder, if not save it to a new folder with the name in A1. Is something like this even possible? thank you
folderIter.next isn't a function anymore
Shit, can we do the same thing in google drive with Python?
Yes. Use Google Colab.
Sir we need to send direct link but we can't .
how do I .getFolderById
Could have done without the while loop explanation.
Thanks so much, can someone paste the code here!
fucking curly brackets.. i hate them...
but thanks anyway for explaining :-)
lol, if you hate curly brackets so much you should probably stay away from programming. Well, I guess you could program in Python, no curly brackets there ;)