HANDS-FREE Newsletter: Research, Design & Send on Autopilot
Hands-Free Newsletter: Research, Design & Send on Autopilot
Stop wasting Saturday mornings. Learn how to research, design, maintain your subscriber list, and send a branded weekly newsletter using Perplexity and Google Workspace—in under 60 minutes.
Overview
Most founders, consultants, and community creators know they need a recurring newsletter to stay top-of-mind.
The problem? Curation takes hours, designing responsive email templates is painful, and wrestling with CSV imports drains momentum.
In this practical, live build session, Coach BK Han breaks down how to move past basic chatbot conversations into agentic workflow orchestration. Using Perplexity connected to Google Workspace (Drive, Docs, Sheets, and Gmail), you will see how a single conversational session can build a self-sustaining media engine from scratch.
No code. No third-party automation software. Just pure agentic leverage.
What We Will Build Live in This Masterclass
Zero-Shot Live Research & HTML Design: Direct the AI to crawl the web for verified updates across your industry, filter signal from noise, and generate responsive, mobile-ready HTML straight to your inbox.
Programmatic Branding: Set up dynamic visual systems (like weekly rotating header palettes and pre-curated quotation archives) so your publication never feels stale.
The No-Code Workspace CRM: Link Google Drive and Google Sheets to pull past event attendee rosters, deduplicate records, clean contact statuses, and maintain a running subscriber list.
Human-in-the-Loop Safety Gates: Implement BCC distribution safeguards and review checkpoints so you always verify the recipient count and dispatch parameters before anything touches real people.
Unattended Scheduling: Hand off the completed pipeline to a persistent weekly automation (e.g., every Monday at 8:00 AM) that executes unattended while you sleep.
Who This Is For
Solo Founders & Creators: Build personal brand authority without hiring a copywriter or spending half a day writing.
Coaches & Community Leaders: Automatically convert event attendees into an engaged, recurring subscriber base.
Service Professionals & Consultants: Stay top-of-mind with clients and prospects through a consistent, high-value weekly touchpoint.
Practical AI Builders: Anyone looking to move beyond simple prompting into real, multi-tool agentic systems.
Prerequisites & Tech Stack
Tool Required: Perplexity Pro / Perplexity Computer tier (to access native connectors and tool orchestration).
Integrations Used: Google Workspace (Gmail, Google Drive, Google Sheets).
Skill Level: Zero coding required. Basic familiarity with Google Drive and Gmail is all you need.
AI Innovation Coach | Founder, AI Hustle Generation CommunityHost: Coach BK Han
Empowering professionals, entrepreneurs, and learners of all ages to move from AI curiosity to practical, revenue-generating automation.