Google Sheets Zillow Import Script

Code.gs

function writeZestimateToSheet() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = spreadsheet.getSheets();
  var zillowSheet = sheets.find(sheet => sheet.getSheetName() == 'Zillow');
  if (zillowSheet) {
    var html = UrlFetchApp.fetch('https://www.zillow.com/homes/%%%%%%%%%_zpid/').getContentText();
    const divRegex = /(<div class="zestimate-value">)(\$)(\d{1,3})(,\d{3})*(<\/div>)/g;
    const moneyRegex = /(\$)(\d{1,3})(,\d{3})*/g;

    var div = html.match(divRegex);
    var zestimate;
    if (div && div[0]) {
      zestimate = div[0].match(moneyRegex)[0];
      if (zestimate) {
        var row = [];
        row[0] = zestimate;
        row[1] = new Date();
        zillowSheet.appendRow(row);
        MailApp.sendEmail('me@email.com', 'Zestimate Update', 'As of '.concat(row[1].toDateString().concat(' the Zestimate of your home was ').concat(row[0])));
      }
      else {
        throw new Error("Zestimate not found");
      }
    }
    else {
      throw new Error("Zestimate div not found on page");
    }
  }
  else {
    throw new Error("Could not find Zillow sheet");
  }
}

OK. Is there a way to initiate the script locally, which doesn't have the robot checks since I am on Zillow on a regular basis locally?

…

On Mon, Apr 26, 2021 at 11:11 AM Darin Alleman ***@***.***> wrote: ***@***.**** commented on this gist. ------------------------------ Yep. Experiencing the same issue. Unfortunately something I can't fix. Like I said in the comment above, the "Are you a robot" check will always fail because, well, this is a robot. Nothing I can do. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <https://gist.github.com/b4cc60bed013cbd7a46b286640ea1c94#gistcomment-3720420>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ATVFYBGPVWHSNAH6F6LZKYDTKWGCLANCNFSM4VIHG3GQ> .

-- Richard

Not that I'm aware of at this point.