📊 PROOF OF CONCEPT
Google Sheets Auto-Sync Test Lab
Test sending leads directly into Google Sheets in 0.2 seconds.
Step 1: Copy This 5-Line Google Apps Script
Open any Google Sheet → click Extensions → Apps Script → replace everything with this code:
function doPost(e) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
// Auto-create styled headers if sheet is empty
if (sheet.getLastRow() === 0) {
var headers = ['Timestamp', 'Lead Name', 'Email Address', 'Phone Number', 'Lead Source', 'Message / Inquiry', 'Lead Status', 'Notes'];
sheet.appendRow(headers);
var range = sheet.getRange(1, 1, 1, headers.length);
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);
}
📍 Click Deploy → New Deployment → Select type Web App → Execute as: Me → Who has access: Anyone → Click Deploy & copy the Web App URL!