Ai Data Analyst Agent For Spreadsheets With Nocodb

About This Script

Features:

• Makes HTTP requests to external APIs

{
    "nodes": [
        {
            "id": "e0abec7d-6753-42ed-8339-e1ad612797ac",
            "name": "Chat Trigger",
            "type": "@n8n/n8n-nodes-langchain.chatTrigger",
            "position": [
                40,
                360
            ],
            "webhookId": "cd05f517-9aec-4e7d-bba8-3747bc8f5ddb",
            "parameters": [],
            "typeVersion": 1
        },
        {
            "id": "9502381d-518a-4eff-a439-c9efdff782b6",
            "name": "Window Buffer Memory",
            "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
            "position": [
                1000,
                600
            ],
            "parameters": {
                "sessionKey": "={{ $('Chat Trigger').item.json.sessionId }}",
                "sessionIdType": "customKey",
                "contextWindowLength": 10
            },
            "typeVersion": 1.3
        },
        {
            "id": "08621d63-9067-4a92-b6c8-ba129c6adfa0",
            "name": "Extract_Columns",
            "type": "n8n-nodes-base.set",
            "position": [
                640,
                360
            ],
            "parameters": {
                "options": [],
                "assignments": {
                    "assignments": [
                        {
                            "id": "c5d1f5ab-91dd-4067-ad51-7707ef1ec8bb",
                            "name": "columns",
                            "type": "string",
                            "value": "={{ $json.columns.map(item => item.title).toJsonString() }}"
                        }
                    ]
                }
            },
            "typeVersion": 3.4
        },
        {
            "id": "2ee6401a-a45c-4c81-83b5-3995a9a25118",
            "name": "NocoDB",
            "type": "n8n-nodes-base.nocoDbTool",
            "position": [
                1200,
                600
            ],
            "parameters": {
                "table": "={{ $('Settings').item.json.table_id }}",
                "options": {
                    "where": "={{ $fromAI('filter_formula','formula to filter.  for example, (Ticker,eq,IMMR) will filter for Ticker column equal to IMMR.  the operators are neq for not equal, gt for greater than, etc.  Compound conditions can be expressed like (MCAP,gt,500000000)~or(MCAP,lt,1000000000)') }}"
                },
                "operation": "getAll",
                "projectId": "ppltdbh6c0a30cj",
                "workspaceId": "wse2vl0o",
                "authentication": "nocoDbApiToken"
            },
            "credentials": {
                "nocoDbApiToken": {
                    "id": "3fz98VcO6Z5iU2YT",
                    "name": "NocoDB Token account"
                }
            },
            "typeVersion": 3
        },
        {
            "id": "8e8ce2e3-890a-46cd-a95e-0c355dde8c06",
            "name": "Settings",
            "type": "n8n-nodes-base.set",
            "position": [
                240,
                360
            ],
            "parameters": {
                "options": [],
                "assignments": {
                    "assignments": [
                        {
                            "id": "968e6040-5ff3-40d1-901a-ba1fa7576c0c",
                            "name": "table_id",
                            "type": "string",
                            "value": "m7c7lrw7n0bne4j"
                        }
                    ]
                }
            },
            "typeVersion": 3.4
        },
        {
            "id": "3a986007-32dd-4152-93ca-d8a435603708",
            "name": "nocodb_extract_table",
            "type": "n8n-nodes-base.httpRequest",
            "position": [
                440,
                360
            ],
            "parameters": {
                "url": "=https://app.nocodb.com/api/v2/meta/tables/{{ $json.table_id }}",
                "options": [],
                "authentication": "predefinedCredentialType",
                "nodeCredentialType": "nocoDbApiToken"
            },
            "credentials": {
                "nocoDbApiToken": {
                    "id": "3fz98VcO6Z5iU2YT",
                    "name": "NocoDB Token account"
                }
            },
            "typeVersion": 4.2
        },
        {
            "id": "2c594b59-95db-4fd9-bea3-06a861de9766",
            "name": "Data Analyst Agent",
            "type": "@n8n/n8n-nodes-langchain.agent",
            "position": [
                900,
                360
            ],
            "parameters": {
                "text": "={{ $('Chat Trigger').item.json.chatInput }}",
                "options": {
                    "systemMessage": "=You are a helpful Data Analyst assistant who is skilled at working with a database called nocodb.  \n\nYou goal is to help the user understand the table that is specified.\n\nHere are the column names for the table.\n{{ $json.columns }}"
                },
                "promptType": "define"
            },
            "typeVersion": 1.7
        },
        {
            "id": "6b786282-8782-430b-852a-c60b94e05493",
            "name": "Sticky Note",
            "type": "n8n-nodes-base.stickyNote",
            "position": [
                200,
                280
            ],
            "parameters": {
                "color": "#FFF59D",
                "width": 580,
                "height": 280,
                "content": "Configuration note: update with your credentials or endpoint."
            },
            "typeVersion": 1
        },
        {
            "id": "77cd95ff-dece-4770-9d38-a9cacc174368",
            "name": "OpenAI Chat Model",
            "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
            "position": [
                840,
                600
            ],
            "parameters": {
                "model": "gpt-4o",
                "options": []
            },
            "credentials": {
                "openAiApi": {
                    "id": "DBb9a7OM4pzdAuDR",
                    "name": "Derek Cheung"
                }
            },
            "typeVersion": 1
        }
    ],
    "connections": {
        "NocoDB": {
            "ai_tool": [
                [
                    {
                        "node": "Data Analyst Agent",
                        "type": "ai_tool",
                        "index": 0
                    }
                ]
            ]
        },
        "Settings": {
            "main": [
                [
                    {
                        "node": "nocodb_extract_table",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Chat Trigger": {
            "main": [
                [
                    {
                        "node": "Settings",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Extract_Columns": {
            "main": [
                [
                    {
                        "node": "Data Analyst Agent",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "OpenAI Chat Model": {
            "ai_languageModel": [
                [
                    {
                        "node": "Data Analyst Agent",
                        "type": "ai_languageModel",
                        "index": 0
                    }
                ]
            ]
        },
        "Window Buffer Memory": {
            "ai_memory": [
                [
                    {
                        "node": "Data Analyst Agent",
                        "type": "ai_memory",
                        "index": 0
                    }
                ]
            ]
        },
        "nocodb_extract_table": {
            "main": [
                [
                    {
                        "node": "Extract_Columns",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        }
    },
    "n8n_version": "1.5.0"
}

Requirements