Master sheet

function doPost(e) {
try {
var data = JSON.parse(e.postData.contents);
var vendorLinks = data.vendorLinks || [];
var masterId = data.masterId;
if(!masterId) masterId = SpreadsheetApp.getActiveSpreadsheet().getId();

var masterSS = SpreadsheetApp.openById(masterId);
var masterSheet = masterSS.getSheets()[0];
if(masterSheet.getLastRow() == 0){
masterSheet.appendRow([“Website URL”,”DA”,”DR”,”Traffic”,”Dofollow”,”Price in PKR”,”Source”,”Date Added”]);
}

var existing = {};
var existingData = masterSheet.getDataRange().getValues();
for(var i=1;i-1 || j.indexOf(‘domain’)>-1){ headerIdx=h; break; } }
var header = rows[headerIdx].map(function(c){return c.toLowerCase()});
function find(keys,fb){ for(var k=0;k-1) return j; } } return fb; }
var cUrl=find([‘website’,’domain’,’url’],0), cDa=find([‘da’],2), cDr=find([‘dr’],3), cTr=find([‘traffic’],4), cPr=find([‘price’,’pkr’],5), cDf=find([‘dofollow’,’link’],6);

for(var i=headerIdx+1; i