function doPost(e) { try { var data = JSON.parse(e.postData.contents); var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName('Outreach Report'); if (!sheet) { sheet = ss.insertSheet('Outreach Report'); sheet.appendRow(['Date','Name','Company','Phone','Email','Industry', 'Location','WA Sent','Email Sent','Replied','Status','HubSpot Contact ID','HubSpot Deal ID']); sheet.getRange(1,1,1,13).setFontWeight('bold').setBackground('#1a1a2e').setFontColor('#ffffff'); } var today = new Date().toLocaleDateString('en-IN'); data.contacts.forEach(function(c) { sheet.appendRow([today, c.name, c.company, c.phone, c.email, c.industry, c.location, c.wa_sent||'', c.email_sent||'', c.replied||'', c.status, c.hs_contact_id||'', c.hs_deal_id||'']); }); return ContentService .createTextOutput(JSON.stringify({success:true, rows:data.contacts.length})) .setMimeType(ContentService.MimeType.JSON); } catch(err) { return ContentService .createTextOutput(JSON.stringify({success:false, error:err.toString()})) .setMimeType(ContentService.MimeType.JSON); } } function doGet(e) { return ContentService.createTextOutput(JSON.stringify({status:'NaviGo Sheets ready'})) .setMimeType(ContentService.MimeType.JSON); }