Build Gmail contact database with GPT-5 Nano, Brave Search & Google Sheets

Overview

Transform your Gmail sent folder into a comprehensive, enriched contact database automatically. This workflow processes hundreds or thousands of sent emails, extracting and enriching contact information using AI and web search – saving days of manual work.

What This Workflow Does

1. Loads sent Gmail messages and extracts basic contact information 2. Deduplicates contacts against your existing Google Sheets database 3. Searches for email conversation history with each contact 4. AI-powered extraction from email threads (phone, socials, websites) 5. Fallback web search via Brave API when no email history exists 6. Saves enriched data to Google Sheets with all discovered contact details

Perfect For

- Musicians & bands organizing booker/venue contacts - Freelancers & agencies building client databases - Sales teams enriching prospect lists from outbound campaigns - Consultants creating structured contact databases from years of emails

Key Features

Intelligent Two-Path Enrichment - Path A (Email History): Analyzes existing email threads to extract contact details from signatures and message content - Path B (Web Search): Falls back to Brave API search + HTML scraping when no email history exists