Skip to content

Instantly share code, notes, and snippets.

View edrdo's full-sized avatar

Eduardo R. B. Marques edrdo

View GitHub Profile
@edrdo
edrdo / _jsonPuller.md
Created September 17, 2022 09:06 — 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.