Generate infrastructure cost optimization reports from AWS and GCP to Google Sheets and Slack

• Automate cost reporting for cloud services
• Identify potential savings in cloud infrastructure
• Log financial data into Google Sheets for analysis
• Notify teams about cost optimization opportunities via Slack

Triggers daily at 05:00 UTC to fetch AWS and GCP cost data Aggregates the fetched data to calculate total costs Analyzes the data to identify idle and orphaned resources Generates a markdown report detailing costs and potential savings Converts the markdown report to PDF format Logs the report data into Google Sheets Sends a notification to Slack about the report availability

1. 1
   Import the workflow template into n8n
2. 2
   Configure AWS and GCP credentials for cost fetching
3. 3
   Set up Google Sheets and Slack credentials
4. 4
   Adjust the sheet ID and range for logging costs
5. 5
   Test the workflow to ensure proper functionality