AI data analyst agent and visualization agent for large spreadsheets

Purpose of workflow:

This workflow transforms spreadsheet data into an interactive, AI-powered knowledge base that enables users to gain deep insights through natural language queries, searchability, and comparative analysis.

How it works:

1. Data Storage & Integration:

• Spreadsheet data is imported into a no-code database (NocoDB)
• System connects with an AI data analyst agent
• Agent accesses table metadata and column information

2. Query Processing:

• Users input natural language questions
• AI agent interprets queries and converts them to database filters
• System retrieves relevant data using filter formulas
• AI synthesizes responses with analysis and insights

3. Advanced Capabilities:

• Performs comparative analysis across multiple data points
• Handles complex multi-part queries

4. Automatically creates visualizations:

• Visualization AI Agent figures out the data and the chart type and generates professional visualization using Quickchart

Step by step setup:

1. Create account on nocodb.com
2. Create table by importing csv, copy table id
3. Create API token https://app.nocodb.com/#/account/tokens
4. In workflow, settings node, update with table id
5. In NocoDB tool node, setup authentication with API token created in step 3
6. Specify the workspace and base fields after connecting to NocoDB