Monthly Sheet URLs
Configure your Google Sheet URL once per month — the dashboard uses it automatically
How it works: Add one row per month here. The dashboard will automatically sync from the stored URL when you select that month — no URL needed again. ✅
➕ Add / Update a Month
📋 Configured Months
Loading...
Territory Settings
Office location and radius for in/out territory classification
Changing these settings auto-recalculates territory for all existing leads instantly.
Google Sheets API
Service account (recommended) or API key for importing private sheets
🔑 Service Account Not configured
Recommended: Go to Google Cloud Console → Service Accounts → create or pick one → Keys → Add Key → JSON. Then paste the JSON below.
Share each Google Sheet with the service account email as Viewer.
Share each Google Sheet with the service account email as Viewer.
🗝 API Key (fallback, optional)
Without either: Sheet must be published as CSV (File → Share → Publish to web → CSV).
With API key: Sheet only needs "Anyone with link" access.
With API key: Sheet only needs "Anyone with link" access.
Email / SMTP Settings
Used to send daily reports by email
Report Recipients
Add/remove email and WhatsApp recipients anytime
No email recipients yet
These numbers are used as the to value for the Business Tools WhatsApp API. Digits only are sent; you can enter numbers with or without a +.
No WhatsApp numbers yet
Report Schedule
Daily automated report time (London timezone)
Setup cron job:
The cron checks the "Send Report At" time — runs every minute but only sends at the scheduled time.
Or to hardcode 8am:
* * * * * /usr/bin/php /app/cron/daily_report.php >> /var/log/s4g_report.log 2>&1The cron checks the "Send Report At" time — runs every minute but only sends at the scheduled time.
Or to hardcode 8am:
0 8 * * *
Loading...
WhatsApp API
Sends reports through the Business Tools endpoint
Request format: POST JSON to the endpoint with instance, to, and message. You can keep multiple configs here and the report sender will post to every saved config for each WhatsApp recipient.