Communication
Archive Gmail messages with automatic data logging and file storage
14 nodes
276
90
Scheduled trigger
Workflow Description
Scheduled automation that retrieves new Gmail messages, extracts sender and subject information while removing duplicates, logs all data to a Google Sheets spreadsheet, and stores attachments in a designated Google Drive folder for centralized email management.
How it works
- 1.Retrieve new messages from Gmail on a defined schedule
- 2.Extract and deduplicate email metadata and attachments
- 3.Log records to Google Sheets and save files to Google Drive
Use cases
- Maintain a searchable database of all incoming emails and contacts
- Automatically backup important invoices and attachments to cloud storage
- Create audit trails and communication records for compliance
Requirements
- Active Gmail account with API access
- Google Workspace account with Sheets and Drive permissions
- Full folder access in Google Drive for attachment storage
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Gmail
Remove Duplicates
Google Sheets
Google Drive
Details
Trigger
Scheduled trigger
Nodes
14
Apps
4
Views
276
Downloads
90
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (14)
/
Schedule Trigger
Schedule Trigger
Get Hash of Contents
Crypto
Notify of Change
Gmail
Markdown
Markdown
Variables
Set
Only New Hashes
Remove Duplicates
Log Record
Google Sheets
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Fetch Webpage
HTTP Request
Extract Contents
HTML Page
Sticky Note2
Sticky Note
Take a Snapshot
Google Drive
Sticky Note3
Sticky Note