Build Your First AI Data Analyst Chatbot

n8n template #3050

Summary

Enhance your data analysis by connecting an AI Agent to your dataset, using n8n tools. This template teaches you how to build an AI Data Analyst Chatbot that is capable of pulling data from your sources, using tools like Google Sheets or databases. It's designed to be easy and efficient, making it a good starting point for AI-driven data analysis. You can easily replace the current Google Sheets tools for databases like Postgres or MySQL. How It Works The core of the workflow is the AI Agent. It's connected to different data retrieval tools, to get data from Google Sheets (or your preferred database) in many different ways. Once the data is retrieved, the Calculator tool allows the AI to per

How to set it up

Open template #3050 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create a credential under Credentials → Add credential: OpenAI Chat Model. Then open each of those nodes and pick the credential.
Check the model in the AI Agent node. The template may point at a model your account can't use; swap it for one you have access to.
Click Execute workflow and step through each node's output to confirm the data looks right.
Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "Build Your First AI Data Analyst Chatbot" (https://n8n.io/workflows/3050). It uses: HTTP Request, Code, AI Agent, OpenAI Chat Model, Simple Memory, Calculator, Call n8n Workflow Tool. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

HTTP Request Code AI Agent OpenAI Chat Model Simple Memory Calculator Call n8n Workflow Tool

Questions

Yes. Solomon published it free on n8n.io as a verified creator, and it has 134K views. It runs on n8n Cloud or a self-hosted n8n instance.

OpenAI Chat Model. The other 6 nodes are built into n8n.

Similar workflows

NameViews