Financial Data Q&a Chatbot with Google Finance, Serpapi, and Openai

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "nodes": [
    {
      "id": "19113e71-3a28-4741-b036-efc473d6c804",
      "name": "OpenAI Chat Model5",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        3216,
        8592
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-5-nano",
          "cachedResultName": "gpt-5-nano"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "44ad0df9-a6d0-417c-ab3e-4d20aa3c41c3",
      "name": "Simple Memory1",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        3536,
        8448
      ],
      "parameters": {
        "sessionKey": "={{ $('Sample Chatbot').item.json.sessionId }}",
        "sessionIdType": "customKey"
      },
      "typeVersion": 1.3
    },
    {
      "id": "7af7f3d7-f9b2-488a-a418-fbbe1a909ff3",
      "name": "Turn Objects to Text1",
      "type": "n8n-nodes-base.set",
      "position": [
        3008,
        8128
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "9578adb8-b0e3-4629-a375-8ac9585022f2",
              "name": "data",
              "type": "string",
              "value": "={{ $json.markets }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "85db5e3f-b21c-4cf4-814c-4d7312a9eed4",
      "name": "Sticky Note60",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2272,
        7936
      ],
      "parameters": {
        "color": 7,
        "width": 1488,
        "height": 928,
        "content": "# \ud83d\udcca Chat with Google Finance  \n\nThis workflow connects a chatbot to **live financial data** from SerpApi and uses OpenAI to answer questions.  \n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "a5719b06-a39b-4661-98cc-892b895128d6",
      "name": "Sticky Note17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1840,
        7936
      ],
      "parameters": {
        "width": 400,
        "height": 928,
        "content": "\n\n## \u2699\ufe0f Setup Instructions  \n\n### 1\ufe0f\u20e3 Add Your SerpApi Key  \n1. Create a free account at [SerpApi](https://serpapi.com/)  \n2. Copy your **API Key** from the dashboard  \n3. In the **HTTP Request (Finance Search)** node, update the URL:  \nhttps://serpapi.com/search.json?engine=google_finance&q=^GSPC&api_key=YOUR_API_KEY\n\nReplace `YOUR_API_KEY` with your actual SerpApi key.  \n\n### 2\ufe0f\u20e3 Set Up OpenAI Connection  \n1. Go to [OpenAI Platform](https://platform.openai.com/api-keys)  \n2. Navigate to [OpenAI Billing](https://platform.openai.com/settings/organization/billing/overview)  \n3. Add funds to your billing account  \n4. Copy your API key into the **OpenAI credentials** in n8n  \n\n---\n\n\n## \ud83d\udcec Contact  \nNeed help customizing this (e.g., multiple tickers, daily summaries, or sending reports to Google Sheets)?  \n\n\ud83d\udce7 **robert@ynteractive.com**  \n\ud83d\udd17 **[Robert Breen](https://www.linkedin.com/in/robert-breen-29429625/)**  \n\ud83c\udf10 **[ynteractive.com](https://ynteractive.com)**\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "b2603c21-3c4b-45fb-9e8c-7e730b2f9519",
      "name": "SerpAPI Finance Search1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2704,
        8544
      ],
      "parameters": {
        "url": "https://serpapi.com/search.json?engine=google_finance&q=^GSPC&api_key=YOUR_TOKEN_HERE",
        "options": {}
      },
      "typeVersion": 4.2
    },
    {
      "id": "28d8c26f-e9a1-4480-94b7-1fb114086ad9",
      "name": "Chat with Google Finance",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        3328,
        8096
      ],
      "parameters": {
        "text": "=question: {{ $('Sample Chatbot').item.json.chatInput }} market data: {{ $json.data }}",
        "options": {
          "systemMessage": "=You are a helpful assistant. Take questions from the user and answer based on the market data. \n"
        },
        "promptType": "define"
      },
      "typeVersion": 2.2
    },
    {
      "id": "6f6507fe-fcc2-462c-a9ab-e8adb6e956e8",
      "name": "Sticky Note31",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3104,
        8416
      ],
      "parameters": {
        "color": 3,
        "width": 288,
        "height": 304,
        "content": "### 2\ufe0f\u20e3 Set Up OpenAI Connection\n1. Go to [OpenAI Platform](https://platform.openai.com/api-keys)  \n2. Navigate to [OpenAI Billing](https://platform.openai.com/settings/organization/billing/overview)  \n3. Add funds to your billing account  \n4. Copy your API key into the **OpenAI credentials** in n8n  "
      },
      "typeVersion": 1
    },
    {
      "id": "10e3b585-6d7d-4fb3-aedd-9c0fb56d0062",
      "name": "Sticky Note32",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2608,
        8256
      ],
      "parameters": {
        "color": 3,
        "width": 272,
        "height": 432,
        "content": "### 1\ufe0f\u20e3 Add Your SerpApi Key  \n1. Create a free account at [SerpApi](https://serpapi.com/)  \n2. Copy your **API Key** from the dashboard  \n3. In the **HTTP Request (Finance Search)** node, update the URL:  \nhttps://serpapi.com/search.json?engine=google_finance&q=^GSPC&api_key=YOUR_API_KEY\n\n\ud83d\udc49 Replace `YOUR_API_KEY` with your actual SerpApi key.  \n"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "Simple Memory1": {
      "ai_memory": [
        [
          {
            "node": "Chat with Google Finance",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model5": {
      "ai_languageModel": [
        [
          {
            "node": "Chat with Google Finance",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Turn Objects to Text1": {
      "main": [
        [
          {
            "node": "Chat with Google Finance",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "SerpAPI Finance Search1": {
      "main": [
        [
          {
            "node": "Turn Objects to Text1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• openAiApi

About this workflow

Replace with your actual SerpApi key. Go to OpenAI Platform Navigate to Billing and ensure your account has credits/funding Copy your API Key into the OpenAI credentials in n8n Chat Trigger → User enters a financial question (e.g., “What’s the current price of Tesla?”). HTTP…

Source: https://n8n.io/workflows/7743/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.