Working with Google Sheets from NodeRED

Demonstrating two ways to work with google sheets from within NodeRED.
For read only access you can use node-red-contrib-publicgooglesheets
But for more advanced stuff, you can use the Google node inside NodeRED.
Create the credentials as explained here https://developers.google.com/adwords...
Then add the credentials in NodeRED, and use
Redirect url: http://localhost:1/
Scopes: https://www.googleapis.com/auth/sprea...
And follow the steps explained in this video

In first function node i use the following code
var sheetid = "ID from url"
var range = "Sheet1!A1:D7"
msg.url = `https://sheets.googleapis.com/v4/spre...{sheetid}/values/${range}` +
'?majorDimension=ROWS'

return msg;

In the second function node I use
var sheetid = "ID from url"
var range = "Sheet1!A1:D7"
msg.url = `https://sheets.googleapis.com/v4/spre...{sheetid}/values/${range}?valueInputOption=USER_ENTERED`

msg.payload =
{
"range": range,
"majorDimension": "ROWS",
"values": [
]
}
return msg;



#openrpa #openflow #nodered #google #sheet
Get started today, by downloading it here https://github.com/open-rpa/openrpa
Want to run it entirely by yourself ? read how here https://openflow.openiap.io/
Please join our community forum at https://bb.openiap.io/
or chat with us at https://rocket.openiap.io/
For commercial support and training visit https://openiap.io/