Detect AWS Orphaned Resources & Send Cost Reports to Slack, Email, and Sheets

How it works

This workflow automatically scans AWS accounts for orphaned resources (unattached EBS volumes, old snapshots >90 days, unassociated Elastic IPs) that waste money. It calculates cost impact, validates compliance tags, and sends multi-channel alerts via Slack, Email, and Google Sheets audit logs.

Key Features: - 🔍 Multi-region scanning with parallel execution - 💰 Monthly/annual cost calculation with risk scoring - 📊 Professional HTML reports with charts and tables - 🏷️ Tag compliance validation (SOC2/ISO27001/HIPAA) - ✅ Conditional alerting (only alerts when resources found) - 📈 Google Sheets audit trail for trend analysis

What gets detected: - Unattached EBS volumes ($0.10/GB/month waste) - Snapshots older than 90 days ($0.05/GB/month) - Unassociated Elastic IPs ($3.60/month each)

Typical savings: $50-10K/month depending on account size

Set up steps

Prerequisites

AWS Configuration: 1. Create IAM user n8n-resource-scanner with these permissions: - ec2:DescribeVolumes - ec2:DescribeSnapshots - ec2:DescribeAddresses - ec2:DescribeInstances - lambda:InvokeFunction 2. Deploy Lambda function aws-orphaned-resource-scanner (Node.js 18+) 3. Add EC2 read-only permissions to Lambda execution role 4. Generate AWS Access Key + Secret Key