n8nflow.net logo

Manage AWS S3 with GPT-4 Agent and Google Sheets Audit Logging via Slack

by Trung TranUpdated: Last update 16 days agoSource: n8n.io

Getting Started

AI-Powered AWS S3 Manager with Audit Logging in n8n (Slack/ChatOps Workflow)

This n8n workflow empowers users to manage AWS S3 buckets and files using natural language via Slack or chat platforms. Equipped with an OpenAI-powered Agent and integrated audit logging to Google Sheets, it supports operations like listing buckets, copying/deleting files, managing folders, and automatically records every action for compliance and traceability.

👥 Who’s it for

This workflow is built for:

  • DevOps engineers who want to manage AWS S3 using natural chat commands.
  • Technical support teams interacting with AWS via Slack, Telegram, etc.
  • Automation engineers building ChatOps tools.
  • Organizations that require audit logs for every cloud operation.

Users don’t need AWS Console or CLI access — just send a message like “Copy file from dev to prod”.

⚙️ How it works / What it does

This workflow turns natural chat input into automated AWS S3 actions using an OpenAI-powered AI Agent in n8n.

🔁 Workflow Overview:

  1. Trigger : A user sends a message in Slack, Telegram, etc.
  2. AI Agent :
    • Interprets the message
    • Calls one of 6 S3 tools:
      • ListBuckets
      • ListObjects
      • CopyObject
      • DeleteObject
      • ListFolders
      • CreateFolder
  3. S3 Action : Performs the requested AWS S3 operation.
  4. Audit Log : Logs the tool call to Google Sheets using AddAuditLog:
    • Includes timestamp, tool used, parameters, prompt, reasoning, and user info.

🛠️ How to set up

Step-by-step Setup:

  1. Webhook Trigger

    • Slack, Telegram, or custom chat platform → connects to n8n.
  2. OpenAI Agent

    • Model: gpt-4 or gpt-3.5-turbo
    • Memory: Simple Memory Node
    • Prompt: Instructs agent to always follow tool calls with an AddAuditLog call.
  3. AWS S3 Nodes

    • Configure each tool with AWS credentials.
    • Tools:
      • getAll: bucket
      • getAll: file
      • copy: file
      • delete: file
      • getAll: folder
      • create: folder
  4. Google Sheets Node

    • Sheet: AWS S3 Audit Logs
    • Operation: Append or Update Row
    • Columns (must match input keys):
      • timestamp, tool, status, chat_prompt, parameters, user_name, tool_call_reasoning
  5. Agent Tool Definitions

    • Include AddAuditLog as a 7th tool.
    • Agent calls it immediately after every S3 action (except when logging itself).

✅ Requirements

  • n8n instance with AI Agent feature
  • OpenAI API Key
  • AWS IAM user with S3 access
  • Google Sheet with required columns
  • Chat integration (Slack, Telegram, etc.)

🧩 How to customize the workflow

FeatureCustomization Tip
🌎 Multi-region S3Let users include region in the message or agent memory
🛡️ Restricted actionsUse memory/user ID to limit delete/copy actions
📁 Folder filteringExtend ListObjects with prefix/suffix filters
📤 Upload fileAdd PutObject with pre-signed URL support
🧾 Extra loggingAdd IP, latency, error trace to audit logs
📊 ReportingLink Google Sheet to Looker Studio for audit dashboards
🚨 Security alertsNotify via Slack/Email when DeleteObject is triggered