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

@benito334 I suppose it depends on the integration you're looking for. Using this script below, just put your zpid's in the zillowIds array and it'll add it in another column on the Zillow sheet.

function writeZestimateToSheet() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = spreadsheet.getSheets();
  var zillowSheet = sheets.find(sheet => sheet.getSheetName() == 'Zillow');
  var balanceHistory = sheets.find(sheet => sheet.getSheetName() == 'Balance History');
  if (zillowSheet && balanceHistory) {
    var zillowIds = ['51946308','51919001', '84074482'];
    var row = [];
    for (i = 0; i < zillowIds.length; i++) {
      if (zillowIds[i] != undefined){
        var html = UrlFetchApp.fetch('https://www.zillow.com/homes/' + zillowIds[i] + '_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) {
            try {
              var today = new Date();
              var lastSunday = new Date();
              lastSunday.setDate(today.getDate() - today.getDay());
              let rowIndex = (i * 2);
              row[rowIndex] = zestimate;
              row[rowIndex + 1] = today;
            } catch(error) {
              throw new Error('Setting values failed');
            }
          }
          else {
            throw new Error("Zestimate not found");
          }
        }
        else {
          throw new Error("Zestimate div not found on page");
        }
      }
      Utilities.sleep(10000);//wait 10 seconds before doing the next request, zillow doesn't like requests too fast
    }
    zillowSheet.appendRow(row);

  }
  else {
    throw new Error("Could not find Zillow sheet");
  }
}

@darinalleman That worked perfect. Thanks!

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.

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.