Get Started
Back to Templates

Analyze, Interpret & Visualize Data from Multiple Sources with Ada AI

Created by

Created by: Ada || ada

Ada

Last update

Last update 13 hours ago

Categories

Share

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:

  1. 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.

apply_apikey_1.png

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

apply_apikey_2.png

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.

apply_apikey_3.png

  1. Set credentials

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

Choose Header Auth → Create new credential
set_credentials_2.png

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

  1. Data Source:

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

  1. AI Skills:

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

  1. Result Processing:

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

  1. 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.