node-red-contrib-google-sheets 0.0.3

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

npm install 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 [email protected]

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 follwing 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

Node Info

Version: 0.0.3
Updated 5 months, 2 weeks ago
License: MIT
Rating: 5.0 1

Downloads

4 in the last day
80 in the last week
280 in the last month

Nodes

  • GSheet
  • gauth

Keywords

  • node-red
  • gsuite
  • google sheets
  • gsheet

Maintainers