لاستقبال بيانات العملاء المحتملين تلقائياً في Google Sheet:
function doPost(e) {
var d = JSON.parse(e.postData.contents);
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sh = ss.getSheetByName("Leads") || ss.insertSheet("Leads");
if (sh.getLastRow() === 0) sh.appendRow(["Date","Name","Phone","Website","Market","Niche","Campaign","Spend","Results","CPM","CTR","Health"]);
sh.appendRow([new Date(),d.name,d.phone,d.website,d.market,d.niche,d.campaign,d.spend,d.results,d.cpm,d.ctr,d.health]);
return ContentService.createTextOutput("ok");
}