Select a contact to view details
Read from Google Sheets (Import)
Your published CSV URL is pre-configured. Click Sync in the sidebar to pull the latest data from your sheet.
CSV URL configured
…/pub?output=csv
Write to Google Sheets (Two-Way Sync)
To push changes from the CRM back to your Google Sheet, you need to deploy a Google Apps Script web app from inside your sheet. This is a one-time 2-minute setup. Follow the steps below, then paste the URL here.
Step-by-step setup (one time only):
1. Open your Google Sheet → click Extensions → Apps Script
2. Delete any existing code and paste the entire Apps Script code (click the button below to copy it)
3. Click Save (floppy disk icon), then click Deploy → New deployment
4. Click the gear icon next to "Type" → choose Web app
5. Set Execute as: Me and Who has access: Anyone
6. Click Deploy → copy the Web app URL → paste it above
Note: You'll need to authorize the script to access your sheet when prompted. This is safe — it's your own script running on your own sheet.
1. Open your Google Sheet → click Extensions → Apps Script
2. Delete any existing code and paste the entire Apps Script code (click the button below to copy it)
3. Click Save (floppy disk icon), then click Deploy → New deployment
4. Click the gear icon next to "Type" → choose Web app
5. Set Execute as: Me and Who has access: Anyone
6. Click Deploy → copy the Web app URL → paste it above
Note: You'll need to authorize the script to access your sheet when prompted. This is safe — it's your own script running on your own sheet.
Column Mapping
Map each CRM field to a column number in your sheet (0 = column A, 1 = column B, etc.).
Data Management
Contact data and activity logs are stored in your browser's local storage and synced to Google Sheets when you save or sync.