Community Contributed Google Sheets Template (Unverified)
detail.loadingPreview
Automates the process of organizing attachments from emails into Google Drive folders based on date and company. This template is community-contributed and currently unverified.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow is designed to process incoming emails, extract attachments, and store them in a structured Google Drive environment. It automatically creates year/month folders and company-specific folders to organize these attachments. The workflow starts by triggering on new emails in Gmail, retrieves email details and attachments, and then uses Google Drive nodes to manage folder creation and file uploads. It also includes a lookup against a Google Sheet to determine the company associated with the sender's email.
Key Features
- Triggers on new emails in a specific Gmail label.
- Extracts attachments from emails.
- Organizes attachments into Year/Month folders in Google Drive.
- Creates company-specific folders in Google Drive based on a Google Sheets whitelist.
- Uploads attachments to the appropriate Google Drive folders.
- Uses Google Sheets to map email addresses to company names for folder organization.
How To Use
- Configure Gmail Trigger: Set up the 'Gmail Trigger' node to monitor a specific Gmail label for new emails.
- Set up Google Sheets Whitelist: Create a Google Sheet with two columns: 'email' and 'company'. Populate it with email addresses and their corresponding company names. Configure the 'Lookup in Sheets' node to point to this spreadsheet and column.
- Google Drive Credentials: Ensure your Google Drive account is connected and authorized in n8n.
- Email to Drive Mapping: The workflow will automatically create Year/Month folders and company folders. Attachments from emails will be placed in the relevant company folder within the YYYY/MM structure.
- Adjust Folder IDs (if necessary): The 'Create Company Folder' node has a hardcoded
folderIdfor the 'Invoices' parent folder. You may need to adjust this to match your Google Drive structure.
Apps Used
Workflow JSON
{
"id": "f0f8eb1d-3654-4af1-bec6-f57619f57b24",
"name": "Community Contributed Google Sheets Template (Unverified)",
"nodes": 0,
"category": "Googlesheets",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: f0f8eb1d-3654...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Verification Info
Related Integrations
- Google Sheets + Schedule Trigger(394 workflows)
- Google Sheets + Split Out(277 workflows)
- Gmail + Schedule Trigger(270 workflows)
- Google Sheets + Slack(268 workflows)
- Gmail + Google Sheets(245 workflows)
- Google Drive + Google Sheets(203 workflows)
- Form Trigger + Google Sheets(163 workflows)
- Google Drive + Google Drive Trigger(135 workflows)
- Google Drive + Split Out(134 workflows)
- Gmail + Split Out(132 workflows)
Related Workflows
Discover more workflows you might like
Add New Incoming Emails to Google Sheets
Automatically log new incoming emails to a Google Sheets spreadsheet.
Community Contributed Google Sheets Template
This template helps generate metadata for community-contributed Google Sheets templates.
Community Contributed Template (Unverified)
Generates metadata for a community-contributed, unverified template from Google Sheets.
Typeform to Google Sheets with Conditional Notifications
This workflow triggers from Typeform submissions, appends data to Google Sheets, and sends notifications based on a severity threshold.
Community Google Sheet Reader
Reads data from a Google Sheet for community contributions.
Community Contributed Google Sheets (Unverified)
Retrieves data from a Google Sheet for community-contributed content that requires verification.