Google Sheets Sync

Auto-sync all contacts to a Google Sheet on every update

Apps Script Webhook URL

Paste your Google Apps Script deployment URL here

Step 1 — Create your Google Sheet

Open Google Sheets and create a new spreadsheet. Name it anything you like (e.g. "My Pipeline").

Step 2 — Open Apps Script

In your sheet, click Extensions → Apps Script. Delete any existing code in the editor.

Step 3 — Paste this script

function doPost(e) { try { var data = JSON.parse(e.postData.contents); var ss = SpreadsheetApp.getActiveSpreadsheet(); var stages = data.stages || []; var contacts = data.contacts || []; var headers = ["First Name","Last Name","Company","Email","Phone","Instagram","Website","Value","Tags","Notes","Created","Updated"]; // Track which sheet names we use this sync var usedSheets = []; // ── One sheet per stage ── stages.forEach(function(stage) { var sheetName = stage.name.substring(0, 100); // Sheet names max 100 chars var sheet = ss.getSheetByName(sheetName); if (!sheet) sheet = ss.insertSheet(sheetName); sheet.clearContents(); // Header row sheet.appendRow(headers); // Style header row var headerRange = sheet.getRange(1, 1, 1, headers.length); headerRange.setFontWeight("bold"); headerRange.setBackground("#f3f3f3"); // Contacts in this stage var stageContacts = contacts.filter(function(c) { return c.stage === stage.id; }); stageContacts.forEach(function(c) { sheet.appendRow([ c.firstName||"", c.lastName||"", c.company||"", c.email||"", c.phone||"", c.instagram||"", c.website||"", c.value||0, (c.tags||[]).join(", "), c.notes||"", c.createdAt ? new Date(c.createdAt).toLocaleDateString() : "", c.updatedAt ? new Date(c.updatedAt).toLocaleDateString() : "" ]); }); // Auto-resize columns sheet.autoResizeColumns(1, headers.length); usedSheets.push(sheetName); }); // ── Move stage sheets to the end, in pipeline order ── var allSheets = ss.getSheets(); var nonStageSheets = allSheets.filter(function(s) { return usedSheets.indexOf(s.getName()) === -1; }); // Keep non-stage sheets at front (index 0..n), then append stage sheets in order var insertPos = nonStageSheets.length; usedSheets.forEach(function(name, i) { var s = ss.getSheetByName(name); if (s) ss.moveActiveSheet && ss.setActiveSheet(s) && ss.moveActiveSheet(insertPos + i + 1); }); return ContentService.createTextOutput(JSON.stringify({ok:true})).setMimeType(ContentService.MimeType.JSON); } catch(err) { return ContentService.createTextOutput(JSON.stringify({ok:false,error:err.message})).setMimeType(ContentService.MimeType.JSON); } } function doGet(e) { return ContentService.createTextOutput(JSON.stringify({ok:true,status:"salesrep.space webhook active"})).setMimeType(ContentService.MimeType.JSON); }

Step 4 — Deploy as a Web App

Click Deploy → New deployment

• Type: Web app

• Execute as: Me

• Who has access: Anyone (no sign-in required)

Click Deploy, authorise when prompted, then copy the Web app URL.

Step 5 — Paste URL above & test

Paste the URL into the field above and click Save & Test. Your sheet will update automatically every time you add or edit a contact.