Write2sheet NPM

write2sheet

Simple Node.js library to write to Google Sheets

Super simple library that writes data into a Google Sheet

Requirements

Node.js (v8 or up)
Get a OAuth2.0 authorization by following this guide (see Authorizing requests with OAuth 2.0)
- Write the client_secret.json to folder
Run it (the first time it runs it will ask for permissions)

Example

Simple example to write current date to a cell

const moment = require('moment');
const GoogleSheetWrite = require('.');

const sheet = new GoogleSheetWrite('<some spreadsheet id>');

// Update date
const mydate = moment().format('YYYY/MM/DD HH:mm:ss');
const range = 'Sheet!B4';

sheet.write([[mydate]], range);

Example to write current coin values to Range in sheet Currencies (using averissimo/crypto-market-scrapper)

const scrapper = require('crypto-market-scrapper');
const GoogleSheetWrite = require('.');

const sheet = new GoogleSheetWrite('<some spreadsheet id>');

const currencies = scrapper.getCurrencies([{
  "description": "Garlicoin",
  "code": "GRLC",
  "url": "https://coinmarketcap.com/currencies/garlicoin/"
}, {
  "description": "Bitcoin   ",
  "code": "BTC",
  "url": "https://coinmarketcap.com/currencies/bitcoin/"
}]);

currencies.then(response => {
	const values = response.sort((a, b) => {
		return a.code.localeCompare(b.code);
	}).map(el => {
		return [el.description, el.code, el.usd];
	});
	// Write to sheet
	sheet.write(values, 'Currencies!B9:D');
});