NTREIS Matrix scraper

var destinationGoogleSheetURL = 'https://docs.google.com/spreadsheets/d/1Y2-9AhJZY2hgHIdRcxFajOR-KA-0nGzXeQKJMkXTfEk/edit#gid=0';

var pageLimit = document.querySelector('#m_lblPagingSummary > b:nth-child(3)').innerText;
pageLimit = parseInt(pageLimit);

for (var i = 1; i <= pageLimit; i++) {
  setTimeout(function () {
    var listingAddress = document.querySelectorAll("td.d128m16 .formula.field.d128m15")[0].innerText || 'unknown';
    var listingLP = document.querySelector('tr.d128m13 td.d128m11').innerText || 'unknown';
    var listingOLP = document.querySelectorAll('td.d128m11')[2].innerText || 'unknown';
    var listingDescription = document.querySelectorAll('tr.d139m6')[0].querySelector('td.d139m4').innerText || 'unknown';
    var listingAgentAddress = document.querySelectorAll('tr.d141m10')[0].querySelector('td.d141m4').innerText || 'unknown';

    var listingOfficeName = listingAgentAddress.split(/[\(\)]/)[0].trim() || 'unknown';
    var listingOfficeNumber = listingAgentAddress.split(/[\(\)]/)[1].trim() || 'unknown';
    var listingOfficePhoneNumber = listingAgentAddress.split(/[\(\)]/)[2].trim() || 'unknown';

    var listingOfficeAddress = document.querySelectorAll('tr.d141m10')[1].querySelector('td.d141m4').innerText || 'unknown';

    var listingAgentInfo = document.querySelectorAll('tr.d141m10')[2].querySelector('td.d141m4').innerText || 'unknown';
    var listingAgentName = listingAgentInfo.split(/[\(\)]/)[0].trim() || 'unknown';
    var listingAgentFirstName = listingAgentName.split(" ")[0] || 'unknown';
    var listingAgentLastName = listingAgentName.split(" ")[1] || 'unknown';
    var listingAgentLicenseNumber = listingAgentInfo.split(/[\(\)]/)[1].trim() || 'unknown';
    var listingAgentPhoneNumber = listingAgentInfo.split(/[\(\)]/)[2].trim() || 'unknown';
    var listingAgentEmail = document.querySelectorAll('tr.d141m10')[3].querySelector('td.d141m4').innerText || 'unknown';
    var listingAgentLACell = document.querySelectorAll('tr.d141m10 td.d141m6')[1].innerText || 'unknown';
    var listingAgentLACell2 = document.querySelectorAll('tr.d141m10 td.d141m6')[2].innerText || 'unknown';


    google_sheets_add_row(
      "1Y2-9AhJZY2hgHIdRcxFajOR-KA-0nGzXeQKJMkXTfEk",
            /*name*/'Sheet2',
      [
        listingAddress,
        listingLP,
        listingOLP,
        listingDescription,
        listingOfficeName,
        listingOfficeNumber,
        listingOfficePhoneNumber,
        listingOfficeAddress,
        listingAgentName,
        listingAgentFirstName,
        listingAgentLastName,
        listingAgentLicenseNumber,
        listingAgentPhoneNumber,
        listingAgentEmail,
        listingAgentLACell,
        listingAgentLACell2
      ]
    );

    var nextButton = document.querySelector('.pagingLinks a:nth-child(2)');
    nextButton.click();
  }, i * 3000);
}