I'd be really curious to know if anyone has been able to use Node-RED to insert items into a Sharepoint Online list. Would you be willing to share some information on how you did it? I see there is a user contributed node for Sharepoint but I can't seem to get it working.
I'm very new to Node-RED and by no means a JS developer.
That is going to be rather a disadvantage I'm afraid. Microsoft maintain a repo of JavaScript code for working with SP. But before you get to that, you need to work out how to use OAuth to connect to SP Online.