Financial Q&A Chatbot: SerpAPI, Google Finance & OpenAI

This n8n workflow powers a conversational Financial Data Q&A Chatbot, starting with a Chat Trigger that captures user questions such as 'What's the current price of Tesla?' or 'Summarize S&P 500 performance.' It then uses an HTTP Request node to query SerpAPI's Google Finance endpoint, pulling live market data including prices, changes, and trends for tickers or indices.

Next, the OpenAI node processes the raw data alongside the user's query, crafting clear, conversational responses with context like percentages and comparisons. The output delivers polished answers ready for chat interfaces, Slack, or other channels. Benefits include instant access to accurate financial insights without manual research, reducing time spent on market checks and enabling scalable Q&A automation.

Ideal use cases span personal finance tracking, trading desks for quick lookups, investment newsletters, or daily market recaps. Customize by adding multi-ticker support, scheduling for automated reports, or integrating with email/Slack for distribution. Extend with news or company info via SerpAPI params, and tweak OpenAI prompts for formal reports or casual chats—saving hours weekly for finance pros.