Skip to content

Instantly share code, notes, and snippets.

@powerwlsl
Created August 4, 2023 18:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save powerwlsl/14f1ec1712b1deeefea2fdf44a4cc371 to your computer and use it in GitHub Desktop.
Save powerwlsl/14f1ec1712b1deeefea2fdf44a4cc371 to your computer and use it in GitHub Desktop.
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';
var delayKey = 1000;
setTimeout(function(){
sendAjax(
'https://webhooks.integrately.com/a/webhooks/c15ea048f00b4235885c259a705f2763',
{
"listingAddress": listingAddress,
"listingLP": listingLP,
"listingOLP": listingOLP,
"listingDescription": listingDescription,
"listingOfficeName": listingOfficeName,
"listingOfficeNumber": listingOfficeNumber,
"listingOfficePhoneNumber": listingOfficePhoneNumber,
"listingOfficeAddress": listingOfficeAddress,
"listingAgentName": listingAgentName,
"listingAgentFirstName": listingAgentFirstName,
"listingAgentLastName": listingAgentLastName,
"listingAgentLicenseNumber": listingAgentLicenseNumber,
"listingAgentPhoneNumber": listingAgentPhoneNumber,
"listingAgentEmail": listingAgentEmail,
"listingAgentLACell": listingAgentLACell,
"listingAgentLACell2": listingAgentLACell2
},
'POST',
console.log("sent!"),
{});
},1*delayKey);
nextButton = document.querySelector('.pagingLinks a:nth-child(2)');
nextButton.click();
}, i * 3000);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment