Automated Google Drive Organizer
Automatically organize your Google Drive files by using AI to categorize and move them into designated folders, complete with an email summary report.
Tags
Introduction
The Automated Google Drive Organizer workflow is designed to tidy up your workspace by automatically sorting files into relevant folders. It fetches your files, categorizes them using an AI model based on their type and content, moves them to appropriate destinations, and sends a summary email of the organization process.
It performs the following tasks:
- Lists all files owned by you, excluding folders.
- Limits the files to the top 10 for a manageable batch processing run.
- Uses an AI agent to categorize each file by checking its type and content keywords.
- Moves each file to its designated folder based on the AI classification.
- Generates and sends a summary report via Gmail detailing the files moved, skipped, or failed.
What You Need
- A Google account with access to Google Drive and Gmail.
- A Needle platform account with Google Drive and Gmail connectors linked.
- Folder IDs for your Google Drive folders where files will be organized.
- Basic understanding of how to customize AI prompts to match your specific categorization rules.
How the Workflow Works
| Step | Action | Description |
|---|---|---|
| 1 | Manual Trigger | Starts the workflow manually when you want to organize your files. |
| 2 | List Google Drive Files | Retrieves files you own on Google Drive without including folders. |
| 3 | Slice Files | Limits the list to the first 10 files using a custom code snippet. |
| 4 | AI Categorization | Uses a custom AI prompt to analyze each file's name and type, assigning them to target folders. |
| 5 | Move Files | Moves each file to its new folder destination as instructed by the AI agent. |
| 6 | AI Email Summary | Analyzes the run results and sends a formatted HTML summary email using Gmail. |
Output
At the end of the run, your selected files will be neatly organized into their respective folders in Google Drive according to your predefined categories. Additionally, you will receive an email summarizing the total files processed, a breakdown by folder, and any skipped or failed items.
Important Notes
- Be sure to customize the AI prompt in the categorization node with your actual Folder IDs and business-specific keywords.
- Update the email address in the final AI agent node to ensure the summary report is sent to your own inbox.
- The workflow currently processes only the first 10 files per run to ensure efficiency.
- You can trigger this workflow manually whenever you want to tidy your Google Drive.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
