On Google Cloud Console, create a new agent. Add the "Google Sheets" API and create credentials (Service Account Key).
Install the Google Auth : npm install "node-red-contrib-viseo-google-authentication" ans restart Node-RED.
Add a 'Spreadsheet' node on your flow. Create a new configuration (Credentials) and select "copy/paste JSON file). Paste the content of the JSON key file and add the scope : "https://www.googleapis.com/auth/spreadsheets"
In Google Sheets, share you sheet with the mail address of your JSON key file.
Don't forget to delete the saved data (default: global._sheet) to update your Sheet data.
Found two typos in the -google-spreadsheet node. Also, can you please point me to some documentation on the 'credentials' setting?
root@ai:~/.node-red/node_modules/node-red-contrib-viseo-google-spreadsheet# diff google-spreadsheet.js* 15c15 < node.status({fill:"red", shape:"ring", text: 'Missing credential'});