一個簡單易用的工具,可以擷取 Google Drive 資料夾中的檔案名稱與分享連結,並匯出為 CSV 清單。
使用 Google Apps Script 部署版本: https://script.google.com/macros/s/AKfycbxvKJuFiXlsMoH9t7rWpOuwcRZfPLuZKvrhlIS46GKJPeRNAJH9dNjbV_y1k_DzyZsk/exec
從 Google Drive 資料夾中擷取所有檔案和子資料夾的名稱與連結
支援中文和英文界面
將結果匯出為 UTF-8 編碼的 CSV 檔案
簡潔直觀的使用者介面
完全免費且開源
開啟應用程式連結
確保你的 Google Drive 資料夾權限設定為「知道連結的任何人為檢視者或編輯者」
在輸入框中貼上 Google Drive 資料夾連結(格式如:https://drive.google.com/drive/folders/...)
點擊「下載 CSV 檔案」按鈕
等待處理完成,CSV 檔案會自動下載到你的裝置
方法一:Google Apps Script 部署
點擊「新專案」建立一個新的專案
刪除編輯器中的預設程式碼
新增 index.html 和 code.gs 檔案,並複製本儲存庫中對應的程式碼
點擊「部署」>「新增部署」
選擇部署類型為「網頁應用程式」
設定執行身分為「我自己」,存取權限為「任何人」
點擊「部署」按鈕並授予必要的權限
前端:HTML、CSS、JavaScript
後端:Google Apps Script
API:Google Drive API
輸出格式:CSV (UTF-8 編碼)
為什麼我無法擷取某些資料夾的內容?
請確保資料夾的權限設定為「知道連結的任何人為檢視者或編輯者」,否則應用程式無法存取資料夾內容。
是否支援巢狀資料夾?
目前版本只支援擷取指定資料夾的直接子資料夾和檔案,不會遞迴擷取更深層的內容。
支援哪些瀏覽器?
本工具支援所有現代瀏覽器,包括 Chrome、Firefox、Safari 和 Edge 的最新版本。
本專案採用 MIT 授權協議 - 詳見 LICENSE 檔案
開發者:blues32767
版本:1.1.0
最後更新:2025/03/04
A simple tool to extract file names and sharing links from Google Drive folders and batch export them as a CSV list.
Or use the Google Apps Script deployed version: https://script.google.com/macros/s/AKfycbxvKJuFiXlsMoH9t7rWpOuwcRZfPLuZKvrhlIS46GKJPeRNAJH9dNjbV_y1k_DzyZsk/exec
Extract all files and subfolders names and links from a Google Drive folder
Support for both Chinese and English interfaces
Export results as UTF-8 encoded CSV files
Clean and intuitive user interface
Completely free and open source
Open the application link
Make sure your Google Drive folder's permission is set to "Anyone with the link as Viewer or Editor"
Paste your Google Drive folder link in the input box (format: https://drive.google.com/drive/folders/...)
Click the "Download CSV" button
Wait for processing to complete, and the CSV file will automatically download to your device
Method 1: Google Apps Script Deployment
Go to Google Apps Script
Click "New Project" to create a new project
Delete the default code in the editor
Add index.html and code.gs files, and copy the corresponding code from this repository
Click "Deploy" > "New deployment"
Select deployment type as "Web application"
Set execution identity as "Me" and access as "Anyone"
Click the "Deploy" button and grant the necessary permissions
Frontend: HTML, CSS, JavaScript
Backend: Google Apps Script
API: Google Drive API
Output Format: CSV (UTF-8 encoded)
Why can't I extract content from certain folders?
Make sure the folder's permission is set to "Anyone with the link as Viewer or Editor", otherwise the application cannot access the folder contents.
Does it support nested folders?
The current version only supports extracting direct subfolders and files from the specified folder. It does not recursively extract deeper content.
Which browsers are supported?
This tool supports all modern browsers, including the latest versions of Chrome, Firefox, Safari, and Edge.
Contributions are welcome! Please follow these steps:
Fork the repository
Create your feature branch (git checkout -b feature/amazing-feature)
Commit your changes (git commit -m 'Add some amazing feature')
Push to the branch (git push origin feature/amazing-feature)
Open a Pull Request
This project is licensed under the MIT License - see the LICENSE file for details
Developer: blues32767
GitHub: https://github.com/blues32767/
Version: 1.1.0
Last Updated: 2025/03/04