AI Agent for AWS Lambda Management and Google Sheets Audit Logging - n8n Workflow

Cloud engineers and DevOps teams seeking a simple, chat-based interface for routine AWS Lambda operations.
Compliance and operations teams requiring automatic, verifiable audit logs of cloud actions.
Developers who want to leverage the power of an n8n workflow agent (GPT-4.1 mini) to interact with infrastructure.
Users looking for advanced n8n templates that combine AI, cloud services, and database logging.

Managing AWS Lambda functions often requires complex interactions with the AWS Console or CLI. This sophisticated n8n workflow solves this by providing a unified, chat-driven interface. By using the n8n agent capabilities powered by the OpenAI Chat Model (GPT-4.1 mini), users can simply ask to list, invoke, get details about, or even delete Lambda functions using natural language. The critical value of this n8n automation lies in its adherence to compliance: the Agent is strictly configured to execute an Audit Logs step, recording every single action taken—function name, operation type, and timestamp—into a Google Sheet. This makes the entire operation transparent and auditable, proving the power of this advanced n8n template for secure DevOps tasks.

This powerful n8n workflow is initiated by a specialized n8n trigger:

1. Trigger Event: The workflow starts with the When chat message received n8n trigger. Any message sent to the connected chat interface activates the automation.


2. Intent Analysis: The input is immediately passed to the AWS Lambda Manager Agent. This agent, powered by the OpenAI Chat Model (gpt-4.1-mini) and aided by Simple Memory for context, interprets the user's intent (e.g., 'list functions', 'delete function', 'invoke function').


3. Tool Execution: Based on the interpretation, the n8n agent calls one of the specialized AWS Lambda n8n node tools (Invoke Lambda Function, List Lambda Functions, Get Lambda Function, or Delete a Function). Crucially, the agent confirms destructive actions (like deletion) before execution.


4. Mandatory Audit Logging: Immediately following the execution of any AWS Lambda action, the agent's system prompt mandates the call of the Audit Logs n8n node. This tool appends a record of the performed action, the function involved, and the result into a designated Google Sheet, ensuring a complete audit trail.


5. Response: The agent synthesizes the results of the tool usage and returns a concise, action-focused response back to the user via the chat interface, completing the loop of this sophisticated n8n workflow.

To deploy this comprehensive n8n workflow, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON code and paste it into your n8n instance to create a new n8n workflow.


2. OpenAI Credential Setup: Configure the OpenAI Chat Model n8n node with valid API keys for access to the language model (gpt-4.1-mini).


3. AWS Credential Setup: Configure the AWS credentials for the Lambda management n8n node tools. Ensure the IAM user associated with these credentials has the necessary permissions (lambda:ListFunctions, lambda:InvokeFunction, lambda:GetFunction, lambda:DeleteFunction). Note that Invoke Lambda Function uses a separate AWS credential from the HTTP Request tools.


4. Google Sheets Setup: Configure the Audit Logs n8n node with Google Sheets OAuth2 credentials. You must specify the Document ID and Sheet Name where the audit data will be recorded.


5. Agent Customization: Review the system prompt in the AWS Lambda Manager Agent n8n node to ensure it aligns with your operational rules.


6. Activate: Enable the n8n workflow and connect the chat trigger to your desired messaging platform.

When chat message received (n8n trigger): This is the starting n8n trigger for the entire automation. It initiates the n8n workflow whenever a user sends a message to the connected chat service, feeding the user's request into the AI agent.
OpenAI Chat Model (n8n node): Acts as the underlying Large Language Model (configured for gpt-4.1-mini). It provides the intelligence for the agent to understand complex natural language requests and determine tool usage.
Simple Memory (n8n node): Provides conversational context, allowing the AWS Lambda Manager Agent to maintain continuity across multiple chat turns.
AWS Lambda Manager Agent (n8n node): The core intelligence unit. It handles prompt engineering and manages the execution flow, ensuring rules—like mandatory audit logging and confirming deletions—are followed throughout the n8n workflow.
Invoke Lambda Function (n8n node): A dedicated n8n node tool that runs a specified AWS Lambda function with a payload extracted by the AI from the user's message.
List Lambda Functions, Get Lambda Function, Delete a Function (n8n node - HTTP Request Tool): These standard n8n node tools are used to interact with the AWS Lambda API for discovery, configuration retrieval, and permanent removal of functions, all driven by the agent's instructions.

• Audit Logs (n8n Google Sheets Tool): This crucial n8n node ensures compliance. Configured with the appendOrUpdate operation, it automatically records every Lambda action into a Google Sheet as mandated by the agent's system prompt.