Skip to main content

End-to-end B2B real estate lead enrichment & outreach with Apify, Relevance, OpenAI & Sheets

Workflow preview

Workflow preview
100%
End-to-end B2B real estate lead enrichment & outreach with Apify, Relevance, OpenAI & Sheets preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

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 ...

Best for

  • Lead Generation automation workflows
  • AI Summarization automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-fillout.fillouttrigger, @n8n/n8n-nodes-langchain.lmchatopenai, @n8n/n8n-nodes-langchain.vectorstorepinecone, @n8n/n8n-nodes-langchain.embeddingsopenai, @n8n/n8n-nodes-langchain.outputparserstructured, n8n-nodes-base.googlesheetstrigger, n8n-nodes-base.gmail, n8n-nodes-base.manualtrigger

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Mirza Ajmal.

Original n8n.io source

1.1 Workflow description

Title
End-to-end B2B real estate lead enrichment & outreach with Apify, Relevance, OpenAI & Sheets
Workflow name
End-to-end B2B real estate lead enrichment & outreach with Apify, Relevance, OpenAI & Sheets

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 and marketing teams to streamline prospect data enrichment, lead scoring, and engagement without manual data handling.

Features:

  • Form-Driven Lead Capture: Automated intake via Fillout form submissions capturing comprehensive lead and project details.

  • Email Verification:Ensures email validity with Apify, allowing outreach only to verified contacts.

  • Company & Profile Enrichment:Deep crawls of company websites paired with detailed LinkedIn profile scraping using Relevance.

  • Project Documentation Processing:Downloads and extracts text from submitted PDF project briefs or investor decks, enhancing semantic search capabilities.

  • Unified Lead Profiles: Merges all data sources—email validation, website content, LinkedIn insights, and project documents—to build enriched, actionable lead records.

  • AI-Driven Summaries & Scoring: Uses OpenAI to generate readable profile/company/project summaries and assigns lead quality scores to prioritize efforts.

  • Instant Hot Lead Alerts: Routes urgent prospects to Slack channels for rapid internal response.

  • Personalized Outreach Automation: Creates unique icebreaker messages based on AI insights and automates email sending via Gmail.

  • Robust Data & Report Management: Maintains lead data and automated PDF summaries in fresh copies of Google Sheets for organized tracking and collaboration.

  • Manual Controls & Semantic Indexing: Supports manual workflow triggers and inserts project document embeddings into Pinecone vector stores for enhanced document intelligence.

Who’s This For

  • Commercial Real Estate Brokers & Agents: Automate lead qualification, enrich prospect data, and accelerate personalized outreach to close deals faster.

  • Real Estate Investors & Developer Teams: Efficiently gather and analyze investment project data, verify contacts, and monitor promising leads with AI-enhanced scoring and notifications.

  • B2B Real Estate Marketing & Sales Teams: Streamline lead intake from web forms and optimize campaign engagement with AI-driven profiling and tailored messaging.

  • Property Management Firms: Centralize client and project data enrichment, validation, outreach, and reporting in an automated, scalable workflow.

  • Business Development Managers in Real Estate Sector: Gain actionable insights from multiple data sources (LinkedIn, websites, project decks) to prioritize outreach and close high-value clients.

  • Anyone looking for scalable, AI-powered B2B lead enrichment and outreach automation in the real estate industry.

Setup Instructions Ensure you have an n8n instance and API/OAuth credentials for Apify, Relevance, OpenAI, Google Sheets, Gmail, and Slack. Import the workflow JSON into n8n, then configure all credentials in the Credentials manager. Link the Fillout trigger node to your form webhook. Prepare a Google Sheets master template; the workflow copies it fresh each run for clean data. Add your OpenAI and Slack API keys, configure Gmail OAuth for email sending, then test end-to-end before activating.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Fillout Trigger

Type / Role
n8n-nodes-fillout.filloutTrigger - filloutTrigger
Config choices
Version 1

Block 2 - OpenAI Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenAi - lmChatOpenAi
Config choices
Version 1.2

Block 3 - Pinecone Vector Store

Type / Role
@n8n/n8n-nodes-langchain.vectorStorePinecone - vectorStorePinecone
Config choices
Version 1.3

Block 4 - Embeddings OpenAI

Type / Role
@n8n/n8n-nodes-langchain.embeddingsOpenAi - embeddingsOpenAi
Config choices
Version 1.2

Block 5 - Structured Output Parser

Type / Role
@n8n/n8n-nodes-langchain.outputParserStructured - outputParserStructured
Config choices
Version 1.3

Block 6 - Google Sheets Trigger

Type / Role
n8n-nodes-base.googleSheetsTrigger - googleSheetsTrigger
Config choices
Version 1

Block 7 - Send a message4

Type / Role
n8n-nodes-base.gmail - gmail
Config choices
Version 2.1

Block 8 - When clicking ‘Execute workflow’

Type / Role
n8n-nodes-base.manualTrigger - manualTrigger
Config choices
Version 1

Block 9 - Embeddings OpenAI1

Type / Role
@n8n/n8n-nodes-langchain.embeddingsOpenAi - embeddingsOpenAi
Config choices
Version 1.2

Block 10 - Default Data Loader

Type / Role
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - documentDefaultDataLoader
Config choices
Version 1.1

Block 11 - Map Fillout Submission Fields

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 12 - Append/Update Raw Leads Sheet

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 13 - Verify Email with Apify

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 14 - Map Email Validation Fields

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 15 - Email Validation Status Switch

Type / Role
n8n-nodes-base.switch - switch
Config choices
Version 3.2

Block 16 - Prepare Website Field

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 17 - Crawl Company Website Content

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 18 - Map Website Text Content

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 19 - Prepare LinkedIn Profile URL

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 20 - Fetch LinkedIn Profile Details

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 21 - Map LinkedIn Data for Merge

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 22 - Extract PDF URL from Fillout

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 23 - Download Project Brief PDF

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 24 - Upload PDF to Google Drive

Type / Role
n8n-nodes-base.googleDrive - googleDrive
Config choices
Version 3

Showing the first 24 of 72 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow End-to-end B2B real estate lead enrichment & outreach with Apify, Relevance, OpenAI & Sheets
Complexity advanced
Nodes 72
Categories Lead Generation, AI Summarization
Author Mirza Ajmal
Published 15 Sept 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/8617/8617.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does End-to-end B2B real estate lead enrichment & outreach with Apify, Relevance, OpenAI & Sheets do?

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 ...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Lead Generation, AI Summarization use case.