How to Build an n8n AI Agent That Turns Data Into Beautiful Dashboards
Most businesses drown in spreadsheet data but struggle to extract meaningful insights. This n8n workflow connects your CRM, Google Sheets, or databases to an AI agent that generates interactive dashboards on demand - no coding required. See exactly how to set up the system that transforms raw numbers into visual stories.
The Data Visualization Problem
Businesses collect mountains of data - CRM entries, call logs, sales figures - but most of it sits unused in spreadsheets. At 3:17 in the video, you see a typical Google Sheet filled with call center metrics: numbers, dates, and status codes that require manual analysis to understand.
This creates three major problems:
- Time wasted manually creating reports from raw data
- Missed insights buried in rows and columns
- Slow decisions waiting for someone to analyze the numbers
83% of businesses report making decisions based on gut instinct rather than data, primarily because their data isn't accessible in a usable format.
n8n + Thesis.dev Solution
The solution combines n8n's automation power with Thesis.dev's generative UI to create an AI agent that:
- Connects directly to your data sources (Google Sheets, CRMs, databases)
- Interprets natural language queries ("Show me last week's performance")
- Generates interactive dashboards with charts, cards, and visualizations
At 5:42 in the video, you see the transformation - from a spreadsheet to a beautiful dashboard showing call volume trends, sentiment scores, and key metrics.
Step 1: Connect n8n to Thesis.dev
The first critical connection is between your n8n workflow and Thesis.dev's visualization API:
Key Insight: Instead of connecting directly to OpenAI, we route through Thesis.dev to get both AI analysis and visualization capabilities.
At 7:15 in the tutorial, you'll see how to:
- Create a free Thesis.dev account
- Generate an API key in the Thesis.dev dashboard
- Configure n8n's OpenAI node to use Thesis.dev's endpoint
The exact API endpoint you'll use is: https://api.thesis.dev/v1/embed
Step 2: Add Your Data Source
With the Thesis.dev connection established, we connect the AI agent to your actual business data. The demo uses Google Sheets, but you can connect:
- CRM systems (HubSpot, Salesforce)
- Databases (PostgreSQL, MySQL)
- Project tools (Airtable, Notion)
At 9:30 in the video, watch how to:
- Add the Google Sheets node in n8n
- Authenticate with your Google account
- Select the specific sheet and data range
- Enable the tool in your AI agent configuration
Step 3: Configure the AI Agent
The magic happens in the AI agent configuration (shown at 11:08):
- Memory: Add simple memory so the agent remembers past interactions
- Streaming: Enable response streaming for real-time updates
- Public Access: Make the chat publicly available for dashboard sharing
This creates an agent that:
- Understands context from previous questions
- Updates visualizations in real-time
- Can be shared with team members without n8n access
Step 4: Publish the Workflow
The final setup steps (shown at 12:45) ensure your dashboard system is live:
- Publish the n8n workflow to activate the AI agent
- Copy the public chat URL from n8n
- Paste it into Thesis.dev's n8n integration page
At this point, you can start asking questions like:
- "Show me last week's call volume compared to the previous 2 weeks"
- "What metrics improved the most over the last month?"
Real-World Dashboard Examples
Beyond call center metrics (shown at 14:20), this system works for:
Sales Teams: Visualize pipeline health, deal velocity, and rep performance
Marketing: Campaign performance across channels with ROI calculations
Operations: Inventory levels, fulfillment times, and supply chain bottlenecks
The AI agent automatically selects the most appropriate visualization type based on your query and data structure.
Watch the Full Tutorial
See the complete step-by-step implementation, including how to customize dashboard colors and layouts, in the full 14-minute tutorial below:
Key Takeaways
This n8n + Thesis.dev combination solves the "data rich but insight poor" problem facing most businesses:
In summary: Connect your existing data sources to an AI agent that generates beautiful, interactive dashboards on demand - no coding required. Transform spreadsheet numbers into visual stories that drive better business decisions.
Frequently Asked Questions
Common questions about n8n data dashboards
The n8n AI agent can connect to any data source with an API or integration, including Google Sheets, Airtable, CRMs like HubSpot or Salesforce, and databases.
The workflow demonstrated uses Google Sheets, but you can easily swap in other data sources by changing the tool connection in your n8n workflow. The key requirement is that the data is structured in a table format with clear column headers.
- Cloud apps: Google Sheets, Airtable, Notion
- CRMs: Salesforce, HubSpot, Zoho
- Databases: PostgreSQL, MySQL, MongoDB
No coding is required. The n8n workflow builder uses a visual interface to connect your data sources to the Thesis.dev visualization layer.
The most technical step is copying API keys, which we provide clear instructions for in the tutorial. Everything else is done through point-and-click configuration in n8n's visual workflow editor.
- No JavaScript or Python required
- Visual workflow builder handles all connections
- Clear documentation for each configuration step
The AI agent interprets natural language queries (like "show me last week's performance") and determines the most appropriate visualization format.
It also provides contextual analysis of trends and patterns in your data that would require manual calculation in traditional dashboards. For example, it can automatically detect seasonality patterns or correlations between metrics.
- Understands natural language questions
- Selects optimal chart types automatically
- Provides written analysis of trends
This system excels with time-series data (daily/weekly metrics), comparative metrics (performance across teams/products), and complex datasets with multiple variables.
The demo shows call center metrics, but it works equally well for sales pipelines, marketing campaigns, or operational KPIs. Any data that benefits from trend analysis or comparison between dimensions is a good candidate.
- Time-series: Daily sales, weekly active users
- Comparative: Team performance, product lines
- Multivariate: Marketing ROI, customer journeys
Yes, the Thesis.dev interface generates shareable URLs that team members can access without needing n8n accounts.
You can control access through Thesis.dev's permission settings while keeping your n8n workflow private. This means your data transformation logic stays secure while the visual outputs are shareable.
- Unlimited viewers with shareable links
- No n8n accounts required for dashboard viewers
- Role-based access controls available
Dashboards update in real-time when queries are made. For automated refreshes, you can add an n8n schedule trigger to your workflow that updates the visualization at set intervals (hourly, daily, etc.).
The data freshness depends on your source system. Google Sheets and cloud databases typically show updates within minutes, while some CRMs may have slight delays in their API updates.
- Real-time updates when queried
- Scheduled refreshes available
- Data latency depends on source system
n8n offers a free tier that supports this workflow. Thesis.dev has a free tier for testing, with paid plans starting at $29/month for professional use.
Total costs depend on your data volume and number of dashboard users. Most small businesses can run this system for under $50/month, while enterprises may need higher-tier plans for extensive usage.
- n8n: Free tier available
- Thesis.dev: Free trial, then $29+/month
- Scales with usage volume
GrowwStacks specializes in building custom n8n workflows that connect your business data to visualization tools like Thesis.dev.
We'll handle the entire setup - from data source connections to dashboard design - and train your team to create new visualizations. Our typical implementation includes:
- Complete workflow setup in 2-3 business days
- Custom dashboard templates for your key metrics
- Team training on creating new visualizations
Get Your Data Working For You - Not The Other Way Around
Stop wasting hours manually analyzing spreadsheets. Let us build you an n8n AI dashboard system that surfaces insights automatically - typically in under a week.