The AI Email-to-CRM Pipeline: Gmail + Airtable + Notion
Lead emails in → structured Airtable record created → Notion brief drafted. Claude handles the whole intake flow across three services — here's the permission matrix that keeps it safe.
Every inbound lead email triggers the same process: read the email, create a CRM record, draft a context brief. It's repetitive, it's important, and it's exactly the kind of multi-step workflow AI handles well. The key is giving Claude access to three services without giving it more access than each pipeline step actually needs.
The Pipeline
Permission Matrix: What Each Service Actually Needs
Gmail
Airtable
Notion
The Prompt That Runs the Pipeline
"Read the most recent unread email from a new contact. If it looks like a sales inquiry: 1) Check Airtable to see if this contact already exists in the CRM. 2) If not, create a new lead record with their name, company, email, and a brief on what they're asking for. 3) Create a Notion page in the Leads database with background on their company and suggested talking points. 4) Draft a reply in Gmail. Present the draft and the Notion brief for my review before sending anything."
What Happens at Each Step
Gmail read
Executes immediately — read-only, no approval needed
Airtable record check
Executes immediately — read-only
Airtable create record
Executes immediately — additive, low risk
Notion page create
Executes immediately — additive, low risk
Gmail draft create
Executes immediately — draft only, not sent
You review draft + brief
Claude presents both for your review
Gmail send
Pauses for approval — you confirm before it reaches the prospect
Connecting the Services
- Gmail: Connect via OAuth in Stow Connected Services
- Airtable: Generate a Personal Access Token in Airtable settings, paste into Stow
- Notion: Generate an Integration Token in Notion settings, paste into Stow
- Claude Desktop: Add Stow as a connector using
https://mcp.stowprotect.com
What Gets Logged
Stow Security Team
April 19, 2026