Personalized Cold Email at Scale — Batch Processing via Zapier and Google Sheets

Trigger: New row added to a Google Sheet with prospect fields: First Name, Last Name, Title, Company, Website, and Trigger event.

What this automates: Writing individual cold email sequences for every prospect on a list. Claude generates a 3-email sequence per prospect — Email 1 leads with the trigger event, Email 2 uses social proof, Email 3 asks a direct process question — all under 100 words each.

1. Rep adds prospect row to Google Sheet (only human step)
2. Zapier triggers on new row
3. Claude API generates 3-email sequence
4. Gmail draft emails created (3 drafts per prospect)
5. Google Sheet row updated to Drafted