Generate AI Stock Buy/No-Buy Signals using GPT-4, Google Sheets, and EODHD

This n8n workflow automates the process of generating AI-powered stock buy/no-buy signals. It fetches stock data from a Google Sheet, enriches it with real-time market data from a financial API (like EODHD), and then uses an AI agent (GPT-4 via Langchain) to analyze the data and provide buy/no-buy recommendations. The results are then merged and can be used for further actions or reporting.

What it does

1. Triggers Manually: The workflow is initiated manually.
2. Reads Stock Tickers: It reads a list of stock tickers from a specified Google Sheet.
3. Loops Through Tickers: For each stock ticker, it performs the following steps:
   • Fetches Market Data: Makes an HTTP request to a financial API (e.g., EODHD) to retrieve real-time market data for the current stock ticker.
   • Prepares AI Prompt: Uses a Code node to format the stock ticker and market data into a prompt suitable for an AI agent.
   • Generates AI Signal: Sends the prepared prompt to an AI agent (configured to use an OpenAI Chat Model, likely GPT-4) to generate a buy/no-buy signal and a brief explanation.
4. Merges Results: After processing all stock tickers, it merges the original Google Sheet data with the AI-generated signals and market data.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Google Sheets Account: A Google Sheets spreadsheet containing a list of stock tickers.
• Financial Data API Key: An API key for a financial data provider (e.g., EODHD, as suggested by the directory name) to fetch real-time stock data.
• OpenAI API Key: An API key for OpenAI (e.g., for GPT-4 access) to power the AI Agent.
• Langchain Integration: Ensure the n8n Langchain nodes are installed and configured if not already.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the three dots in the top right corner and select "Import from JSON".
   • Paste the JSON code and click "Import".
2. Configure Credentials:
   • Google Sheets: Configure the "Google Sheets" node with your Google Sheets credentials. Specify the spreadsheet ID and sheet name where your stock tickers are listed.
   • HTTP Request (Financial API): Update the "HTTP Request" node.
     • Change the URL to your chosen financial API endpoint (e.g., EODHD API).
     • Add your API key as a query parameter or header as required by the API.
     • Adjust the data extraction if the API response structure differs.
   • AI Agent (OpenAI):
     • Configure the "OpenAI Chat Model" node with your OpenAI API key.
     • Ensure the model name is set to your preferred GPT model (e.g., gpt-4).
3. Customize the Code Node:
   • The "Code" node is responsible for creating the prompt for the AI agent. Review and adjust the JavaScript code within this node to tailor the prompt based on the specific data you're fetching and the type of analysis you want the AI to perform.
4. Execute the Workflow:
   • Click the "Execute Workflow" button on the "Manual Trigger" node to run the workflow.

The workflow will process your stock tickers, fetch data, generate AI signals, and output the combined results. You can then extend the workflow to write these results back to a Google Sheet, send notifications, or integrate with other systems.