Apps Script to list Google Drive folder structure and files into a Sheet. Iterates through the root folder and subfolders, listing the folders and files. Included info:
- Full Path
- File/Folder Name
- Type
- Date created
- URL
- Last Updated
- Description (if exists)
- Size
- Create a new Google Sheet
- Click Extensions > Apps Script
- Copy and paste the contents of this repo's Code.gs into your Apps Script Code.js
- Click Save, then Run
- Follow authorization prompts
- Watch your sheet fill up!