I have been working on a workflow to create an alert every time a discourse community user elapses 500 (and multiples of 500) Cheers Points, which is their gamification system.
Currently I have created a HTTP Request that pulls the data into n8n and have then added an IF node to reflect the point multiples but I have some worries.
Some users may go over 500 and it wont pick them up.
Duplicating alerts if a user is on say 500 for some time.
I currently have it scheduled for one day.
DO any of you experts (as I am new to the platform) have any advice on how to make this work better?
Hmm, here we will probably need to utilize some for of simple external DB to write the last known points per user. This can even be a Google Sheet if you are not working with huge numebr of users.
Every run should reference these and inly continue if they changed. Also a Code node will allow for some more sophisticated detection of the points increments, which will also be supplemented by our knowledge of the last known points for the user.
Alright, it will actually be a good exercise in building a slightly more complex flow too (using a DB). I generated a breakdown of the steps needed, which you can follow. Of course, let me know if you get stuck anywhere after building it and testing it out (can’t paste as the forum thinks I’m a bot lol)
