Need to quickly view all files inside a Google Drive folder—with names, links, owners, and more? This no-code Google Sheets tool helps you extract and list every file in any Google Drive folder in a structured, easy-to-read format.
🚀 What This Tool Does
✅ Accepts any Google Drive Folder URL
📂 Fetches all files inside the folder (including nested folders)
📋 Lists file Name, Type, Link, Owner, Last Modified Date, and Parent Folder
📊 Outputs the data in a well-organized table in Google Sheets
⚙️ Runs with a simple button—no coding required!
🧠 Use Cases
- 📋 Track files in shared project folders
- 🔍 Audit file access & ownership
- 🧹 Cleanup and organize large Google Drive structures
- 📚 Build content inventories or documentation indexes
- 🤝 Share structured file lists with teams or clients
🔐 Privacy & Security
- ✅ Runs on your own Google account
- ✅ No extensions or third-party access
- ✅ Keeps your data secure and private
🧑🏫 How to Use It (3-Step Setup)
Step 1: Paste Folder URL
Go to the URL sheet and paste your Google Drive folder link into cell C6.
Step 2: Click “Run Tool”
This activates the built-in script to fetch the file details.
Step 3: View Results
The sheet will automatically switch to the list tab to display the extracted file data instantly.