Google Sheets → Multi-Platform Contact Sync Tool

Turn your Google Sheet into a one-click contact uploader for marketing platforms like Braze, CRMs, and analytics tools. No backend. No dashboard hopping. Just upload directly from Sheets.

---

What You Get

⚠️ WORK IN PROGRESS: This project is currently under active development. Platform integrations are being developed progressively. Features and documentation may change. Use at your own discretion.

Feature Benefit One-Click Uploads Sync contacts directly from Google Sheets custom menu Phone Normalization Automatic Indonesia phone number formatting (+62 E.164 format) Status Tracking Real-time upload status with timestamps Batch Processing Handle large datasets efficiently Connection Verification Pre-upload API connection testing Upload Statistics Visual progress bars and success/failure counts

---

Quick Start

Step 1: Set Up Google Sheets

1. Open your existing contact database
2. Ensure your sheet has the following columns:
   • Name or Full Name
   • Phone or Mobile
   • Email

Step 2: Add Apps Script

1. In your Google Sheet, go to Extensions → Apps Script
2. Copy the entire script code and paste it into the editor
3. Click Save (💾 icon)
4. Name your project (e.g., "Contact Sync Tool")

Step 3: Configure API Credentials

In the script editor, locate the configuration section and add your API keys:

// Example configuration
const CONFIG = {
  PLATFORM_API_KEY: 'your-platform-api-key',
  PLATFORM_ENDPOINT: 'your-platform-endpoint',
  // ... add other platform credentials
};

Step 4: Authorize the Script

1. Click Run → Select any function (e.g., onOpen)
2. Click Review Permissions
3. Choose your Google account
4. Click Advanced → Go to [Project Name] (unsafe)
5. Click Allow

Step 5: Reload Your Sheet

Close and reopen your Google Sheet. You should see a new menu item called "Contact Sync" or similar.

---

Next Steps

Want to dive deeper? Read TECHNICAL_README.md

---

License

Free to use for personal learning, testing, and demo purposes. Attribution appreciated. See LICENSE file for details.

---