How to List all Google Drive links of Files / folder to Google Sheet ?

How to list google drive links of files /folders, their size, types, actual location path, created date and updated date of files and folder, Created By, and many other pieces of information in google sheets.

[winstonwiddes]

WOW! This is amazing, thank you so much!! For anyone who doesn't see the Script Editor under Tools, for me it showed up under Extensions>App Script.

[leadersgangnam]

Really appreciate your guidance. I might have wasted hours making links manually. Thank you so much!

[altafox]

Thank you!! You are saving people hours.

[dineshhande]

Thank you so much. What to punt in the "enter folder ID" if we want the list of all the folders and sub-folders and files within those in the whole good drive (root)?

[trishajenz]

This is super helpful!!! Thank you for posting! I have one question, is there a way to increase the runtime? I see that if you are using a personal account, the runtime is 6 minutes and if using a workplace environment, the runtime is 30 minutes. Curious if there is a way to have it run on an unrestricted time limit until all folder/files in very large folders, that would exceed a 1/2 hour runtime, can be recorded? Or is there a way to resume the script at the last point it stopped running to capture the rest of the folders remaining past that 1/2 run time? Thank you!

[Kawotsatutlaka]

You have helped me very much
Thank you! You are the 👑

[YourOnlineMentor]

can you provide the code which can get the files from the main folder? also can we get data from drive associated with other email account

[Vinc]

Thanks! i have a folder with thousands of data and after some time the script stops with "Exceeded maximum execution time". do you have any idea how to fix this?, it stopped after 2400 files. maybe some way to bypass this or start script again and start from the last file?

[HoangNguyen_TH]

Thank you very much for this useful tip!!!

[MARGIEMONTOYA]

Thank you so much for this!! Super helpful

[MrWhiteturbo]

HI, thanks this is very helpful, how would I only list all files/folders within 1 level of folders. In other words, I only want to list all the folders in the folders in the original parent folder. I don't want to list all the folders within those folders.

[ZhenHyun]

I have too many files and I run into "Exceeded maximum execution time" error. Any way of extending the execution time please?

[nisargj]

Thanks to you and thanks to YouTube!!!!

[suntarin]

I have many file and subfolder when script running over 5 minutes, i found alarm exceeded maximum execution time. Could you help to solve ?.

[walsayer]

Thanks for a great script. What if I just want contents of the main folder, no child folders?

[niqfhgp]

Hi Thanks for the script one addition is there a way to identify to who all the file is shared with editor/commenter/viewer access?

[stgpdrawing]

I have more than 1000 files in a folder but after listing 821 items there is one error showing "executing time exceeded" so what is solution or how can i download only a particular sub-folder.

[jimrosenvang]

Hi it seems that the scrips doesent work on shared drived (google workspace) can you please provide a solutions to this. Thanks in advance

[fredlampa]

Hello, is there a limit in the output? I've used this script and it will ouput up to 4K lines only in my google sheet. Kindly advise

[meeradevidaran]

Hi, I have 718 files in the folder but after following the steps I only have 1 file listed. Any idea why this happens?