jalcantarab

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.

CodingDoug

Copying data from Firebase Realtime Database to a Google Sheet in real time via Cloud Functions

If you're trying to do this, you came to the right place!

Watch this code work in real time: https://twitter.com/CodingDoug/status/940022568089554944

See also this gist for copying in the other direction: https://gist.github.com/CodingDoug/44ad12f4836e79ca9fa11ba5af6955f7

Setup

amattu2

const PRINT_HEADER = "Generating export...";
const PRINT_OPTS = {
  'size': 0,
  'fzr': false,            
  'portrait': false,       
  'fitw': true,            
  'gridlines': false,      
  'printtitle': false,
  'sheetnames': false,
  'pagenum': 'CENTER',