Don’t go into that rabbit hole called Node-Red. You will end up writing a lot of code, and node.js isn’t the best scripting language, and my suggestion is to just write a simple Python script.
Debugging is hell, version control is hell, it doesn’t have VSCode integration, plus sometimes it has some weird bugs, when you forget to clean up headers, etc. and it can truly make you crazy.
If you need something super simple and it has a good integration, you might consider it, but for anything more complex, stick to Python, or some other scripting language you are familiar with.