{
  "name": "Automate Singapore COE price analysis & purchase timing with GLM-4.5 AI predictions",
  "nodes": [
    {
      "id": "f0630256-92c3-4f3d-9bd6-4a93ced66909",
      "name": "Schedule Trigger - Bi-Weekly COE Scraping",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        64,
        384
      ]
    },
    {
      "id": "0e1e24c9-35cc-45f1-bc03-51bef5e4a48b",
      "name": "Scrape COE Data from OneMotoring",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        320,
        384
      ]
    },
    {
      "id": "75af2713-c37a-40b6-9eb8-a321d1e52a2a",
      "name": "Extract COE Price Data",
      "type": "n8n-nodes-base.code",
      "position": [
        512,
        384
      ]
    },
    {
      "id": "4c4d36f4-439a-402f-95c1-12450ab8e53a",
      "name": "Store in Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        704,
        384
      ]
    },
    {
      "id": "9e035479-59b9-48a9-951e-b9ced757a9c2",
      "name": "Retrieve Historical COE Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        896,
        384
      ]
    },
    {
      "id": "5437ef61-879f-4b99-9740-c2940af16055",
      "name": "Calculate Technical Indicators",
      "type": "n8n-nodes-base.code",
      "position": [
        1072,
        384
      ]
    },
    {
      "id": "a4ac811d-1308-4c49-bb12-353f82ce7a61",
      "name": "Prepare AI Prediction Prompt",
      "type": "n8n-nodes-base.set",
      "position": [
        1264,
        384
      ]
    },
    {
      "id": "5733ab85-b2bb-4d63-a207-3b8d5cc16c36",
      "name": "AI Agent - COE Analysis",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1424,
        384
      ]
    },
    {
      "id": "bd9f5443-2781-4f8b-9802-cdadf23f6e2c",
      "name": "Generate Buy Recommendations",
      "type": "n8n-nodes-base.code",
      "position": [
        1744,
        384
      ]
    },
    {
      "id": "3b384a83-df2f-4845-9017-ffcb2b377dc6",
      "name": "Format HTML Report",
      "type": "n8n-nodes-base.code",
      "position": [
        2000,
        192
      ]
    },
    {
      "id": "509457b5-5626-4869-9db2-da1eff8a0e20",
      "name": "Send Email Report",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        2224,
        192
      ]
    },
    {
      "id": "8f0f99a2-3cb3-4bfd-acda-179434d27b21",
      "name": "Check for Buy Opportunities",
      "type": "n8n-nodes-base.if",
      "position": [
        2000,
        384
      ]
    },
    {
      "id": "dd4f819f-2115-41bb-a472-6149662d2e20",
      "name": "Send Telegram Alert",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2224,
        368
      ]
    },
    {
      "id": "b08a514c-b77d-46d2-a928-70efd0ef643a",
      "name": "Generate Dashboard Summary",
      "type": "n8n-nodes-base.set",
      "position": [
        2000,
        576
      ]
    },
    {
      "id": "2ce78f73-1b51-43b9-94cf-e6b7ce7544df",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -64
      ],
      "parameters": {
        "width": 992,
        "height": 384,
        "content": "## Introduction\nAutomates Singapore COE price tracking, predicts trends using AI, and recommends optimal car purchase timing. Scrapes LTA data biweekly, analyzes historical trends, forecasts next 6 bi"
      }
    },
    {
      "id": "ec982981-33f8-4e23-97bc-8fddeb3db95a",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1056,
        -64
      ],
      "parameters": {
        "width": 512,
        "height": 224,
        "content": "## Prerequisites\nNVIDIA/OpenAI API key, Google account (Sheets), Gmail/Telegram for notifications, basic COE category knowledge\n\n## Use Cases\nFirst-time buyers monitoring price dips, fleet managers ti"
      }
    },
    {
      "id": "356985f8-b8b9-4166-9267-06607e03e479",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1632,
        -64
      ],
      "parameters": {
        "width": 544,
        "height": 224,
        "content": "## Customization\nAdd economic indicators, integrate car loan calculators, track parallel imported car prices\n\n## Benefits\nSaves hours of manual monitoring, captures 10–15% price dips, provides data-dr"
      }
    },
    {
      "id": "3ef5c1ec-d77f-450b-b446-ba0f20847718",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        560
      ],
      "parameters": {
        "width": 752,
        "height": 96,
        "content": "## Workflow\nSchedule Trigger → HTTP Request (Scrape LTA) → Data Processing → Google Sheets (Store) → AI Prediction → Analysis Engine → Conditional Logic → Gmail/Telegram Notification\n\n"
      }
    },
    {
      "id": "59139375-d79a-4bf8-a073-de197b6b5456",
      "name": "OpenRouter Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        1424,
        560
      ]
    },
    {
      "id": "d67e15bf-2829-4e99-adb3-43f841d34020",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        784,
        560
      ],
      "parameters": {
        "width": 576,
        "height": 192,
        "content": "## Workflow Steps\n1. Scraping: Extract COE prices from OneMotoring\n2. Processing: Calculate moving averages, volatility, seasonal trends\n3. Storage: Save to Google Sheets with timestamps\n4. Prediction"
      }
    }
  ],
  "connections": {
    "Format HTML Report": {
      "main": [
        [
          {
            "node": "Send Email Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenRouter Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent - COE Analysis",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Extract COE Price Data": {
      "main": [
        [
          {
            "node": "Store in Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store in Google Sheets": {
      "main": [
        [
          {
            "node": "Retrieve Historical COE Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent - COE Analysis": {
      "main": [
        [
          {
            "node": "Generate Buy Recommendations",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check for Buy Opportunities": {
      "main": [
        [
          {
            "node": "Send Telegram Alert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Buy Recommendations": {
      "main": [
        [
          {
            "node": "Format HTML Report",
            "type": "main",
            "index": 0
          },
          {
            "node": "Check for Buy Opportunities",
            "type": "main",
            "index": 0
          },
          {
            "node": "Generate Dashboard Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare AI Prediction Prompt": {
      "main": [
        [
          {
            "node": "AI Agent - COE Analysis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Retrieve Historical COE Data": {
      "main": [
        [
          {
            "node": "Calculate Technical Indicators",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Technical Indicators": {
      "main": [
        [
          {
            "node": "Prepare AI Prediction Prompt",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape COE Data from OneMotoring": {
      "main": [
        [
          {
            "node": "Extract COE Price Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger - Bi-Weekly COE Scraping": {
      "main": [
        [
          {
            "node": "Scrape COE Data from OneMotoring",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}