End-to-end B2B real estate lead enrichment & outreach with Apify, Relevance, OpenAI & Sheets
UnknownWhat this workflow does
This AI workflow has 58 nodes and runs on Fillout events (plus 2 other triggers). Along the way it connects OpenAI Chat Model, Pinecone Vector Store, Embeddings OpenAI and Google Sheets and 5 more.
How it runs
Trigger: On Fillout events (plus 2 other triggers).
- Map Fillout Submission Fields (Edit Fields (Set)): sets or maps fields
- Search PDFs in Google Drive Folder (Google Drive): uses Google Drive
- Action Field Switch (Switch): routes items into branches
- Append/Update Raw Leads Sheet (Google Sheets): uses Google Sheets
- Download Selected PDF for Processing (Google Drive): uses Google Drive
- Extract Icebreaker Text Fields (Edit Fields (Set)): sets or maps fields
- Verify Email with Apify (HTTP Request): calls an HTTP API
- Prepare Website Field (Edit Fields (Set)): sets or maps fields
- Prepare LinkedIn Profile URL (Edit Fields (Set)): sets or maps fields
- Extract PDF URL from Fillout (Edit Fields (Set)): sets or maps fields
…plus 39 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 n8n-nodes-fillout is verified or supports 3.0 (used in Fillout Trigger).
Nodes used (20)
- Fillout Trigger
n8n-nodes-fillout.filloutTrigger - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Pinecone Vector Store
@n8n/n8n-nodes-langchain.vectorStorePinecone - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Gmail
n8n-nodes-base.gmail - Manual Trigger
n8n-nodes-base.manualTrigger - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Switch
n8n-nodes-base.switch - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - AI Agent
@n8n/n8n-nodes-langchain.agent - Slack
n8n-nodes-base.slack
From the author
This advanced n8n workflow automates the full lead enrichment, qualification, and personalized outreach process tailored specifically for the B2B real estate sector. Integrating top platforms like Apify, Relevance, OpenAI, and Google Sheets, it empowers sales…