Back to Principal Investigator at AI/Hub, Durham College
AI-Driven Email Automation System
Designed and implemented an AI-powered outreach workflow for a craft brewery to automate retailer targeting and personalized email drafting within Ontario’s distribution rules.
AIMarketing AutomationData CleanupWorkflow Orchestration
Project Details
Built an n8n-based pipeline integrating QuickBooks, Google Sheets, and Gmail to score and select stores, generate AI-assisted drafts with human review, and track campaigns. Standardized store records with geocoding and added tracking fields, delivered a phased implementation roadmap with safeguards (structured prompts, low-temperature settings, privacy), and validated a low-cost path to scale.
Key Achievements
- Documented, production-ready workflow and architecture with feasibility and scalability confirmed.
- Improved data quality and targeting via postal code cleanup, geocoding, and JavaScript scoring logic.
- Established responsible AI guardrails and a cost-efficient operating model for ongoing automation.