{
  "name": "Weekly stock/ETF analysis with Claude & Gmail — monthly index fund review",
  "nodes": [
    {
      "id": "0ef280c8-3c4e-4a33-9fb9-b9d205ab376b",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        704,
        -432
      ],
      "parameters": {
        "width": 192,
        "height": 1184,
        "content": "Add workbook ID to Sheet nodes\n\nIE docs.google.com/spreadsheets/d/xxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
      }
    },
    {
      "id": "f0ed66cd-08cf-430d-96f5-a1dda66d6579",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1760,
        -288
      ],
      "parameters": {
        "width": 224,
        "height": 224,
        "content": "Add Email\n"
      }
    },
    {
      "id": "ada18341-8267-4c8c-b357-14643ac9fcf6",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        288,
        48
      ],
      "parameters": {
        "width": 2672,
        "height": 384,
        "content": "Stock Analysis - Weekly Monday + Wednesday Follow-up"
      }
    },
    {
      "id": "44dad330-ad4a-49c4-8ded-65528d41c58e",
      "name": "Sticky Note13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1344,
        -336
      ],
      "parameters": {
        "width": null,
        "height": 1168,
        "content": "Add Claude Credentials"
      }
    },
    {
      "id": "d34fda79-648e-47fb-9e75-f91673bf1eef",
      "name": "Sticky Note16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -176,
        528
      ],
      "parameters": {
        "width": 3296,
        "height": 496,
        "content": "Mid-Week Follow-up - User Input Integration"
      }
    },
    {
      "id": "85677cc7-cd22-4458-a6c3-80931422e55e",
      "name": "Sticky Note 8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16,
        -464
      ],
      "parameters": {
        "width": 400,
        "height": 448,
        "content": "## How it works\nAutomated portfolio analysis with AI-powered recommendations:\n- Monday: Complete stock analysis (fundamental + technical + synthesis)\n- Wednesday: Follow-up analysis based on user inpu"
      }
    },
    {
      "id": "e039d5df-2681-4424-bafd-7aff8622c291",
      "name": "Sticky Note 9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16,
        32
      ],
      "parameters": {
        "width": 280,
        "height": 240,
        "content": "Google Sheets Setup\n\nCopy template:\ndocs.google.com/spreadsheets/d/1WHdSdkS0M67EVAcsDWb5WLzQqLVj0_8zvbYIx8vGA4w\n\nAdd your Sheet ID to all Read nodes\n\nDO not change layout or formatting without updatin"
      }
    },
    {
      "id": "d1223cd2-59c9-415d-b2c6-a9f860644cc9",
      "name": "Sticky Note 10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        416,
        -416
      ],
      "parameters": {
        "width": 1600,
        "height": 416,
        "content": "Index Fund Analysis - Monthly Review"
      }
    },
    {
      "id": "c52159d7-b6a9-4f4b-bd2e-9ee1af6baae2",
      "name": "Format Index Fund Email",
      "type": "n8n-nodes-base.code",
      "position": [
        1600,
        -256
      ]
    },
    {
      "id": "6fb014fb-60c2-4930-b77c-b0fceb5d1d8f",
      "name": "Send Index Fund Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1808,
        -256
      ]
    },
    {
      "id": "b4878a14-eaea-4379-bd6f-16309c54a6f2",
      "name": "Read Index Funds1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        768,
        -256
      ]
    },
    {
      "id": "54925db5-ecf7-48e2-bc35-def8c51fe2ee",
      "name": "First day of Month",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        544,
        -256
      ]
    },
    {
      "id": "7d968e0e-42b3-4447-8e63-491180e0a604",
      "name": "Every Monday 8AM2",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        576,
        160
      ]
    },
    {
      "id": "e31e0f01-25d0-4d81-91c5-e8d4b9a18146",
      "name": "Read Stocks2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        784,
        160
      ]
    },
    {
      "id": "4b1bb00e-349d-47af-90e0-0916956f887a",
      "name": "Prepare Stock Data1",
      "type": "n8n-nodes-base.code",
      "position": [
        992,
        160
      ]
    },
    {
      "id": "352c5068-35d5-492f-a304-568fdd4b91c6",
      "name": "Send Dual Analysis Email1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2640,
        0
      ]
    },
    {
      "id": "34e94a16-afb6-4334-973b-dae40bbd5648",
      "name": "Claude Stock Analysis - Fundemental",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1408,
        160
      ]
    },
    {
      "id": "133260c1-2dd9-467a-a4ad-54de2d144fdf",
      "name": "Prepare Claude Technical Prompt",
      "type": "n8n-nodes-base.code",
      "position": [
        1600,
        160
      ]
    },
    {
      "id": "1a62941b-8bda-4fa2-b751-e25b32186eb7",
      "name": "Prepare Claude Synthesis",
      "type": "n8n-nodes-base.code",
      "position": [
        1984,
        160
      ]
    },
    {
      "id": "eb47abda-02d3-4230-93be-af2f1b790caf",
      "name": "Claude Stock Analysis - Technical",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1808,
        160
      ]
    },
    {
      "id": "76df1c46-2156-4dda-b5ec-afd7679fce4e",
      "name": "Claude Synthesis Analysis",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2208,
        160
      ]
    },
    {
      "id": "3efad71e-5a45-4cc6-bd95-c5eea601d226",
      "name": "Format Synthesis Email",
      "type": "n8n-nodes-base.code",
      "position": [
        2448,
        160
      ]
    },
    {
      "id": "5b30f560-0db2-45f7-aabb-aa48946c7b32",
      "name": "Build Claude Prompt- Fundemental",
      "type": "n8n-nodes-base.code",
      "position": [
        1200,
        160
      ]
    },
    {
      "id": "6fe6df24-99ca-44ec-90c8-1610f5f12777",
      "name": "Prepare Index Fund Data1",
      "type": "n8n-nodes-base.code",
      "position": [
        976,
        -256
      ]
    },
    {
      "id": "6c8e5479-3c4e-4fa3-b1ab-d660840c7b3e",
      "name": "Build Index Fund Prompt1",
      "type": "n8n-nodes-base.code",
      "position": [
        1184,
        -256
      ]
    },
    {
      "id": "2fdeeb68-691d-4c54-b1f5-c8fc55ff67c4",
      "name": "Claude Index Fund Analysis1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1392,
        -256
      ]
    },
    {
      "id": "8c881bf2-33c9-4346-ae67-9aaab321846a",
      "name": "Wait 24hrs for Form Submission",
      "type": "n8n-nodes-base.wait",
      "position": [
        432,
        784
      ]
    },
    {
      "id": "234f5cd2-6a06-46e6-a2c5-e81065ed105c",
      "name": "Process Form Data",
      "type": "n8n-nodes-base.code",
      "position": [
        768,
        784
      ]
    },
    {
      "id": "a4e0edab-2cb6-41c6-8b98-f08ed7c50056",
      "name": "Portfolio Follow-up Form",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        560,
        912
      ]
    },
    {
      "id": "d1d76fb4-dee6-4b4f-b819-fb69cd9a2a4c",
      "name": "Send Follow-up Email Prompt1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        240,
        624
      ]
    },
    {
      "id": "408b8c45-9fbe-4241-b500-15b67940b6eb",
      "name": "Read Stocks - Follow-up1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        768,
        624
      ]
    },
    {
      "id": "94ce9612-38b1-4f8e-ae8f-f5c1d51adf8f",
      "name": "Prepare Stock Data - Follow-up1",
      "type": "n8n-nodes-base.code",
      "position": [
        976,
        624
      ]
    },
    {
      "id": "d889a34b-bbb0-4439-a0a6-25e7d54c5af6",
      "name": "Build Follow-up Fundamental Prompt1",
      "type": "n8n-nodes-base.code",
      "position": [
        1184,
        624
      ]
    },
    {
      "id": "07e6a00b-4c90-4eda-af09-a3b492a38670",
      "name": "Claude Follow-up Fundamental Analysis1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1392,
        624
      ]
    },
    {
      "id": "7dcf64fd-42a7-4c08-9bec-301d120b2ac4",
      "name": "Build Follow-up Technical Prompt1",
      "type": "n8n-nodes-base.code",
      "position": [
        1600,
        624
      ]
    },
    {
      "id": "d84be3a0-22d4-4b1a-b197-b5623cb7747d",
      "name": "Claude Follow-up Technical Analysis1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1808,
        624
      ]
    },
    {
      "id": "6a969a4a-33d3-45c5-b549-54bac70a5bb1",
      "name": "Build Follow-up Synthesis Prompt1",
      "type": "n8n-nodes-base.code",
      "position": [
        2016,
        624
      ]
    },
    {
      "id": "42bfb78c-e035-40e6-b45a-ba8eddaae1c6",
      "name": "Claude Follow-up Synthesis Analysis1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2224,
        624
      ]
    },
    {
      "id": "03d9a61f-4e43-44af-8e40-160e67130f5d",
      "name": "Format Follow-up Synthesis Email1",
      "type": "n8n-nodes-base.code",
      "position": [
        2432,
        624
      ]
    },
    {
      "id": "f3465082-ae45-4e83-af98-39a403c2f51b",
      "name": "Send Follow-up Analysis Email1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2640,
        624
      ]
    },
    {
      "id": "589fba61-00ee-4cc7-8eed-168f9580bda2",
      "name": "Wednesday 8AM EST Follow-up1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        32,
        624
      ]
    }
  ],
  "connections": {
    "Read Stocks2": {
      "main": [
        [
          {
            "node": "Prepare Stock Data1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Every Monday 8AM2": {
      "main": [
        [
          {
            "node": "Read Stocks2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Form Data": {
      "main": [
        [
          {
            "node": "Read Stocks - Follow-up1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Index Funds1": {
      "main": [
        [
          {
            "node": "Prepare Index Fund Data1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "First day of Month": {
      "main": [
        [
          {
            "node": "Read Index Funds1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Stock Data1": {
      "main": [
        [
          {
            "node": "Build Claude Prompt- Fundemental",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Synthesis Email": {
      "main": [
        [
          {
            "node": "Send Dual Analysis Email",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send Dual Analysis Email1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Index Fund Email": {
      "main": [
        [
          {
            "node": "Send Index Fund Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Index Fund Prompt1": {
      "main": [
        [
          {
            "node": "Claude Index Fund Analysis1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Portfolio Follow-up Form": {
      "main": [
        [
          {
            "node": "Read Stocks - Follow-up1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Claude Synthesis": {
      "main": [
        [
          {
            "node": "Claude Synthesis Analysis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Index Fund Data1": {
      "main": [
        [
          {
            "node": "Build Index Fund Prompt1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Stocks - Follow-up1": {
      "main": [
        [
          {
            "node": "Prepare Stock Data - Follow-up1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Claude Synthesis Analysis": {
      "main": [
        [
          {
            "node": "Format Synthesis Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Claude Index Fund Analysis": {
      "main": [
        [
          {
            "node": "Format Index Fund Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Claude Index Fund Analysis1": {
      "main": [
        [
          {
            "node": "Format Index Fund Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Follow-up Email Prompt1": {
      "main": [
        [
          {
            "node": "Wait 24hrs for Form Submission",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wednesday 8AM EST Follow-up1": {
      "main": [
        [
          {
            "node": "Send Follow-up Email Prompt1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 24hrs for Form Submission": {
      "main": [
        [
          {
            "node": "Process Form Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Claude Technical Prompt": {
      "main": [
        [
          {
            "node": "Claude Stock Analysis - Technical",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Stock Data - Follow-up1": {
      "main": [
        [
          {
            "node": "Build Follow-up Fundamental Prompt1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Claude Prompt- Fundemental": {
      "main": [
        [
          {
            "node": "Claude Stock Analysis - Fundemental",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Follow-up Synthesis Prompt1": {
      "main": [
        [
          {
            "node": "Claude Follow-up Synthesis Analysis1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Follow-up Technical Prompt1": {
      "main": [
        [
          {
            "node": "Claude Follow-up Technical Analysis1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Claude Stock Analysis - Technical": {
      "main": [
        [
          {
            "node": "Prepare Claude Synthesis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Follow-up Synthesis Email1": {
      "main": [
        [
          {
            "node": "Send Follow-up Analysis Email1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Follow-up Fundamental Prompt1": {
      "main": [
        [
          {
            "node": "Claude Follow-up Fundamental Analysis1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Claude Stock Analysis - Fundemental": {
      "main": [
        [
          {
            "node": "Prepare Claude Technical Prompt",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Claude Follow-up Synthesis Analysis1": {
      "main": [
        [
          {
            "node": "Format Follow-up Synthesis Email1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Claude Follow-up Technical Analysis1": {
      "main": [
        [
          {
            "node": "Build Follow-up Synthesis Prompt1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Claude Follow-up Fundamental Analysis1": {
      "main": [
        [
          {
            "node": "Build Follow-up Technical Prompt1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}