Viral Hook Library
An agentic AI workflow that architects a self-building viral hook library in Airtable. It automatically searches, extracts, and organizes content daily, with zero manual input.
Claude AI Agent
Objective
To build an end-to-end AI agent that reads from a UGC viral content newsletter from Gmail, extracts hooks and stores them in a structured Airtable database that builds itself daily.
Pipeline at a Glance
How the Agent Works
- 1Connect to Gmail — Authenticates via OAuth2; headless after first run.
- 2Query only new emails — Reads last email received from a specific email newsletter.
- 3Deduplicate against Airtable — Gmail Message IDs prevent duplicate rows.
- 4Strip email noise — Removes footers, ad copy, unsubscribe links pre-AI from the email body.
- 5Extract hooks with Claude AI — Returns a clean list of hooks only.
- 6Save to Airtable — Logs title, date, hooks as multiselect tags + raw text.
- 7Update run history — Writes today's date on success; prevents silent skips.
- 8Repeat daily — Self-schedules every 24 hours, no manual input.
Rules Given to the Agent
- Extract only viral hooks. It doesn't extract opinions, email ad copy, or CTAs.
- Return row values on Airtable.
- If no hooks found, leave empty.
- Use Gmail Message IDs to avoid duplicates.
Tools & Stack
| Tool | Role |
|---|---|
| Gmail API (OAuth2) | Authenticate and fetch from target sender |
| Claude AI — Anthropic | Extract viral hooks from cleaned email bodies |
| Airtable | Store hook data, and deduplication layer |
| Python + schedule | Run pipeline daily self-contained |
Results
Airtable Field Agent
The Airtable hook library feeds a second AI layer. An Airtable Field Agent reads incoming hooks daily and rewrites them in the voice of Chess BFF, a beginner-friendly chess app built around fun, rivalry, and chaos.
Objective
To build infrastructure that continuously analyzes content inputs and turns them into brand-ready outputs. It does everything with the voice of Chess BFF in mind and with zero manual rewriting.
Pipeline at a Glance
How the Field Agent Works
- 1Reads viral hooks sourced daily by the pipeline agent.
- 2Rewrites each hook in Chess BFF's brand voice.
- 3Generates 10 brand-native hooks per session.
- 4Produces villain arc, couples, and best-friend rivalry variants.
- 5Optimizes all hooks for TikTok, Reels, and Shorts under 15 words.
- 6Outputs map directly into the social content calendar.
Results
A fully automated content intelligence stack. It goes from newsletter inbox to brand-ready TikTok hooks with zero manual steps in between. It sources, extracts, organizes, and rewrites to brand guidelines all on their own, on a daily basis.
Airtable Base Preview
