|Arghyadeep Kundu 9815729118||8 months ago|
|.github||8 months ago|
|.gitignore||2 years ago|
|LICENSE||2 years ago|
|README.md||8 months ago|
|index.js||2 years ago|
|package-lock.json||8 months ago|
|package.json||8 months ago|
|sonar-project.properties||8 months ago|
A simple Node.js module for logging in Google Sheets.
Install from command line:
npm install --save google-sheets-logger
Install via package.json:
Add the following to your package.json file under dependencies
Create a Google Sheets File and give access to the Service Account as described in the Authentcation secion.
Add the following headers (case-sensitive) to your sheet:
Import the module and use as shown below.
var GoogleSheetLogger = require("google-sheets-logger"); var creds = require("./google-generated-creds.json"); // Spreadsheet key is the long id in the sheets URL var Logger = new GoogleSheetLogger("<Spreadsheet Key>", creds); Logger.log("1", "Sample Log Message", "2019-10-08 12:49:44"); // When Timestamp is not passed, it adds the current time as the Timestamp of the Log Message by default. Logger.log("1", "Sample Log Message with no Timestamp"); // To add logs in sheets other than the first one of your workbook, pass the sheet index as the 4th argument. // Index starts at 1. Logger.log("1", "Sample Log Message", "2019-10-08 12:49:44", 3);
IMPORTANT: Google recently deprecated their ClientLogin (username+password) access, so things are slightly more complicated now. Older versions of this module supported it, so just be aware that things changed.
This is a 2-legged oauth method and designed to be "an account that belongs to your application instead of to an individual end user". Use this for an app that needs to access a set of documents that you have full access to. (read more)
Google Sheets Logger is published under the MIT license. For more information, see the accompanying LICENSE file.
If you find this package useful, please star the project on Github.
And, if you are willing to buy me a coffee, that would be awesome. :)