Skip to content

Instantly share code, notes, and snippets.

View mbparvezme's full-sized avatar

M B Parvez (Ron) mbparvezme

View GitHub Profile
@mbparvezme
mbparvezme / _jsonPuller.md
Created April 9, 2022 08:05 — 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.