pitch-follow-up-tracker
Track outreach pitches and draft contextual follow-up emails. Monitors a pitch tracker (Google Sheet or local markdown), checks Gmail for replies, flags stale pitches, and drafts tiered follow-ups (Day 3, Day 7, Day 14) that reference the original pitch content. Use when you need to check on pitch follow-ups, draft follow-up emails, review outreach status, find pitches without replies, or manage an outreach pipeline. Triggers on: 'check follow-ups,' 'who hasn't replied,' 'draft follow-ups,' 'outreach status,' 'pitch tracker,' 'stale pitches,' or any request to manage pitch/outreach follow-up.
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/alexa853/pitch-follow-up-trackerPitch Follow-Up Tracker
Monitor outreach pitches, detect non-replies, and draft contextual, tiered follow-up emails.
Prerequisites
- gog CLI (required) — for Gmail access
which gog - Google account configured with gog (
gog gmail --account <email>) - Pitch tracker — one of:
- Google Sheet with outreach data
- Local markdown file with pitch records
Workflow
1. Collect Configuration
Ask the user (or detect from context):
| Parameter | Required | Description |
|---|---|---|
gmail_account | yes | Email account to check (e.g., [email protected]) |
tracker_type | yes | "sheet" or "markdown" |
tracker_id | if sheet | Google Sheet ID |
tracker_path | if markdown | Path to local .md file |
sender_name | yes | Name to use in follow-ups |
sender_role | optional | Role/title for email signature context |
follow_up_style | optional | "warm" (default), "direct", or "casual" |
2. Load Pitch Data
From Google Sheet:
gog sheets get <SHEET_ID> "<TAB_NAME>!A1:Z500" --json --account <gmail_account>
Expected columns (flexible — adapt to whatever columns exist):
- Contact name / email
- Brand / company
- Date sent
- Subject or pitch summary
- Status (if tracked)
From Markdown file: Read the file. Expected format (flexible):
## [Brand Name]
- **Contact:** Name <email>
- **Sent:** YYYY-MM-DD
- **Subject:** [pitch subject]
- **Summary:** [what was pitched]
- **Status:** Sent / Replied / Closed
Adapt to whatever format the user actually uses. Extract: contact email, brand, date sent, pitch content/subject, current status.
3. Verify Reply Status (CRITICAL — Do Not Skip Steps)
Before flagging ANY pitch as "needs follow-up," you MUST complete ALL of these checks. Do not skim. Do not skip. A false positive wastes the user's time and erodes trust.
Check 1: Search for direct replies
gog gmail search "from:<contact_email>" --max 10 --account <gmail_account>
Look for any reply from the contact after the pitch send date, even in a different thread.
Check 2: Search by domain (catches new threads)
gog gmail search "from:@<contact_domain>" --max 10 --account <gmail_account>
Brands often respond from a different person at the same company. Check for ANY email from that domain since the pitch date.
Check 3: Search sent folder for user follow-ups
gog gmail search "to:<contact_email> OR to:@<contact_domain>" --max 10 --account <gmail_account>
Check if the user already sent a response, follow-up, or forwarded the thread.
Check 4: Search drafts for unsent responses
gog gmail search "in:drafts <contact_name> OR <brand_name>" --max 5 --account <gmail_account>
A draft response means the user is working on it. Do NOT flag as needing follow-up.
Metadata
Not sure this is the right skill?
Describe what you want to build — we'll match you to the best skill from 16,000+ options.
Find the right skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-alexa853-pitch-follow-up-tracker": {
"enabled": true,
"auto_update": true
}
}
}Related Skills
creator-casting-tool
Find the right creators for any brand campaign, activation, or ambassador program. Takes a campaign brief (brand, vibe, category, budget, audience), searches Instagram, TikTok, YouTube, and Substack, and returns a castable shortlist with stats, content examples, rate estimates, and brand conflict checks. Use when casting creators for campaigns, sourcing influencers for a brand, building ambassador shortlists, finding creators for events/activations, or matching talent to a brief. Triggers on: 'find creators for,' 'cast for this campaign,' 'who should we use for,' 'source influencers,' 'creator shortlist,' 'casting list,' 'find talent for [brand],' 'ambassador search,' or any request to match creators to a brand or campaign brief.
brand-prospect-researcher
Find brands actively spending on influencer and creator campaigns. Scans trade press, Instagram, job boards, and news for active-spender signals, then outputs a scored, prioritized prospect list with contacts. Use when you need to find brands to pitch, identify active advertisers, build a prospect list, research which brands are hiring influencer marketers, or find companies launching creator campaigns. Triggers on: 'find brands to pitch,' 'prospect list,' 'who's spending on influencers,' 'brand prospects,' 'active advertisers,' 'campaign activity,' or any request to identify brands actively investing in creator/influencer marketing.