GAS spreadsheet to json

download.html

<style type="text/css">

#json {
  height: 320px;
  overflow: scroll;
  border:1px solid #ddd;
  padding:10px;
}

</style>

<pre align="left" id="json">
<?
output.append(body);
?>
</pre>

<div align="center">
<?
output.append("<a href='" +  url + "' target='_blank'>ダウンロード</a>");
?>
</div>

download_json.js

function fetchData(){
  var sheet = SpreadsheetApp.getActiveSheet();
    
  /*  sheetを元にデータを作成  */
  
  return data;
}


function renderToJson(data) {
  return JSON.stringify(data, null , 2);
}


function showDialogDowloadJson() {
  var contentType = "text/plain";
  var charSet = "UTF-8";
  var lineDelimiter = ",";
  var newLineChar = "\n";
  var fileName = 'hoge.json';
  var folderId = 'aaaaaaaaaaaaaaa'

  var data = fetchData();
  var folder = DriveApp.getFolderById(folderId);
  
  body = renderToJson(data);
  
  var blob = Utilities.newBlob("", contentType, fileName).setDataFromString(body, charSet);

  var fileId = DriveApp.getFolderById(folderId).createFile(blob).getId();
  
  url = "https://drive.google.com/uc?export=download&id=" + fileId;
  
  var output = HtmlService.createTemplateFromFile('download');
  var html = output.evaluate().setHeight(420).setWidth(600);
  var ui = SpreadsheetApp.getUi();

  ui.showModalDialog(html, fileName);
}


function onOpen() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var entries = [{
    name : "シートをJSONで出力",
    functionName : "showDialogDowloadJson"
  }];
  spreadsheet.addMenu("書き出し", entries);
};