Email scheduled AWS Cost Explorer reports as CSV
Build a scheduled workflow that calls the AWS Cost Explorer API for a configurable period and grouping (e.g., by service or account). Transform the results into CSV, then email it to the configured recipient(s) with a short summary. Handle empty result sets, paginate large responses, retry throttled API calls, and avoid exposing credentials. Output the CSV file and confirmation that the email was sent.
What this prompt builds
Pull AWS Cost Explorer spend for a period and email it as a CSV for analysis.
The problem
Cloud spend visibility is locked in the AWS console where most stakeholders never look, so cost overruns are caught late. Manually exporting Cost Explorer data each month is tedious.
Solution and impact
This workflow queries Cost Explorer for a chosen period and emails a CSV of the spending data to a recipient. Finance and engineering get regular, analyzable cost reports without anyone logging into AWS.