The Multi-API Business Intelligence Dashboard is an end-to-end AI-powered automation workflow built using n8n. It demonstrates how modern automation platforms integrate multiple external services, process live data, and generate intelligent business reports automatically.
The workflow retrieves real-time information from multiple public APIs, consolidates the data into a unified dataset, performs AI-powered analysis using a locally hosted Ollama Llama 3.2 model, and produces a structured Business Intelligence report.
This project was developed as part of my AI Automation & Workflow Engineering learning journey to gain practical experience in workflow automation, API orchestration, event-driven systems, and AI-powered business intelligence.
- Build a complete visual automation using n8n
- Integrate multiple REST APIs
- Process and transform JSON responses
- Merge data from multiple services
- Generate AI-powered business insights
- Create an automated Business Intelligence report
- Understand event-driven workflow automation
- Learn professional automation engineering practices
Manual Trigger
│
┌──────────────────┼──────────────────┐
│ │ │
▼ ▼ ▼
Weather API Currency API Crypto API
│ │ │
▼ ▼ ▼
Process Weather Process Currency Process Crypto
└──────────────────┼──────────────────┘
▼
Merge API Data
│
▼
Generate AI Summary
(Ollama Llama 3.2)
│
▼
Prepare Dashboard Report
│
▼
Business Intelligence Report
- Live Weather Information
- Real-time Currency Exchange Rates
- Cryptocurrency Market Monitoring
- AI-powered Business Intelligence
- JSON Data Processing
- Multi-API Integration
- Visual Workflow Automation
- Local AI Processing using Ollama
- Structured Business Reports
- End-to-End Automated Pipeline
| Technology | Purpose |
|---|---|
| n8n | Workflow Automation |
| Ollama | Local AI Model Runtime |
| Llama 3.2 | AI Report Generation |
| REST APIs | Data Collection |
| JSON | Data Exchange |
| HTTP Request Nodes | API Communication |
| Merge Node | Data Consolidation |
| Edit Fields Node | Data Transformation |
Provides:
- Temperature
- Weather Condition
- Wind Speed
Provides:
- USD Exchange Rate
- EUR Exchange Rate
- GBP Exchange Rate
- JPY Exchange Rate
Provides:
- Bitcoin Price
- Ethereum Price
- Market Trends
The collected information is processed by a locally hosted Ollama Llama 3.2 model to generate:
- Executive Summary
- Key Observations
- Market Highlights
- Business Intelligence Insights
This section demonstrates the complete development lifecycle of the Multi-API Business Intelligence Dashboard, from creating the initial workflow to generating the final AI-powered business intelligence report.
The project begins with a clean n8n workspace. At this stage, a new workflow is created to serve as the foundation for building the automation pipeline.
A Manual Trigger node is added as the starting point of the workflow. This allows the automation to be executed manually during development and testing before introducing scheduled or event-driven triggers.
The Weather API is integrated to retrieve real-time environmental data, including temperature, weather conditions, and wind speed. This information forms the first data source for the business intelligence report.
The raw weather response is transformed into a clean and structured JSON object by extracting only the required fields. This simplifies downstream processing and improves workflow readability.
The Currency Exchange API is connected to retrieve live exchange rates. The workflow collects values for major currencies, providing real-time financial information for the final report.
The workflow processes the currency response by selecting the required exchange rates and restructuring the data into a standardized format suitable for merging with other datasets.
A Cryptocurrency Market API is integrated to fetch the latest Bitcoin and Ethereum market information, including current prices and daily market performance.
The cryptocurrency response is cleaned and transformed by extracting relevant market metrics. This ensures consistency across all integrated datasets before consolidation.
Information collected from the Weather, Currency, and Cryptocurrency APIs is merged into a single unified dataset. This consolidated object serves as the input for AI-powered business analysis.
At this stage, the workflow successfully connects multiple external services, processes the collected information, and prepares a unified dataset for intelligent analysis.
The consolidated dataset is sent to a locally hosted Ollama Llama 3.2 model. The AI analyzes the collected information and generates an executive business intelligence summary containing market insights and observations.
The AI-generated insights are formatted into a structured dashboard report. This stage converts raw AI output into a clean and readable report suitable for business users.
The workflow produces the final Business Intelligence report by combining processed API data with AI-generated analysis. This represents the complete automated reporting output of the system.
The completed workflow demonstrates an end-to-end automation pipeline that integrates multiple public APIs, performs data transformation, leverages a local AI model for intelligent analysis, and generates a comprehensive Business Intelligence report.
Manual Trigger
│
▼
Weather API
│
▼
Process Weather Data
│
▼
Currency API
│
▼
Process Currency Data
│
▼
Cryptocurrency API
│
▼
Process Crypto Data
│
▼
Merge API Data
│
▼
Generate AI Summary (Ollama)
│
▼
Prepare Dashboard Report
│
▼
Business Intelligence Report
Through this project, I learned:
- Workflow Thinking
- Event-Driven Automation
- n8n Workflow Development
- REST API Integration
- JSON Transformation
- Multi-API Orchestration
- Local AI Integration
- Automation Architecture
- Workflow Debugging
- Business Intelligence Automation
- Scheduled Daily Execution
- Email Notifications
- Telegram Integration
- Slack Notifications
- Database Storage
- Dashboard Visualization
- Historical Analytics
- AI Trend Prediction
- Error Notifications
- Workflow Monitoring
Abdul Qadeer
Cloud & AI Automation Engineering Learner
If you found this project helpful, consider giving it a Star ⭐ on GitHub.