Track investments using Baserow and n8n

This workflow uses a number of technologies to track the value of ETFs, stocks and other exchange-traded products:

- [Baserow](https://baserow.io/): To keep track of our investments - n8n’s Cron node: To trigger the workflow compiling our daily morning briefing - Webscraping: The HTTP Request & HTML Extract nodes to fetch up-to-date prices from the relevant stock exchange and structure this infromation - Javascript: We’ll use the Function node to build a custom HTML body with all the relevant information - [Sendgrid](https://sendgrid.com/): The Email Service Provider in this workflow to send out our email

Thanks to n8n, the steps in this workflow can easily be changed. Not a Sendgrid user? Simply remove the Sendgrid node and add a Gmail node instead. The stock exchange has a REST API? Just throw away the HTML Extract node.

Here’s how it works:

Data Source

In this scenario, our data source is Baserow. In our table, we’ll track all information needed to identify each investment product:


We have two text type columns (Name and ISIN) as well as two number type columns (Count and Purchase Price).