Build Gmail contact database with GPT-5 Nano, Brave Search & Google Sheets
UnknownWhat this workflow does
This AI workflow has 25 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Gmail, Google Sheets, OpenAI Chat Model and Brave Search (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- LoadSentMessages (Gmail): uses Gmail
- SelectTo&CC (Edit Fields (Set)): sets or maps fields
- Remove Duplicates: removes duplicate items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- 3s (Wait): pauses before continuing
- GetInboxMessages (Gmail): uses Gmail
- InboxMessages? (If): checks a condition and branches into true / false
- SelectImportantFields (Edit Fields (Set)): sets or maps fields
- MailParser (Code): runs custom JavaScript code
- Information Extractor: extracts structured fields from text with AI, with model: OpenAI Chat Model
…plus 11 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @brave/n8n-nodes-brave-search is verified or supports 3.0 (used in SearchWebsite).
Nodes used (15)
- Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Remove Duplicates
n8n-nodes-base.removeDuplicates - No Operation, do nothing
n8n-nodes-base.noOp - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Brave Search
@brave/n8n-nodes-brave-search.braveSearch - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Aggregate
n8n-nodes-base.aggregate
From the author
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…