Intelligent Classification and Upload of Gmail Attachments to Google Drive
This workflow automates the integration of Gmail, Google Sheets, and Google Drive to intelligently classify and store attachments from emails with specific labels. It can automatically identify the sender's company and the email date, dynamically creating corresponding folders and orderly uploading attachments to Google Drive. The process supports the splitting of attachments and adds timestamps to file names, significantly improving file management efficiency. It is suitable for teams in finance, customer service, and legal sectors that require efficient archiving.
Tags
Workflow Name
Intelligent Classification and Upload of Gmail Attachments to Google Drive
Key Features and Highlights
This workflow automatically monitors a specified Gmail inbox for emails tagged with certain labels, extracts attachments from these emails, and dynamically creates corresponding company folders and year-month subfolders based on the sender’s company and the email date. Attachments are then systematically uploaded to the appropriate directories in Google Drive. It supports splitting multiple attachments to ensure each file is uploaded independently, and prefixes filenames with timestamps for easier management and traceability.
Core Problems Addressed
- Automates the storage of email attachments, eliminating the need for manual downloading and classification.
- Ensures attachments are archived in a structured manner by company and date, improving file retrieval efficiency.
- Uses a whitelist to filter and process emails only from specified senders, enhancing process security and relevance.
Use Cases
- Automating the organization of invoices, receipts, and other financial documents for corporate finance departments.
- Automatically archiving customer email attachments for customer service teams to facilitate follow-up.
- Managing contracts, agreements, and other critical documents automatically in legal, consulting, and similar industries.
- Any office automation scenario requiring automatic classification and storage of email attachments.
Main Workflow Steps
- Gmail Trigger: Polls new emails under a specified label every 15 minutes.
- Lookup in Sheets: Searches the Google Sheets whitelist to find company information based on the sender’s email address.
- Search Company Folder1 & Company Folder Exists: Checks if the corresponding company folder exists in Google Drive; creates it if not.
- YYYY/MM: Generates a year-month formatted subfolder name based on the email date.
- Search For Folder & Check If Folder Exists: Checks if the year-month folder exists; creates it if absent.
- Gmail: Retrieves email details and attachments.
- Split Up Binary Data1: Splits multiple attachments into individual items for separate processing.
- Loop Over Items: Processes each attachment in a loop.
- Upload To Folder: Uploads each attachment to the corresponding year-month folder, prefixes the filename with a timestamp, and attaches sender and reception time metadata.
Systems and Services Involved
- Gmail (email trigger and content retrieval)
- Google Sheets (sender whitelist management and company info lookup)
- Google Drive (folder management and attachment storage)
- n8n Automation Platform (workflow orchestration and execution)
Target Users and Value Proposition
- Enterprises and teams managing large volumes of emails with attachments, especially finance, customer management, and legal departments.
- Office personnel aiming to reduce manual operations and enhance document archiving standardization and automation.
- Organizations pursuing digital transformation projects focused on automated classification and storage of email attachments.
This workflow integrates Gmail, Google Sheets, and Google Drive through automation to intelligently classify and archive email attachments, significantly improving office efficiency and ensuring systematic and standardized file management.
Automated XLSX File Download and PDF Conversion Workflow
This workflow automates the process of downloading Excel (XLSX) files from a specified URL, converting them to PDF format, and finally saving the PDF files locally. By fully automating the process, it significantly simplifies the cumbersome steps of manual downloading and conversion, saving time and labor costs while ensuring the quality and stability of the conversion. It is suitable for scenarios such as enterprise report management, data sharing, and document processing, thereby enhancing work efficiency.
Daily Meetings Summarization with Gemini AI
This workflow automatically retrieves meeting data from Google Calendar and uses the Gemini AI model for intelligent summarization. It ultimately sends the meeting summary to a designated Slack channel. This effectively addresses the cumbersome nature of traditional meeting summaries and the issue of information being scattered, helping team members quickly access key information and enhancing communication efficiency. It is particularly suitable for teams that need to track meetings daily or for professionals working in remote environments.
Personal Assistant MCP Server
This workflow builds an intelligent personal assistant server that integrates the Google Gemini chat model and various automation tools, supporting natural language interaction and intelligent memory management. Users can efficiently manage calendars, emails, and contact information through chat commands, enabling functionalities such as event creation, updates, and email draft generation. Its design aims to enhance office efficiency, simplify multi-platform operations, and is suitable for individuals and businesses that require effective scheduling and communication.
AI Agent: Google Calendar Assistant Using OpenAI
This workflow is an intelligent Google Calendar assistant that utilizes OpenAI's GPT-4o language model, enabling users to quickly create and query calendar events through natural language. It features contextual memory, allowing it to understand the user's conversation history and provide accurate services. Additionally, the assistant can proactively confirm event information to avoid errors and omissions, greatly simplifying the calendar management process and improving work efficiency. It is suitable for professionals and teams that need to frequently schedule appointments.
Append, Lookup, Update, and Read Data from a Google Sheets Spreadsheet
This workflow enables automated management of Google Sheets spreadsheets, supporting data appending, searching, updating, and reading. Through secure OAuth2 authentication, users can easily query and dynamically update data based on specific conditions, reducing the hassle of manual maintenance and ensuring real-time accuracy of the data. It is suitable for various scenarios such as real estate, sales, and inventory management, significantly enhancing the efficiency and convenience of business data management, making it an ideal tool for improving office automation.
Intelligent Task and Schedule Management Assistant
The intelligent task and schedule management assistant utilizes natural language processing, combined with OpenAI GPT-4 and various sub-agents, to efficiently manage users' schedules and tasks. This system can automatically schedule Google Calendar events, create Notion tasks, and features contextual memory to ensure coherence in multi-turn conversations. By intelligently discerning user intent, it avoids scheduling conflicts and enhances work efficiency, making it an ideal choice for professionals and team collaboration.
Google Sheets Data Append and Read Automation Workflow
This workflow is designed to automate data entry and retrieval in Google Sheets. Users can manually trigger the process to quickly append preset unique identifiers and names to a specified spreadsheet, and then immediately read the latest data. This automation addresses the cumbersome and error-prone nature of manual input, enhancing the accuracy of data entry and work efficiency. It is suitable for team members to quickly update client, project, or task lists, facilitating subsequent data management and utilization.
MiniBear Webhook
MiniBear Webhook is an intelligent information processing tool that can automatically receive and categorize text, images, and audio messages sent by users through Line. It intelligently recognizes business card information and extracts structured data, while synchronizing important information to Microsoft Teams, Microsoft To Do, and OneDrive, enhancing the efficiency of information management and task tracking. With loading animation feedback and intelligent routing of various message types, users enjoy a better experience during use, reducing manual operations and improving work efficiency.