I like the route that you went. It gives me confidence to do a arduino and raspberry pi combination. I was a bit worried that I would have to try to learn to make a script but the NodeRed looks like a good route to go down.
That project is very similar to what I am try to achieve.