I’m moving across from make/integromat to n8n. In make I was using a data store to store a user ID and unique link for each user. Depending on what data came in, if user 1 sent a request the data store would be checked and the link used later down the scenario.
You can use a tool like baserow or airtable to create a table to use.
There is no such thing in n8n available itself at this time. But most tools like this should have a node you can use, so it should be fairly straightforward to set it up.
One workaround would be using a Set-Node to store all the different users (could also be Baserow, Airtable, Google Sheets, … as @BramKn mentioned). And then have a separate workflow for each user. The DB (whatever you choose) would then save the information about which user links to which workflow.
Here an example workflow:
You can obviously also extend it by for example pretending an IF-Node that checks if there is an entry for a user and if not, do something totally else.
If you are able to install community nodes.
There are 2 I created that might be of help for you.
You still need an external tool to set the values if using a template or use the code node for example to set this template. But it might make life a bit easier for you, so wanted to mention it anyways.
Thanks @BramKn,
I do use for instance Google Spreadsheet to do it… but I sometimes tend to be rate limited as I have multiple tables. It’s doable but it’s quite overkill to use a Spreadsheet etc. just to do a lookup between (for instance) 10 values
if it is just 10 values you can easily put those in code nodes as well. Or Set node.
Just create an array of json objects with a from & to value, and then split that in a item lists node.
It’s what I did for a case with 6 values, I used a Set node, but in terms of UX and readability, if you compare the 2 solutions here, it’s quite obvious which is the easiest to use
On the one hand, I have 6 entries containing in total 12 ‘values’, in a table very easy to understand.
On the other hand, I have 12 pairs of entries containing in total 24 ‘values’, underneath one another which isn’t as easy to read.
And it’s 6 entries, of course I sometimes work with around 20 entries. Which doesn’t really make sense to use a database for, but isn’t small enough for this solution
All in all, I’m not saying what I want to achieve isn’t possible, it is, but I really believe there could be some nice UX improvement on it!
Yeah you are correct it would be a nice UX improvement.
But to be honest, I personally prefer having the tables outside of the tool that is doing the integrations. As it gives you more flexibility and also a way for less tech savvy people to maintain.
There should be an actual feature request for this, so you might want to vote on that.