Casualize Names Workflow
Goal
Convert formal names (first names, company names, cities) to casual, friendly versions suitable for cold email copy.
Scripts
./scripts/casualize_batch.py - Main script (all 3 fields at once)
./scripts/casualize_company_names_batch.py - Company names only
./scripts/casualize_first_names_batch.py - First names only
./scripts/casualize_city_names_batch.py - City names only
Quick Start
# Process all three fields at once (recommended, 3x faster)
python3 -u ./scripts/casualize_batch.py "GOOGLE_SHEET_URL"
# Re-process existing (overwrite)
python3 -u ./scripts/casualize_batch.py "GOOGLE_SHEET_URL" --overwrite
How It Works
- Processes records in batches of 50
- Uses 5 parallel workers
- Claude converts all three fields in one API call
- Batch updates Google Sheet with results
- Only processes rows with emails
Performance: ~35 records/sec (3,000 records ≈ 90 seconds)
Casualization Rules
First Names
- Use common nicknames: "William" → "Will", "Jennifer" → "Jen"
- Keep original if no common nickname exists
- Keep it professional
Company Names
- Remove "The" at beginning
- Remove legal suffixes (LLC, Inc, Corp, Ltd)
- Remove generic words (Realty, Group, Solutions, Services)
- Keep core brand name
- Use "you guys" for overly generic names
Examples:
- "Keller Williams Realty Inc" → "Keller Williams"
- "The Teal Umbrella Family Dental Healthcare" → "Teal Umbrella"
City Names
- Use local nicknames: "San Francisco" → "SF", "Philadelphia" → "Philly"
- Keep original if no common nickname
Output
Creates three new columns:
casual_first_name
casual_company_name
casual_city_name
Environment
ANTHROPIC_API_KEY=your_key
Schema
Inputs
| Name |
Type |
Required |
Description |
sheet_url |
string |
Yes |
Google Sheet URL with lead data |
overwrite |
boolean |
No |
Re-process existing casualized names |
Outputs
| Name |
Type |
Description |
sheet_url |
string |
Same sheet with casual_first_name, casual_company_name, casual_city_name columns added |
Credentials
| Name |
Source |
ANTHROPIC_API_KEY |
.env |
Composable With
Skills that chain well with this one: scrape-leads, gmaps-leads, instantly-campaigns
Cost
~35 records/sec, minimal API cost
1---2name: casualize-names3description: Convert formal names to casual versions for cold email personalization - first names, company names, and city names. Use when user asks to casualize names, make names friendly, or prepare lead data for emails.4argument-hint: "[file-path]"5allowed-tools: Bash, Read, Write, Edit, Glob, Grep6metadata:7 source: https://skillmd.com/skills/aiagentwithdhruv/casualize-names8---910# Casualize Names Workflow1112## Goal13Convert formal names (first names, company names, cities) to casual, friendly versions suitable for cold email copy.1415## Scripts16- `./scripts/casualize_batch.py` - Main script (all 3 fields at once)17- `./scripts/casualize_company_names_batch.py` - Company names only18- `./scripts/casualize_first_names_batch.py` - First names only19- `./scripts/casualize_city_names_batch.py` - City names only2021## Quick Start2223```bash24# Process all three fields at once (recommended, 3x faster)25python3 -u ./scripts/casualize_batch.py "GOOGLE_SHEET_URL"2627# Re-process existing (overwrite)28python3 -u ./scripts/casualize_batch.py "GOOGLE_SHEET_URL" --overwrite29```3031## How It Works321. Processes records in batches of 50332. Uses 5 parallel workers343. Claude converts all three fields in one API call354. Batch updates Google Sheet with results365. Only processes rows with emails3738**Performance**: ~35 records/sec (3,000 records ≈ 90 seconds)3940## Casualization Rules4142### First Names43- Use common nicknames: "William" → "Will", "Jennifer" → "Jen"44- Keep original if no common nickname exists45- Keep it professional4647### Company Names48- Remove "The" at beginning49- Remove legal suffixes (LLC, Inc, Corp, Ltd)50- Remove generic words (Realty, Group, Solutions, Services)51- Keep core brand name52- Use "you guys" for overly generic names5354**Examples:**55- "Keller Williams Realty Inc" → "Keller Williams"56- "The Teal Umbrella Family Dental Healthcare" → "Teal Umbrella"5758### City Names59- Use local nicknames: "San Francisco" → "SF", "Philadelphia" → "Philly"60- Keep original if no common nickname6162## Output63Creates three new columns:64- `casual_first_name`65- `casual_company_name`66- `casual_city_name`6768## Environment69```70ANTHROPIC_API_KEY=your_key71```7273---7475## Schema7677### Inputs78| Name | Type | Required | Description |79|------|------|----------|-------------|80| `sheet_url` | string | Yes | Google Sheet URL with lead data |81| `overwrite` | boolean | No | Re-process existing casualized names |8283### Outputs84| Name | Type | Description |85|------|------|-------------|86| `sheet_url` | string | Same sheet with casual_first_name, casual_company_name, casual_city_name columns added |8788### Credentials89| Name | Source |90|------|--------|91| `ANTHROPIC_API_KEY` | .env |9293### Composable With94Skills that chain well with this one: `scrape-leads`, `gmaps-leads`, `instantly-campaigns`9596### Cost97~35 records/sec, minimal API cost