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");
  }
}

I have run into a problem. I added 20 ZPIDs to @benito334 script. It runs successfully 70% when run from script editor. The error when failing is "Zestimate div not found on page." Curiously, when I setup a time trigger or When Open trigger it fails 100%. I even ran with just 1 ZPID. When triggered execution, its an instant failure.

@rbuentello - mine is failing sort of randomly it seems too. I've debugged it a bit and found that it has to do with Zillow's "Are you a robot" checks. Sometimes Zillow shows the captcha and sometimes it does not. Definitely a bummer!

Now it hasn't run 100% from editor or trigger in 5 days? Are you experiencing the same issue? Advice?

…

On Tue, Apr 13, 2021 at 1:06 PM Darin Alleman ***@***.***> wrote: ***@***.**** commented on this gist. ------------------------------ I have run into a problem. I added 20 ZPIDs to @benito334 <https://github.com/benito334> script. It runs successfully 70% when run from script editor. The error when failing is "Zestimate div not found on page." Curiously, when I setup a time trigger or When Open trigger it fails 100%. I even ran with just 1 ZPID. When triggered execution, its an instant failure. @rbuentello <https://github.com/rbuentello> - mine is failing sort of randomly it seems too. I've debugged it a bit and found that it has to do with Zillow's "Are you a robot" checks. Sometimes Zillow shows the captcha and sometimes it does not. Definitely a bummer! — You are receiving this because you commented. Reply to this email directly, view it on GitHub <https://gist.github.com/b4cc60bed013cbd7a46b286640ea1c94#gistcomment-3704802>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ATVFYBGOWPK3UFPU36YTX6DTISB25ANCNFSM4VIHG3GQ> .

-- Richard

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.

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.