What problem does it solve? Running marketing email campaigns at ATFX requires coordinating lead imports, Postgres state in Supabase, paced sending through Microsoft Graph, and a dispatcher on an Azure VPS. This Skill gives the AI the operational knowledge to perform those tasks correctly without re-discovering the architecture each time. ## Core Features & Use Cases - Lead Import: Import CSV lead lists into Supabase with dry-run validation, upsert idempotency, and automatic suppression of Do-Not-Email contacts. - Campaign Scheduling: Create campaigns with templates, schedule them in America/Mexico_City time, and let the VPS systemd dispatcher fire them automatically. - Unsubscribe & Status Management: Handle per-campaign unsubscribes via a Supabase Edge Function and query campaign status, recipients, and send logs. - Use Case: You receive a new CSV of 4,000 Salesforce leads and need a campaign sent next Tuesday at 1 PM CDMX. The Skill walks you through dry-run import, template creation with an unsubscribe footer, scheduling with explicit timezone offset, and verifying recipient counts. ## Quick Start Ask the assistant to import a leads CSV and schedule a new email campaign in CampaignSender, and it will consult Supabase and the playbooks to execute each step.
