{
  "name": "AI based data analysis, data visualization and data report with Ada.im",
  "nodes": [
    {
      "id": "a7749bc5-b86d-46da-ba17-cf5100b9e4d9",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -112,
        -48
      ],
      "parameters": {
        "width": 448,
        "height": 1536,
        "content": "## Data Source\nThese nodes extract structured data directly from your data source (e.g., MySQL, Google Sheets, Excel/CSV).\n\nSimply connect the data source nodes you need and disconnect any unused node"
      }
    },
    {
      "id": "0c0e3b3f-eca7-45df-88e6-d78e75a74348",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        528,
        304
      ],
      "parameters": {
        "width": 656,
        "height": 976,
        "content": "## Select the skills you need\nConnect the skill nodes you require\n\nYou need to apply for an API key according to the instructions, configure credentials, and set up Authentication in the DataAnalysis,"
      }
    },
    {
      "id": "49e02f24-acad-4bbc-8b5e-8c5b9f6e2c96",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1360,
        432
      ],
      "parameters": {
        "width": 336,
        "height": 848,
        "content": "## Output\n\nHere we use sending email as an example; you can choose the method that suits your needs."
      }
    },
    {
      "id": "8b01f685-f709-4d96-ad1a-3284b59911bb",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3552,
        304
      ],
      "parameters": {
        "width": 3088,
        "height": 4672,
        "content": "## Overview\nThis template empowers low-code data analysis using natural language. Simply connect to your data sources (e.g., MySQL, Google Sheets),\nand it automates the entire workflow—from data query"
      }
    },
    {
      "id": "31dd7694-9b33-449b-a868-ad7eb0ee39bf",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1120,
        576
      ],
      "parameters": {
        "width": 512,
        "height": 1536,
        "content": "## 2️⃣ Set credentials\n\nIn HTTP nodes(DataAnalysis, DataInterpretation, and DataVisualization) select Authentication → Generic Credential Type\n![set_credentials_1.png](https://d1551jsgrpwivo.cloudfron"
      }
    },
    {
      "id": "5b476c0b-0421-413e-b204-e4fc78f3f2b1",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2240,
        2944
      ],
      "parameters": {
        "width": 1088,
        "height": 224,
        "content": "## Consult\nContact us for inquiries or feedback.\n\nemail: n8n-plugin@ada.im\n\n[Discord](https://discord.com/invite/Bwd6zGYThS)\n\nExplore [Ada](https://ada.im/home?ada_data_=&utm_source=n8n&utm_medium=lan"
      }
    },
    {
      "id": "7d3fc1a9-161a-47d9-a58d-060b27035797",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2256,
        576
      ],
      "parameters": {
        "width": 1056,
        "height": 2336,
        "content": "## 1️⃣ Apply for an API Key\nYou can easily create and manage your API Key in the [ADA official website](https://ada.im/home?ada_data_=&utm_source=n8n&utm_medium=landingpage&utm_infeluncer=landingpage&"
      }
    },
    {
      "id": "48c2a3d7-8e19-4aa5-8cba-1a7c5eb02245",
      "name": "Start",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -400,
        672
      ]
    },
    {
      "id": "dba9567a-a7de-49a7-96ce-e2a1703046b4",
      "name": "Get data from database",
      "type": "n8n-nodes-base.mySql",
      "position": [
        32,
        864
      ]
    },
    {
      "id": "8c20ec24-64bc-422c-8c8a-ee76d3af6acb",
      "name": "Process Data",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        368,
        672
      ]
    },
    {
      "id": "4d9a4942-d1b5-47cb-a487-f2ba83ff05ed",
      "name": "Get data from Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        32,
        1056
      ]
    },
    {
      "id": "05495c74-f92f-42e4-b239-86117e027ba6",
      "name": "Get data from local file",
      "type": "n8n-nodes-base.readWriteFile",
      "position": [
        -48,
        1248
      ]
    },
    {
      "id": "e897fdef-13f5-413c-a2d3-e65e9e947c7b",
      "name": "Extract JSON from xlsx file",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        144,
        1248
      ]
    },
    {
      "id": "bac09d2b-05ea-4e4e-9f72-9db8b23ded15",
      "name": "DataAnalysis",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        592,
        672
      ]
    },
    {
      "id": "ec1c771c-060f-4f5f-bfcb-429ea1a2d32d",
      "name": "DataInterpretation",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        592,
        848
      ]
    },
    {
      "id": "fecfaf24-9059-430f-9ca4-0a346795f574",
      "name": "DataVisualization",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        592,
        1024
      ]
    },
    {
      "id": "414955a1-b38e-4c5d-8ec0-30784e577fae",
      "name": "Convert to HTML File",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        1008,
        1024
      ]
    },
    {
      "id": "f44342a9-5cee-48b3-8d01-c112cf985889",
      "name": "Convert markdown to HTML",
      "type": "n8n-nodes-base.markdown",
      "position": [
        1008,
        672
      ]
    },
    {
      "id": "e76a84a7-f3b5-41e1-8305-7452b307f64b",
      "name": "Convert markdown to HTML 2",
      "type": "n8n-nodes-base.markdown",
      "position": [
        1008,
        848
      ]
    },
    {
      "id": "4696a7f0-d343-41a1-9970-ac2b2ace165e",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1120,
        2160
      ],
      "parameters": {
        "width": 512,
        "height": 1168,
        "content": "## 3️⃣ Try out the skills\nSelect the data source and fill in the query parameters for the DataAnalysis, DataInterpretation, and DataVisualization nodes.\n![skills.png](https://d1551jsgrpwivo.cloudfront"
      }
    },
    {
      "id": "0a2f2313-ea14-4952-bfeb-4a8a62ce418b",
      "name": "Send DataAnalysis message",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1488,
        672
      ]
    },
    {
      "id": "a182dfc4-4136-4c3e-8594-8525f436c62e",
      "name": "Send DataInterpretation message",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1488,
        848
      ]
    },
    {
      "id": "ea24e9e8-ad8f-4e80-ba21-5e1d6f76a9ab",
      "name": "Send DataVisualization",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1488,
        1024
      ]
    },
    {
      "id": "eb402e49-c3d8-4507-aace-b80c79a3fa9a",
      "name": "Sample Data",
      "type": "n8n-nodes-base.code",
      "position": [
        32,
        672
      ]
    },
    {
      "id": "0ce0f4a8-0773-4b47-a049-80ed2b0eeb0d",
      "name": "Process Visualization Data",
      "type": "n8n-nodes-base.set",
      "position": [
        800,
        1024
      ]
    }
  ],
  "connections": {
    "Start": {
      "main": [
        [
          {
            "node": "Sample Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sample Data": {
      "main": [
        [
          {
            "node": "Process Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "DataAnalysis": {
      "main": [
        [
          {
            "node": "Convert markdown to HTML",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Data": {
      "main": [
        [
          {
            "node": "DataVisualization",
            "type": "main",
            "index": 0
          },
          {
            "node": "DataAnalysis",
            "type": "main",
            "index": 0
          },
          {
            "node": "DataInterpretation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "DataVisualization": {
      "main": [
        [
          {
            "node": "Process Visualization Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "DataInterpretation": {
      "main": [
        [
          {
            "node": "Convert markdown to HTML 2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to HTML File": {
      "main": [
        [
          {
            "node": "Send DataVisualization",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get data from database": {
      "main": [
        [
          {
            "node": "Process Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert markdown to HTML": {
      "main": [
        [
          {
            "node": "Send DataAnalysis message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get data from local file": {
      "main": [
        [
          {
            "node": "Extract JSON from xlsx file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert markdown to HTML 2": {
      "main": [
        [
          {
            "node": "Send DataInterpretation message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Visualization Data": {
      "main": [
        [
          {
            "node": "Convert to HTML File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract JSON from xlsx file": {
      "main": [
        [
          {
            "node": "Process Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get data from Google Sheets": {
      "main": [
        [
          {
            "node": "Process Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}