Download Enterprise_Campaign_CRM_v4_Playbook.pdf

🚀 Enterprise Email Campaign CRM + Analytics Platform v4.0

Built entirely on Google Apps Script, this project turns your Google Sheet into a powerful email marketing CRM — complete with automation, analytics, and smart controls.

No paid tools. No dependencies. Just pure automation.

💡 Key Highlights

• 📧 Smart Campaign Engine: Automatically sends personalized emails with dynamic placeholders like {{FirstName}}.
• 🧠 AI-Smart Retry Logic: Detects failed or bounced emails and re-queues them automatically.
• 📊 Real-Time Analytics: Tracks delivery success, failure, and pending counts with daily charts.
• 🔄 Auto-Run Triggers: Schedule campaigns every 5 minutes, hourly, or daily — completely hands-free.
• 💾 Data-Driven CRM: Every campaign action is logged in Sheets for transparency and control.
• ⚙️ Self-Contained System: No external libraries or API keys required.
• 💬 Visual Dashboard: Manage, monitor, and control campaigns via an elegant HTML interface powered by Chart.js.

🧱 What’s Included

✅ Code.gs — Full backend engine for campaign management

✅ index.html — Interactive dashboard UI with analytics

✅ Step-by-Step Playbook — Installation, setup, and troubleshooting guide

✅ Pre-built Google Sheet sample template

✅ Trigger automation, retry module, and daily summary email

⚙️ Core Features

CategoryDescription💌 Email AutomationBulk send personalized HTML emails directly via Gmail📊 AnalyticsView performance charts and 7-day trends in-app🔁 Retry EngineAutomatically retries failed messages⏰ TriggersAuto-schedule campaigns (5min / 15min / daily)📋 Sheet IntegrationSyncs live data with Google Sheets📤 CSV ExportExport full lead list anytime🧩 Unsubscribe SheetAuto-detects opt-outs to stay compliant

🧭 Setup Summary

1. Copy the code into Google Apps Script
2. Link it with a Google Sheet named “Sheet1”
3. Deploy as a Web App
4. Open the dashboard URL → Configure → Run → Analyze

You’ll have a fully functioning CRM dashboard + automation suite in under 10 minutes.

🔐 Security & Compliance

• 100% hosted inside your Google Workspace
• No external servers or third-party data storage
• You control your own leads, campaigns, and analytics

🧠 Ideal For

• Recruiters automating outreach
• Founders sending pitch or newsletter campaigns
• Freelancers managing clients in Gmail
• Internal marketing or HR communication teams

✨ Author

Saurabh Srivastava

Talent Research & Automation Expert

Version 4.0 | 2025 Edition