Exporting Google spreadsheet to JSON (or XML) format using Google Apps Script
<p>I'm trying to export google spreadsheet to JSON (or XML) using Google Apps script. Here is my google sheet:</p>

<p><a href="https://docs.google.com/spreadsheets/d/15fwOeR6Jo4UadzOTlryTucgI3ZFZ5IVM16GDSwA0XE0/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/15fwOeR6Jo4UadzOTlryTucgI3ZFZ5IVM16GDSwA0XE0/edit?usp=sharing</a></p>

<p>and here is my google apps script code:</p>

<pre><code>function doGet() {
 var ss = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/15fwOeR6Jo4UadzOTlryTucgI3ZFZ5IVM16GDSwA0XE0/edit#gid=0');
 SpreadsheetApp.setActiveSpreadsheet(ss);
 SpreadsheetApp.setActiveSheet(ss.getSheets()[0]);
 var title = ss.getSheets()[0].getRange("A1:A3").getValues();
 var link = ss.getSheets()[0].getRange("B1:B3").getValues();
 return ContentService.createTextOutput(title).setMimeType(ContentService.MimeType.XML);  
}
</code></pre>

<p>However, I'm not getting any JSON when I deploy it.</p>

<p>Thanks a lot,</p>