Automated AWS RDS Management via Email

This n8n workflow automates the management of AWS RDS databases triggered by email requests, integrating Gmail, Terraform, AWS, Google Sheets, and email notifications for seamless database provisioning and decommissioning. The process begins with monitoring Gmail for specific email commands to create or delete RDS instances. Once an email is received, the workflow parses its content to extract database details such as name, engine, instance class, and credentials. Based on the parsed instruction (create or delete), it connects via SSH to execute Terraform commands that provision or destroy the RDS instance according to predefined configurations. The workflow then logs the operation details into a Google Sheet for audit purposes and sends a confirmation email to the requester, providing database details and links to AWS Console. This setup is ideal for DevOps teams automating database lifecycle management or for organizations that need a self-service approach for database provisioning while maintaining structured logs and notifications.