colorado 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.querySelector(".d-mega.d-fontSize--larger.d-marginRight--20").innerText || 'unknown';
    var listingLP = document.querySelector('.d-mega.d-fontWeight--bold.d-fontSize--larger.d-marginLeft--20').innerText || 'unknown';
    var listingAgentName = document.querySelector('td.d94m49').innerText || 'unknown';
    var listingAgentFirstName = listingAgentName.split(' ')[0]
    var listingAgentLastName = listingAgentName.split(' ')[1]
    var listingAgentPhone = document.querySelectorAll('table.d94m50 td.d94m52')[0].innerText || 'unknown';
    var listingAgentMobile = document.querySelectorAll('table.d94m50 td.d94m52')[1] ? document.querySelectorAll('table.d94m50 td.d94m52')[1].innerText : '';
    var listingAgentOffice = document.querySelectorAll('table.d94m50 td.d94m52')[2] ? document.querySelectorAll('table.d94m50 td.d94m52')[2].innerText : '';
    var listingAgentEmail = document.querySelector('a[href^="mailto:"]').innerText || 'unknown';
    var listingOfficeName = document.querySelectorAll('.d94m46')[1].querySelector('.formula.wrapped-field').innerText || 'unknown';
    var listingDescriptionSection = Array.from(document.querySelectorAll('table.d57m2 .heading2.d57m24')).filter(header => header.innerText.includes("Public Remarks"))
    var listingDescription = '';
    if (listingDescriptionSection && listingDescriptionSection[0]) {
      listingDescription = listingDescriptionSection[0].closest('tr').nextElementSibling.nextElementSibling.innerText || 'unknown';
    }
    google_sheets_add_row(
      "1Y2-9AhJZY2hgHIdRcxFajOR-KA-0nGzXeQKJMkXTfEk",
            /*name*/'Sheet7',
      [
        listingAddress,
        listingLP,
        listingAgentName,
        listingAgentFirstName,
        listingAgentLastName,
        listingAgentPhone,
        listingAgentMobile,
        listingAgentOffice,
        listingAgentEmail,
        listingOfficeName,
        listingDescription
      ]
    );

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