Detect AWS Orphaned Resources & Send Cost Reports to Slack, Email, and Sheets
Ready for 3.0What this workflow does
This workflow has 20 nodes and runs on a schedule (cron 0 8 * * 1). Along the way it connects Slack, Gmail, AWS Lambda and Google Sheets.
How it runs
Trigger: On a schedule (cron 0 8 * * 1).
- Initialize Config (Edit Fields (Set)): sets or maps fields
- Set Region Variables (Edit Fields (Set)): sets 2 fields: currentRegion, scanStartTime
- Scan unattached EBS Volumes (AWS Lambda): uses AWS Lambda
- Scan EBS Snapshots (AWS Lambda): uses AWS Lambda
- Scan Elastic IPs (AWS Lambda): uses AWS Lambda
- Process EBS Volumes (Code): runs custom JavaScript code
- Process Snapshots (Code): runs custom JavaScript code
- Process Elastic IPs (Code): runs custom JavaScript code
- Aggregate: combines items into one
- Calculate Summary Stats (Code): runs custom JavaScript code
…plus 9 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Rarely used nodes in this template: n8n-nodes-base.awsLambda
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Aggregate
n8n-nodes-base.aggregate - Code
n8n-nodes-base.code - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - AWS Lambda
n8n-nodes-base.awsLambda - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if
From the author
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…