Organize email attachments into Google Drive folders by company with Gmail & Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Split Up Binary Data1 | Code node, mode 'Run Once for All Items' |
Worth a look
- Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (Gmail Trigger)
Nodes used (8)
- Google Drive
n8n-nodes-base.googleDrive - If
n8n-nodes-base.if - Gmail Trigger
n8n-nodes-base.gmailTrigger - Gmail
n8n-nodes-base.gmail - Function
n8n-nodes-base.function - Edit Fields (Set)
n8n-nodes-base.set - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets
What it does
Automated Email Attachment Organizer Automatically process labeled emails with attachments into organized Google Drive folders --- Who Is This For? - Teams or Individuals needing to: - Automatically sort invoices, receipts, and files. - Organize client documents by date. - Verify sender emails against a whitelist. - Timestamp files to avoid duplicate names. --- What Does This Workflow Solve? - 🕒 Manual Email Sorting: Saves time by automating the organization of email attachments. - 📂 Disorganized Cloud Storage: Ensures attachments are neatly stored in Google Drive folders. - 📧 Unverified Sender Issues: Filters and validates emails using a whitelist. - 🔄 Duplicate Filenames: Uses timestamps to ensure every file name is unique. --- Setup Guide 1. Pre-Requisites - Whitelist Sheet: Make a copy of the Example Whitelist Sheet - Gmail Filter: Create a filter in Gmail to label emails with attachments. To Create a Gmail Filter: 1. Open your Gmail Inbox. 2. Click the search bar and select "Show search options". 3. Enter your criteria (e.g., type has:attachment). 4. Click "Create filter". 5. Choose "Apply the label: CustomLabel" and save. --- 2. Credentials Setup Make sure your n8n instance is connected with: - Gmail Account: (via OAuth2) - Google Drive Account: (via OAuth2) - Google Sheets (via OAuth2) --- 3. Configure Your n8n Workflow Nodes 1. Trigger and Email Retrieval - Gmail Trigger: Setup check interval and filters for emails (i.e. emails labeled with CustomLabel) 2. Whitelist settings - Lookup in Sheets: Searches for a row with the sender email. Configure this node to point to your whitelist spreadsheet containing two columnds: |email|company| 3. File storage location - Confirue parent folder to create sub-folders and store files into in the Create Company Folder node Parent Folder dropdown --- Final Steps 1. Test Your Workflow: Run the workflow to verify emails are processed and files are uploaded correctly. --- Happy Automating!