node-red-contrib-google-sheets
Advanced tools
Weekly downloads
Readme
A basic node for reading and writing from/to google sheets.
To setup auth this node uses a google service account:
Create a new service account from This Page
Download a JSON credentials object for the service account.
Give that account access to the sheets API.
Share your sheet with the email address of the service account eg nodered@nodered-12345.iam.gserviceaccount.com
The sheet ID can be found in the URL of your google sheet, for example in
https://docs.google.com/spreadsheets/d/1UuVIH2O38XK0TfPMGHk0HG_ixGLtLk6WoBKh4YSrDm4/edit#gid=0
The ID would be 1UuVIH2O38XK0TfPMGHk0HG_ixGLtLk6WoBKh4YSrDm4
Google sheets uses the following syntax to reference a tab and cells of the worksheet
The format is Sheet1!A1:C3
Where Sheet1
is the Sheet name followed by a !
then the grid of the first cell eg A1
then a :
and finally the grid of the last cell eg C3
A range of cells can be a Row at A1:A5
, a Column A1:E1
or even a block such as A1:C3
FAQs
nodered node to get, update, append, and clear google sheets.
The npm package node-red-contrib-google-sheets receives a total of 802 weekly downloads. As such, node-red-contrib-google-sheets popularity was classified as not popular.
We found that node-red-contrib-google-sheets demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket installs a Github app to automatically flag issues on every pull request and report the health of your dependencies. Find out what is inside your node modules and prevent malicious activity before you update the dependencies.