Track investments using Baserow and n8n
Needs changesWhat this workflow does
This workflow has 9 nodes and runs on a schedule (legacy Cron node) (plus 1 other trigger). Along the way it connects Baserow and SendGrid. It also calls tradegate.de over HTTP.
How it runs
Trigger: On a schedule (legacy Cron node) (plus 1 other trigger).
- Baserow: uses Baserow
- Fetch tradegate stock page (HTTP Request): calls tradegate.de
- Parse tradegate stock page (HTML Extract): uses HTML Extract
- Format result (Edit Fields (Set)): sets or maps fields
- Calculate change (Edit Fields (Set)): sets or maps fields
- Build HTML (Function): runs custom JavaScript (legacy Function node)
- SendGrid: work with mail
Services it uses
HTTP calls to: tradegate.de
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
Before you upgrade to n8n 3.0
3 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Cron: replace with Schedule Trigger.
- HTML Extract in Parse tradegate stock page: replace with HTML node, 'Extract HTML Content' operation.
- Function (legacy) in Build HTML: replace with Code node, mode 'Run Once for All Items'.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Cron | Schedule Trigger |
| HTML Extract Parse tradegate stock page | HTML node, 'Extract HTML Content' operation |
| Function (legacy) Build HTML | Code node, mode 'Run Once for All Items' |
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Cron
n8n-nodes-base.cron - Baserow
n8n-nodes-base.baserow - HTTP Request
n8n-nodes-base.httpRequest - HTML Extract
n8n-nodes-base.htmlExtract - Function
n8n-nodes-base.function - Edit Fields (Set)
n8n-nodes-base.set - SendGrid
n8n-nodes-base.sendGrid
From the author
This workflow uses a number of technologies to track the value of ETFs, stocks and other exchange-traded products: - Baserow: To keep track of our investments - n8n’s Cron node: To trigger the workflow compiling our daily morning briefing - Webscraping: The…