google sheet to new line delimited json

gs_to_ndj.js

#based on https://github.com/jsoma/tabletop/blob/master/examples/nodejs/test.js

var Tabletop  = require('tabletop');
var jsonlines = require('jsonlines');
var stringifier = jsonlines.stringify();


var gs_url = 'https://docs.google.com/spreadsheets/d/1zkIeYUXJCLuUpJRYK-WvCVDxyYs9sAtqeR3p_EzjKxs/pubhtml?gid=164906169&single=true';

function onLoad(data, tabletop) {
  stringifier.pipe(process.stdout)
  data.forEach(set => stringifier.write(set));
};

var options = {
  key: gs_url,
  callback: onLoad,
  simpleSheet: true
};

Tabletop.init(options);