Automate Singapore COE price analysis & purchase timing with GLM-4.5 AI predictions
Research & reporting workflow for n8n with 15 active steps. Starts with Schedule Trigger. Uses OpenRouter. Integrations include Google Sheets, SMTP email, Telegram, OpenRouter.
What it does
15 active nodes · Starts with Schedule Trigger.
Steps in the template include:
- Schedule Trigger - Bi-Weekly COE Scraping (Schedule Trigger)
- Scrape COE Data from OneMotoring (HTTP Request)
- Extract COE Price Data (Code)
- Store in Google Sheets (Google Sheets) — append
Nodes and integrations
- Schedule Trigger
- HTTP Request
- Code ×4
- Google Sheets ×2
- Edit Fields (Set) ×2
- AI Agent
- Send Email
- If
- Telegram
- OpenRouter Chat Model
See the author’s step names
- Schedule Trigger - Bi-Weekly COE Scraping (Schedule Trigger)
- Scrape COE Data from OneMotoring (HTTP Request)
- Extract COE Price Data (Code)
- Store in Google Sheets (Google Sheets) — append
- Retrieve Historical COE Data (Google Sheets)
- Calculate Technical Indicators (Code)
- Prepare AI Prediction Prompt (Edit Fields (Set))
- AI Agent - COE Analysis (AI Agent)
- Generate Buy Recommendations (Code)
- Format HTML Report (Code)
- Send Email Report (Send Email)
- Check for Buy Opportunities (If)
- Send Telegram Alert (Telegram)
- Generate Dashboard Summary (Edit Fields (Set))
- OpenRouter Chat Model (OpenRouter Chat Model)
Accounts and credentials
- Google Sheets
- SMTP email
- Telegram
- OpenRouter access
Credential types in the graph: googleSheetsOAuth2Api, openRouterApi
Check the HTTP request steps for any additional service accounts or API keys.
AI models and swaps
OpenRouter · Chat
z-ai/glm-4.5 in OpenRouter Chat Model. Potentially swappable with a compatible n8n chat model node. Test the replacement with the next step.
Resource information
- Credit basis
- Author listed by n8n
- Pricing
- Template access shown on n8n
- License
- Not specified
- Last record update
- Nov 5, 2026