![]() Main function 2: List all files & folders, & write into the current sheet. *// Main function 1: List all folders, & write into the current sheet. Var folderId = 'ID OF FOLDER IN GOOGLE DRIVE HERE' Hopefully, that way, it only pulls the newest additions, appends that information (in the next rows), and does not erase and re-pull all the information that was already there. My vision is to have the aforementioned button generate the most recent date that the script was run, setValue in a cell (say, G2), and then base the next pull for any reports added since the date in G2. I use a created button ("Update") to run the script. By the time we get to 300-400 reports that pull process takes 10-15 minutes. When the tracking log is updated it, clears the entire sheet, and systematically re-pulls everything that was there, and adds anything new. ![]() And by Dec 31st of the respective year, the number of reports is in the 300-400 range. So Jan 1 of a given year, possibly a handful of reports could be generated. Because it is now a drive you can just use regular commands to 'cd' to it and then 'dir /b > file.csv' You can also look at if you do not want a permanent mounted drive. The tracking log is based on the calendar year. You can do the following: net use X: \\NAS\Share This will 'mount' the \NAS\Share folder to drive 'X'. My situation is such that I have created a tracking log for reports, and data elements within reports. But I would like to refine it to where it pulls the folder/file based upon the date it was generated. I am currently using the below script to pull folder/file information from a google drive, and list the information into a google sheet. In Google Drive, select the source folder you want to copy and click the button Copy folder tree.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |