In this post, I demonstrate how to call a Rest API using Google Apps Script and Displaying the data on a Google Sheet.
How to Video:
Video Notes:
- Legacy Apps Script Editor Used in Video
- Apps Script (Script Editor) is now located under tab ‘Extensions’ instead of ‘Tools’ on Google Sheets
Code in Video:
function myFunction() {
var ss= SpreadsheetApp.getActiveSpreadsheet();
var mainSheet = ss.getSheetByName("MAIN");
mainSheet.getRange('A1:A3').clear();
var URL_STRING = "https://api.jokes.one/jod";
var response = UrlFetchApp.fetch(URL_STRING);
var json = response.getContentText();
var data = JSON.parse(json);
var joke = data.contents.jokes[0].joke.text;
var copyright = data.contents.copyright;
mainSheet.getRange(1,1).setValue([joke]);
mainSheet.getRange(3,1).setValue([copyright]);
}
Related Posts



















