# Analyze Google Sheets data via chat: KPIs, trends, anomalies
This automation enables fast extraction of analytical insights from Google Sheets by simply sending a link in a chat. Powered by a LangChain agent with OpenAI, the system loads and interprets spreadsheet data, automatically identifying key metrics, trends, and anomalies—no SQL, Excel formulas, or manual analysis required.
## Who it´s for
- Analysts who need quick insights from Google Sheets
- Sales managers tracking KPIs in spreadsheets
- Technical specialists analyzing telemetry or logs in CSV format
- Executives seeking automated analytics without SQL or Excel
## What the automation does
- Triggers on a chat message containing a Google Sheets URL
- Validates file access and checks data structure
- Uses a LangChain agent with memory and tools to read data via Google Sheets API
- Analyzes content: calculates KPIs, identifies trends, distributions, and anomalies
- Generates natural language summaries using OpenAI
- Returns structured insights with key findings and interpretation
## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on chat_message
- Integrations with Google Sheets and OpenAI via LangChain
- Basic textual guide for setup and adaptation
## Requirements for setup
- Google account with Google Sheets API access
- OpenAI API key
- Running n8n instance
- Permission to access external spreadsheets (when sharing links)
## Benefits and outcomes
- Saves time on manual data analysis
- Enables instant access to insights without technical skills
- Automatically detects anomalies and key changes
- Reduces dependency on analysts for basic reporting
- Supports data-driven decision-making with up-to-date information
- Scalable: one template works across multiple sheets
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet