Big news!Introducing Socket AI - ChatGPT-Powered Threat Analysis. Learn more
Socket
Log inDemoInstall

node-red-contrib-google-sheets

Package Overview
Dependencies
1
Maintainers
1
Versions
7
Issues
File Explorer

Advanced tools

node-red-contrib-google-sheets

nodered node to get, update, append, and clear google sheets.

    1.1.2latest
    GitHub

Version published
Maintainers
1
Weekly downloads
817
increased by221.65%

Weekly downloads

Readme

Source

node-red-contrib-google-sheets

A basic node for reading and writing from/to google sheets.

Auth

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

Sheets

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

Cells

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

Keywords

FAQs

Last updated on 07 Jan 2022

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.

Install Socket
Socket
support@socket.devSocket SOC 2 Logo

Product

  • Package Issues
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc