
Security News
CISA Kills Off RSS Feeds for KEVs and Cyber Alerts
CISA is discontinuing official RSS support for KEV and cybersecurity alerts, shifting updates to email and social media, disrupting automation workflows.
node-red-contrib-google-sheets
Advanced tools
nodered node to get, update, append, and clear google sheets.
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 283 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 for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
CISA is discontinuing official RSS support for KEV and cybersecurity alerts, shifting updates to email and social media, disrupting automation workflows.
Security News
The MCP community is launching an official registry to standardize AI tool discovery and let agents dynamically find and install MCP servers.
Research
Security News
Socket uncovers an npm Trojan stealing crypto wallets and BullX credentials via obfuscated code and Telegram exfiltration.