Email notification when data changed in backend

Hi there,

I am a beginner and building a portal (mvp mode), where users sign up and apply for financial projects (based on products they sell). My data base currently consists of two types: ‘User’ and ‘Product’ (both are linked with each other).

Where do I struggle:

I want the user to be notified by email once I change the Status of a certain product (e.g. from “in due diligence” to “approved”. I can neither figure out how to set up these workflows by myself nor do I find a blogpost which covers exactly this topic.

Looking forward to your replies. Most probably, my bubble beginner status keeps me from seeing the obvious…