Monitor Google Drive files, send Gmail notifications, and log data to Sheets
Workflow Description
Automation that monitors a Google Drive folder, extracts file information, sends email notifications via Gmail, and logs all processing details in Google Sheets for centralized record-keeping and team coordination.
How it works
- 1.Monitor a specified Google Drive folder and retrieve file metadata
- 2.Process files in batches and apply conditional logic for filtering
- 3.Send email notifications to team members via Gmail with file details
- 4.Log all transaction records and processing data into Google Sheets
Use cases
- Track new project documents automatically while notifying the team in real time
- Archive important files and maintain a comprehensive activity log in a central spreadsheet
Requirements
- Google account with permissions for Drive, Gmail, and Sheets access
- Pre-configured Google Drive folder and Google Sheets spreadsheet
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
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 (19)
Search For Folder
Google Drive
Create Month Folder
Google Drive
Check If Folder Exists
If
Gmail Trigger
Gmail
Gmail
Gmail
Split Up Binary Data1
Function
Note2
Sticky Note
YYYY/MM
Set
Loop Over Items
Split In Batches
Note3
Sticky Note
Company Folder Exists
If
Create Company Folder
Google Drive
Note4
Sticky Note
Sticky Note4
Sticky Note
Lookup in Sheets
Google Sheets
Search Company Folder1
Google Drive
Sticky Note
Sticky Note
Sticky Note2
Sticky Note
Upload To Folder
Google Drive