Send weekly Taiwan foreign flow reports to Telegram using TWSE T86
Ready for 3.0What this workflow does
This workflow has 7 nodes and runs on a schedule (cron 0 0 8 * * 1). Along the way it connects Telegram. It also calls twse.com.tw over HTTP.
How it runs
Trigger: On a schedule (cron 0 0 8 * * 1).
- Set Report Config Parameters (Edit Fields (Set)): sets 4 fields: telegramChatId, topN, consecutiveThreshold…
- Calculate Trading Days (Code): runs custom JavaScript code
- Fetch TWSE Daily Data (HTTP Request): calls twse.com.tw (GET)
- Aggregate Weekly Foreign Net (Code): runs custom JavaScript code
- Format Telegram Message (Code): runs custom JavaScript code
- Send Report to Telegram (Telegram): send message
Services it uses
HTTP calls to: twse.com.tw
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Telegram
n8n-nodes-base.telegram
From the author
Quick overview This workflow runs every Monday morning and pulls last week’s TWSE T86 institutional trading data, aggregates foreign investor net flows into weekly leaders and streaks, and sends a plain-text report to a Telegram chat. How it works 1. Runs…