Automated AWS security & compliance audit to Google Sheets
Build a scheduled workflow that enumerates AWS resources across the account: S3 bucket public access and encryption, EC2 security group ingress rules, EC2 instance metadata/IMDS settings, IAM credential age and MFA, and EBS volume encryption. Evaluate each against a compliance baseline and collect findings with severity. Write a formatted Google Sheet workpaper (tabs per resource type) with timestamps. Paginate across regions, handle access-denied gracefully, and retry throttling. Output the audit summary and the Google Sheet link.
What this prompt builds
Audit S3, EC2, IAM, and EBS for misconfigurations and export a formatted Google Sheets workpaper.
The problem
Cloud security audits are point-in-time, manual, and inconsistent, so risky S3 buckets, open security groups, and stale IAM credentials persist between reviews. Producing audit evidence by hand eats analyst days.
Solution and impact
This workflow programmatically audits AWS S3 buckets, EC2 security groups and instances, IAM credentials, and EBS volumes, then writes a formatted findings workpaper to Google Sheets. Audits become repeatable, comprehensive, and instantly documented for reviewers.