Skip to content

Instantly share code, notes, and snippets.

View nickburrows's full-sized avatar

NickBurrows nickburrows

View GitHub Profile
@nickburrows
nickburrows / _jsonPuller.md
Created September 18, 2021 01:25 — forked from jalcantarab/_jsonPuller.md
A Google apps script to pull json from a spreadsheet

JSON Puller - Google Apps Script

Transforms the data of a given Spreadsheet Sheet to JSON.

  • The frozen rows are taken as keys for the JSON.
  • The data taken for the values is only that after the frozen rows

Set up:

exportJSON(Spreadsheet) - transforms the data in the given sheet to JSON.