Auto-Sync Leads to Google Sheets

Open any Google Sheet in your Google account → Click Extensions from the top menu bar → Select Apps Script.

Delete any default text in the Apps Script editor, paste the enriched script below, and click Save (floppy disk icon).
📍 Note: This script automatically formats your sheet headers (dark background, emerald text) and sets up a Lead Status column!

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  // Bulletproof header check: if row 1 is empty or missing headers, insert them
  if (sheet.getLastRow() === 0 || sheet.getRange(1, 1).getValue() !== 'Timestamp') {
    var headers = ['Timestamp', 'Lead Name', 'Email Address', 'Phone Number', 'Lead Source', 'Message / Inquiry', 'Lead Status', 'Notes'];
    sheet.insertRowBefore(1);
    var range = sheet.getRange(1, 1, 1, headers.length);
    range.setValues([headers]);
    range.setBackground('#07080a').setFontColor('#00f59b').setFontWeight('bold');
    sheet.setFrozenRows(1);
  }
  
  var data = JSON.parse(e.postData.contents);
  sheet.appendRow([
    new Date(),
    data.name || 'N/A',
    data.email || 'N/A',
    data.phone || 'N/A',
    data.source || 'LeadChirp Webhook',
    data.message || 'N/A',
    '🆕 New Lead',
    ''
  ]);
  
  return ContentService.createTextOutput(JSON.stringify({ result: 'success' }))
    .setMimeType(ContentService.MimeType.JSON);
}

1. Click Deploy (top right) → Select New Deployment.
2. Click gear icon ⚙️ next to Select type → Choose Web App.
3. Set Execute as: Me
4. Set Who has access: Anyone
5. Click Deploy → Authorize access → Copy your Web App URL (e.g. https://script.google.com/macros/s/.../exec).

Go to your LeadChirp Workspace Portal (/dashboard.html), paste your Web App URL into the Google Sheets Destination box, and click Save!