Get Started
Back to Templates

Launch AWS EC2 Instances from Google Sheets using Terraform

Created by

Created by: Oneclick AI Squad || oneclick-ai

Oneclick AI Squad

Last update

Last update a day ago

Categories

Share

This automated n8n workflow enables launching AWS EC2 instances directly from a Google Sheets document. Users can specify instance details (e.g., region, instance type, key pair) in a Google Sheet, triggering the workflow to create EC2 instances via the AWS API. The workflow updates the sheet with instance information and sends confirmation emails.

Fundamental Aspects

  • Google Sheets Trigger: Initiates the workflow when a new row is added or updated in the Google Sheet.
  • Extract Instance Details: Parses region, instance type, key pair name, and instance name from the sheet.
  • Validate Inputs: Checks for required fields and valid AWS configurations.
  • Launch EC2 Instance: Uses the AWS EC2 API to launch the specified instance.
  • Update Google Sheet: Adds instance ID and status to the sheet.
  • Send Confirmation Email: Notifies the user via email with instance details.

Setup Instructions

  • Import the Workflow into n8n: Download the workflow JSON and import it via the n8n interface.
  • Configure API Credentials:
    • Set up Google Sheets API credentials with appropriate permissions.
    • Configure AWS IAM credentials with EC2 launch permissions.
    • Configure SMTP credentials for email notifications.
  • Prepare Google Sheet: Create a sheet with columns for region, instance type, key pair name, instance name, instance ID, and status.
  • Run the Workflow: Activate the Google Sheets trigger and test by adding a row with instance details.
  • Verify Responses: Check the Google Sheet for updated instance IDs and emails for confirmation.
  • Adjust Parameters: Fine-tune AWS region settings or email templates as needed.

Technical Dependencies

  • Google Sheets API: For reading and writing data.
  • AWS EC2 API: For launching and managing instances.
  • SMTP Service: For sending confirmation emails.
  • n8n: For workflow automation and integration.

Customization Possibilities

  • Add Instance Types: Support additional EC2 instance types.
  • Enhance Validation: Add checks for AWS limits or quotas.
  • Support Tags: Include custom tags for launched instances.
  • Add Logging: Integrate with a logging service for workflow tracking.
  • Customize Emails: Adjust email content or add attachments.