Append data to a Google Sheet.
Last updated 9 months ago by news-tools .
BSD-3-Clause · Original npm · Tarball · package.json
$ cnpm install googlesheetcomment 
SYNC missed versions from official npm registry.

Google Sheet Helper

Brought to you by The Times Tooling team  ????


A simple tool to append data to a Google Sheet. This tool also handles the authentication required to interact Google Sheets.


Before you can use the tool you will need to ensure that you have access to the following S3 bucket within The Times Dev account:



Generate a new access token

gsh refresh-token: This command will help you generate a new access token required to access the desired spreadsheet. Note the command must be run by someone with Read/Write access to the spreadsheet. This command should only be run by the Tools Team.

gsh set-sheet-location: This command will set the sheet location. The sheet will then be used by the 'update-sheet' command. This command should only be run by the Tools Team.

set-api-credentials: This command will set the Google API credentials required to use the spreadsheet API. This command should only be run by the Tools Team.

gsh update-sheet [options]: This command will update the sheet with the content provided in options. E.g. 'gsh update-sheet "this,is,a,test".

Exit Codes

Code 1: Unknown error occurred

Code 2: Invalid credentials

Code 3: Invalid request has been made. This could be the spreadsheet id, document id or content.

Code 4: Credentials stored on the bucket are not valid for this document. Share the document with the user account.

Code 5: Invalid user input provided.

Code 6: Failed to upload the sheet configuration.

Code 7: Failed to update the API credentials.


yarn to get the dependencies

yarn build to build the project (must be done when making changes)

npm link to create the symbolic link for running the binary from your terminal e.g. ohSheet -v


yarn test to run all tests

Current Tags

  • 1.7.1                                ...           latest (9 months ago)

17 Versions

  • 1.7.1                                ...           9 months ago
  • 1.7.0                                ...           a year ago
  • 1.6.0                                ...           a year ago
  • 1.5.5                                ...           a year ago
  • 1.5.4                                ...           a year ago
  • 1.5.3                                ...           a year ago
  • 1.5.2                                ...           a year ago
  • 1.5.1                                ...           a year ago
  • 1.5.0                                ...           a year ago
  • 1.4.4                                ...           a year ago
  • 1.4.3                                ...           a year ago
  • 1.4.2                                ...           a year ago
  • 1.4.1                                ...           a year ago
  • 1.4.0                                ...           a year ago
  • 1.3.0                                ...           a year ago
  • 1.2.0                                ...           a year ago
  • 1.1.0                                ...           a year ago
Maintainers (1)
Today 0
This Week 0
This Month 4
Last Day 0
Last Week 2
Last Month 39
Dependencies (4)
Dev Dependencies (14)
Dependents (1)

Copyright 2014 - 2016 © |