Build Your First AI Data Analyst Chatbot

Go to Workflow
133,537 views
Built by Solomon Solomon
Created on June 06, 2026

Description

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 perform mathematical operations, making your data analysis precise.

Who is this template for
Data Analysts & Researchers:** Pull data from different sources and perform quick calculations.
Developers & AI Enthusiasts:** Learn to build your first AI Agent with easy dataset access.
Business Owners:** Streamline your data analysis with AI insights and automate repetitive tasks.
Automation Experts:** Enhance your automation skills by integrating AI with your existing databases.

How to Set Up
You can find detailed instructions in the workflow itself.

Check out my other templates
👉 https://n8n.io/creators/solomon/

Nodes Used (7)

AI Agent
@n8n/n8n-nodes-langchain.agent
Calculator
@n8n/n8n-nodes-langchain.toolCalculator
Call n8n Workflow Tool
@n8n/n8n-nodes-langchain.toolWorkflow
Code
n8n-nodes-base.code
HTTP Request
n8n-nodes-base.httpRequest
OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow