{
  "name": "Create a daily market brief from Google Sheets, Alpha Vantage, Reddit, OpenAI, and Slack",
  "nodes": [
    {
      "id": "44e7b5b2-e04d-4af4-ba3e-310598a246dd",
      "name": "Stock Price (Alpha Vantage)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        0,
        0
      ]
    },
    {
      "id": "e7681549-a80c-40e7-8849-6d03c111d814",
      "name": "Normalize Stock Data",
      "type": "n8n-nodes-base.code",
      "position": [
        208,
        0
      ]
    },
    {
      "id": "bda89b6c-889d-4c6d-a9ce-cf25e35f7029",
      "name": "RSS Read",
      "type": "n8n-nodes-base.rssFeedRead",
      "position": [
        416,
        0
      ]
    },
    {
      "id": "703783ba-833e-44bd-a6cd-2c6304e7940a",
      "name": "Normalize Market News",
      "type": "n8n-nodes-base.code",
      "position": [
        624,
        0
      ]
    },
    {
      "id": "5a4bcbe4-3fd6-4ec1-9911-58294a01cd4c",
      "name": "Reddit Sentiment – RSS",
      "type": "n8n-nodes-base.rssFeedRead",
      "position": [
        864,
        0
      ]
    },
    {
      "id": "50f03297-9a7c-416b-a98d-7275d0ef54c6",
      "name": "Parse AI Market Output",
      "type": "n8n-nodes-base.code",
      "position": [
        1920,
        0
      ]
    },
    {
      "id": "ab75c719-1342-44ab-a5de-22ecd67d97e9",
      "name": "Normalize Reddit News",
      "type": "n8n-nodes-base.code",
      "position": [
        1072,
        0
      ]
    },
    {
      "id": "ad386d29-12b0-444b-accd-2aa2b81bcfb7",
      "name": "Prepare AI Context",
      "type": "n8n-nodes-base.code",
      "position": [
        1312,
        0
      ]
    },
    {
      "id": "1ac46a65-85f7-45a2-bc08-9cb8a600807d",
      "name": "Read portfolio holdings",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -512,
        -16
      ]
    },
    {
      "id": "5483adea-b7d3-4f30-bf08-55cb6dacffa4",
      "name": "Process each stock",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -272,
        -16
      ]
    },
    {
      "id": "9005dc2a-8ef5-4a91-b1e6-07ca096993eb",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1456,
        -1008
      ],
      "parameters": {
        "width": 368,
        "height": 848,
        "content": "## Workflow overview\n\nThis workflow creates a daily market intelligence summary that helps you understand what is happening in the market without reading multiple sources. It automatically combines st"
      }
    },
    {
      "id": "a15bd978-e3b0-4c81-a242-ed336e60464b",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -768,
        -208
      ],
      "parameters": {
        "width": 656,
        "height": 384,
        "content": "### Data Collection \n\nThis is the starting point of the workflow. It reads the stock list from a spreadsheet and controls how each stock is processed, ensuring the workflow runs smoothly for multiple "
      }
    },
    {
      "id": "cd55269a-1e3f-42c8-9a86-1adccc70a833",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -64,
        -208
      ],
      "parameters": {
        "width": 1296,
        "height": 384,
        "content": "### Market data collection\n\nThis section collects all external market information. It gathers daily stock prices, recent market news, and investor sentiment from public feeds, ensuring the workflow ha"
      }
    },
    {
      "id": "a6d76f81-12e9-4503-ad25-01758fe6d5b5",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1264,
        -208
      ],
      "parameters": {
        "width": 576,
        "height": 384,
        "content": "### Data preparation and analysis\n\nThis section cleans and combines all collected data before sending it to AI. The AI analyses the information, removes noise, identifies market-moving signals, and ge"
      }
    },
    {
      "id": "8edf013c-a0ea-4615-b328-22c5221e65ff",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1856,
        -208
      ],
      "parameters": {
        "width": 480,
        "height": 384,
        "content": "### Output structuring and delivery \n\nThis section organises the AI response into clear sections and delivers the final market brief. The output is structured, readable, and shared as a single daily m"
      }
    },
    {
      "id": "c98460e3-70a5-470d-9592-514ea57bd8f5",
      "name": "Daily Market Brief Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -720,
        -16
      ]
    },
    {
      "id": "dc7c0550-90a3-4983-a8a0-245e2799056e",
      "name": "Ai Analysis",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1536,
        0
      ]
    },
    {
      "id": "1b61c149-dede-4ded-97b3-6b594a309481",
      "name": "Send actionable daily brief message",
      "type": "n8n-nodes-base.slack",
      "position": [
        2144,
        0
      ]
    }
  ],
  "connections": {
    "RSS Read": {
      "main": [
        [
          {
            "node": "Normalize Market News",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Ai Analysis": {
      "main": [
        [
          {
            "node": "Parse AI Market Output",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare AI Context": {
      "main": [
        [
          {
            "node": "Ai Analysis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process each stock": {
      "main": [
        [],
        [
          {
            "node": "Stock Price (Alpha Vantage)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Stock Data": {
      "main": [
        [
          {
            "node": "RSS Read",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Market News": {
      "main": [
        [
          {
            "node": "Reddit Sentiment – RSS",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Reddit News": {
      "main": [
        [
          {
            "node": "Prepare AI Context",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse AI Market Output": {
      "main": [
        [
          {
            "node": "Send actionable daily brief message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read portfolio holdings": {
      "main": [
        [
          {
            "node": "Process each stock",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Reddit Sentiment – RSS": {
      "main": [
        [
          {
            "node": "Normalize Reddit News",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Market Brief Trigger": {
      "main": [
        [
          {
            "node": "Read portfolio holdings",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Stock Price (Alpha Vantage)": {
      "main": [
        [
          {
            "node": "Normalize Stock Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}