AI based Data Analysis, Data Visualization and Data Report with Ada.im

How it works:

This template demonstrates how to build a low-code, AI-powered data analysis workflow in n8n. It enables you to connect to various data sources (such as MySQL, Google Sheets, or local files), process and analyze structured data, and generate natural language insights and visualizations using external AI APIs.

Key Features:

Flexible data source selection (MySQL, Google Sheets, Excel/CSV, etc.)

AI-driven data analysis, interpretation, and visualization via HTTP Request nodes

Automated email delivery of analysis results (Gmail node)

Step-by-step sticky notes for credential setup and workflow customization

Step-by-step: Apply for an API Key

You can easily create and manage your API Key in the ADA official website - API. To begin with, You need to register for an ADA account.

Once on the homepage, click the bottom left corner to access the API management dashboard.

Here, you can create new APIs and set the credit consumption limit for each API. A single account can create up to 10 APIs.

After successful creation, you can copy the API Key to set credentials. You can also view the credit consumption of each API and manage your APIs.

Set credentials

In HTTP nodes(DataAnalysis, DataInterpretation, and DataVisualization) select Authentication → Generic Credential Type

Choose Header Auth → Create new credential

Name the header Authorization, which must be exactly 'Authorization', and fill in the previously applied API key

Data Source:

The workflow starts by extracting structured data from your chosen source (e.g., database, spreadsheet, or file).

AI Skills:

Data is sent to external AI APIs for analysis, interpretation, and visualization, based on your configured queries.

Result Processing:

The AI-generated results are converted to HTML or Markdown as needed.

Output:

The final report or visualization is sent via email. You can easily adapt this step to other output channels.

API Keys Required:

Ada API Key: For AI data analysis

Gmail OAuth2: For sending emails (if using Gmail node)

(Optional) Data source credentials: For MySQL, Google Sheets, etc.