Skip to content

Instantly share code, notes, and snippets.

@iamihgam
iamihgam / gist:bd9a87db7ef9f9c023a0f3099bb88ca7
Created May 18, 2018 13:50 — forked from daaain/gist:3932602
Google App Script - Spreadsheet JSON export
/**
* Adds a custom menu to the active spreadsheet, containing a single menu item
* for invoking the exportJSON() function specified above.
* The onOpen() function, when defined, is automatically invoked whenever the
* spreadsheet is opened.
* For more information on using the Spreadsheet API, see
* https://developers.google.com/apps-script/service_spreadsheet
*/
function onOpen() {
var sheet = SpreadsheetApp.getActiveSpreadsheet();