Google App Scripts | Sheets Tutorial | example.com

Code_example.js

/* 
Google App Scripts - Sheets Tutorial
Author: Mark Cameron
*/

function showMessageBox() {
    Browser.msgBox('You touched me!');
    getWebsite();
}

function getWebsite() {

    var attValue = '';

    // making a call to the target website
    var response = UrlFetchApp.fetch("https://example.com/");

    //logging response from target website - In Script Editor > View > Logs
    Logger.log(response.getContentText());

    //parsing the response data from website
    //https://developers.google.com/apps-script/reference/url-fetch/http-response
    var rawData = response.getContentText();

    //setting the spreadsheet and cell location to place the website data
    //make sure to open a new sheet 
    //Link: https://developers.google.com/apps-script/reference/spreadsheet/sheet#getrangerow-column
    var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = SpreadsheetApp.setActiveSheet(spreadsheet.getSheets()[1]);
    var cell = sheet.getRange(1, 1);
    cell.setValue(rawData);
}