Hi, I would like to use n8n to trigger a sequence whenever something occurs in my app / database.
For example, the most basic scenario is when a new users signs up for an account - this results in a new row inside the Users table.
What is the recommended way to store a variable, such as user ID somewhere in n8n?
I’m thinking this way I could:
- Get data from Mysql every X amount of time (trigger: interval + node: mysql)
- Then check which IDs are bigger than the one I have stored
- Do something with those IDs (let’s say send them an email)
- Update the state in the variable to remember for the next run, which IDs were processed.
The workflow would probably look something like the screenshot below, but I’m missing the piece that would allow me to know what IDs were processed already.
Thanks for any tips on the matter!
n8n version 0.188.0
running on Docker