Skip to main content

Generate structured company descriptions with Bedrijfsdata Web RAG & OpenAI

Workflow preview

Workflow preview
100%
Generate structured company descriptions with Bedrijfsdata Web RAG & OpenAI 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 workflow contains community nodes that are only compatible with the self hosted version of n8n. This template generates structured synthetic company content using live web data from the Bedrij...

Best for

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

Tools used

n8n-nodes-base.if, n8n-nodes-base.stickynote, @bedrijfsdatanl/n8n-nodes-bedrijfsdata.bedrijfsdata, @n8n/n8n-nodes-langchain.chainllm, @n8n/n8n-nodes-langchain.lmchatopenai, @n8n/n8n-nodes-langchain.outputparserstructured, @bedrijfsdatanl/n8n-nodes-prospectpro.prospectpro, n8n-nodes-base.executeworkflowtrigger

Source and attribution

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

Original n8n.io source

1.1 Workflow description

Title
Generate structured company descriptions with Bedrijfsdata Web RAG & OpenAI
Workflow name
Generate structured company descriptions with Bedrijfsdata Web RAG & OpenAI

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

This template generates structured synthetic company content using live web data from the Bedrijfsdata.nl API combined with an LLM. Provide a company domain (directly or via a Bedrijfsdata.nl ID) and the workflow retrieves relevant website and search engine content, then produces ready-to-use descriptions of the company, its offerings, and its target audience.

Features

  • Create high-quality Dutch-language company descriptions on demand
  • Automatically pull live web content via Bedrijfsdata.nl RAG Domain & RAG Search
  • Structured JSON output for consistent downstream use (e.g., CRM updates, lead qualification)
  • Flexible trigger: run from ProspectPro ID, domain input, or another workflow
  • Secure, modular, and extendable structure (error handling included)

🏢 Example Output The workflow produces structured content fields you can directly use in your sales, marketing, or enrichment flows:

  • company_description – 1-2 paragraph summary of the company
  • products_and_services – detailed overview of offerings
  • target_audience – specific characteristics of ideal customers (e.g., industry, location, company size, software usage)

Example:

{
  "company_description": "Bedrijfsdata.nl B.V. is een Nederlands bedrijf dat uitgebreide data levert over meer dan 3,7 miljoen bedrijven in Nederland...",
  "products_and_services": "Het bedrijf biedt API-toegang tot bedrijfsprofielen, sectoranalyses, en SEO-gegevens...",
  "target_audience": "Nederlandse MKB's die behoefte hebben aan actuele bedrijfsinformatie voor marketing- of salesdoeleinden..."
}

Requirements

  • n8n instance or cloud workspace
  • Install the Bedrijfsdata.nl n8n Verified Community Node
  • OpenAI API credentials (tested with gpt-4.1-mini and gpt-3.5-turbo)
  • Bedrijfsdata.nl developer account (14-day free trial, 500 credits)

🔧 Setup Instructions

1. Trigger configuration

  • Use Bedrijfsdata.nl ID (default) or provide a domain directly
  • Can be called from another workflow using “Execute Workflow”

2. Configure API credentials

  • Bedrijfsdata.nl API key

  • OpenAI API key

3. Customize Output (Optional)

  • Adjust prompt in the LLM node to create other types of synthetic content
  • Extend structured output schema for your use case

4. Integrate with Your Stack

  • Example node included to update HubSpot descriptions
  • Replace or extend to match your CRM, database, or messaging tools

🔐 Security Notes

  • Input validation for required domain
  • Dedicated error branches for invalid input, API errors, LLM errors, and downstream integration errors
  • RAG content checks before running the LLM

🧪 Testing

  • Run workflow with a Bedrijfsdata.nl ID linked to a company with a known website
  • Review generated JSON output
  • Verify content accuracy before production use

📌 About Bedrijfsdata.nl Bedrijfsdata.nl operates the most comprehensive company database in the Netherlands. With real-time data on 3.7M+ businesses and AI-ready APIs, we help Dutch SMEs enrich their CRM, workflows, and marketing automation. Built on 25+ years of experience in data collection and enrichment, our technology brings corporate-grade data quality to every organisation.

Website: https://www.bedrijfsdata.nl Developers: https://developers.bedrijfsdata.nl API docs: https://docs.bedrijfsdata.nl

📞 Support Email: [email protected] Phone: +31 20 789 50 50 Support hours: Monday–Friday, 09:00–17:00 CET

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 - Company domain is required

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 2 - Sticky Note

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

Block 3 - Sticky Note1

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

Block 4 - Get rag search

Type / Role
@bedrijfsdatanl/n8n-nodes-bedrijfsdata.bedrijfsdata - bedrijfsdata
Config choices
Version 1

Block 5 - Content available to proceed?

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 6 - Sticky Note2

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

Block 7 - Basic LLM Chain

Type / Role
@n8n/n8n-nodes-langchain.chainLlm - chainLlm
Config choices
Version 1.7

Block 8 - OpenAI Chat Model

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

Block 9 - Structured Output Parser

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

Block 10 - Sticky Note3

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

Block 11 - Get prospect

Type / Role
@bedrijfsdatanl/n8n-nodes-prospectpro.prospectpro - prospectpro
Config choices
Version 1

Block 12 - Get RAG domain

Type / Role
@bedrijfsdatanl/n8n-nodes-bedrijfsdata.bedrijfsdata - bedrijfsdata
Config choices
Version 1

Block 13 - When Executed by Another Workflow

Type / Role
n8n-nodes-base.executeWorkflowTrigger - executeWorkflowTrigger
Config choices
Version 1.1

Block 14 - Sticky Note4

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

Block 15 - Prepare content to feed to LLM

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 16 - Sticky Note7

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

Block 17 - Error type 1: invalid input

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

Block 18 - Error type 2: RAG error

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

Block 19 - Error type 3: LLM error

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

Block 20 - Update company description

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

Block 21 - Error type 4: Hubspot error

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

3. Summary Table

Workflow Generate structured company descriptions with Bedrijfsdata Web RAG & OpenAI
Complexity advanced
Nodes 21
Categories Lead Generation, Multimodal AI
Author Olivier
Published 14 Aug 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/7365/7365.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 Generate structured company descriptions with Bedrijfsdata Web RAG & OpenAI do?

This workflow contains community nodes that are only compatible with the self hosted version of n8n. This template generates structured synthetic company content using live web data from the Bedrij...

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, Multimodal AI use case.