What problem does it solve?
Gmail is a rich source of contact information, but extracting and maintaining accurate, deduplicated contacts across campaigns is tedious and error-prone. This skill automates that workflow by scanning recent Gmail messages, extracting names, email addresses, phone numbers, organizations, and titles, and storing everything in a single, deduplicated spreadsheet.
Core Features & Use Cases
- Gmail scan & extraction: Parses headers, forwarded messages, and signatures to collect contact data (First Name, Last Name, Organization, Email, Cell Phone, Work Phone, Notes, Source, Date Entered).
- Deduplication & merging: Merges new data into existing rows and prevents duplicates across runs.
- Scheduled runs: Runs on a schedule (e.g., weekly) to keep the contact sheet fresh for campaigns, partnerships, and event follow-ups.
- Spreadsheet output: Produces a structured workbook with the required columns and data integrity safeguards.
Quick Start
Ask Claude to run the Contact Extractor on my Gmail to build and update the deduplicated contacts spreadsheet.