contact-extractor

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.