Analyze business data from Google Sheets with an OpenAI chatbot

Business Data Analyst Chatbot

Overview

This workflow is a chat-based Business Data Analyst Chatbot built in n8n.

It allows users to ask business questions in plain English and receive clean, stakeholder-friendly insights based on data stored in one or more connected Google Sheets.

The workflow uses an AI Agent connected to:

- An LLM for reasoning and response generation - Memory for conversational context - Google Sheets tools for retrieving spreadsheet data - Edit Fields for formatting the final chat response - Chat Response node for sending the answer back to the user

This workflow is useful for experimenting with conversational business intelligence, spreadsheet analysis, AI agents, and tool-based automation.

Example questions users can ask: