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/api/docs/guides/authentication Then add the credentials in NodeRED, and use Redirect url: http://localhost:1/ Scopes: https://www.googleapis.com/auth/spreadsheets 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/spreadsheets/${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/spreadsheets/${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/
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/api/docs/guides/authentication Then add the credentials in NodeRED, and use Redirect url: http://localhost:1/ Scopes: https://www.googleapis.com/auth/spreadsheets 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/spreadsheets/${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/spreadsheets/${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/