Project Overview

Automated report generation system using n8n to process LinkedIn data files and generate Excel reports with metrics and analytics.

Architecture

Workflow Components

1. File Watcher — monitors directory for new CSV files
2. Python Script — processes data and generates reports
3. Email Notification — sends completion status and results

Technology Stack

• Orchestration: n8n (self-hosted v1.89.2)
• Data Processing: Python 3 + pandas
• File Formats: CSV input, Excel output
• Notification: SMTP Email

Workflow Design

File Watcher → Python Script → Email Notification

↘ Error Handler → Email

Node Configuration

File Watcher

• Path: /data/