So I have a Webhook trigger, which then appends the values to an excel file.
However when the webhook is being trigger very fast, like 10x per second, the data is overwriting the same row. I can literally see the row value changing when I look at the file with the web version. So perhaps 30 results come in, but only end up with 3 additional rows in the end.
How can I queue it such that it gives it time (to maybe identify which was the last ID) so it creates a new row each time when its too fast.
I always use rabbitMQ to queue things. Especially with webhooks where you do not controll what is coming in it is smart to put everything in a queue before processing it.
I use rabbitMQ because it has nice native nodes with all the needed settings to get this done.
As @BramKn said, there is no built-in option to use queues. However, you can use files for that, e.g.:
your webhook saves what it needs in the file “webhook_[executionId].json”
a separate flow that is set to be triggered for every minute checks for any webhook_*json files in the directory and, if there are any, it will read them and delete them afterward.