Import CSV and isolate single data point

[Beno]

Hi, welcome to the forums!

Can you make the Excel file a Google Sheet?
If so, it can be easily automated like you want via Node-RED.

How to pull a Google Sheets document into Node-RED

Google Sheets files are a really common and useful way to store and organize data, but bringing that data into Node-RED requires some pretty specific steps, so I wrote this walkthrough to break it down so other users can make use of it. Note that if you are using CSV files instead you can easily just read that in with the core, preinstalled “file-in” node – and Excel documents can either be saved in CSV format, or imported into Sheets. This post just focuses on the steps required to use the GSh…