Skip to main content

AI Company Research Agent (n8n+Airtable)

Workflow preview

Workflow preview
100%
AI Company Research Agent (n8n+Airtable) preview
Open on n8n.io
n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER Hostinger Early Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

1. Workflow Overview

Video Introduction Want to automate your i...

Best for

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

Tools used

n8n-nodes-base.airtabletrigger, @n8n/n8n-nodes-langchain.openai, n8n-nodes-base.airtable, n8n-nodes-base.stickynote

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Milan Vasarhelyi - SmoothWork.

Original n8n.io source

1.1 Workflow description

Title
AI Company Research Agent (n8n+Airtable)
Workflow name
AI Company Research Agent (n8n+Airtable)

Video Introduction

Want to automate your inbox or need a custom workflow? đź“ž Book a Call | đź’¬ DM me on Linkedin

What This Workflow Does

This workflow automatically enriches your Airtable company database with AI-powered research. Whenever a new company is added to your Airtable base, an AI agent searches the web to discover the company's website and generates a concise 1-2 sentence summary of their business activities. The workflow then updates the Airtable record with these findings, eliminating manual research and keeping your data complete and current.

Key Benefits

  • Automated data enrichment: No more manual web searches for company information
  • AI-powered accuracy: Uses OpenAI with web search capabilities to find reliable, up-to-date information
  • Structured output: Returns data in a predictable JSON format for consistent record updates
  • Real-time processing: Triggers immediately when new companies are added

Setup Requirements

Airtable Configuration:

  • Your Companies table must have a Created time field to trigger the workflow
  • Create an Airtable Personal Access Token at airtable.com/create/tokens with these scopes: data.records:read, data.records:write, and schema.bases:read
  • Ensure your table has fields for Website and Company Details (or modify the field mappings accordingly)

OpenAI Setup:

  • Register for an OpenAI account and obtain an API key
  • Add your OpenAI credentials in n8n

Workflow Configuration:

  • Update the Airtable Trigger node with your base and table URLs
  • Update the Airtable Update node with your specific base and table information
  • Customize the AI prompt if you need different research parameters or output fields

Once published, the workflow runs automatically whenever a new company is added to your table.

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 - New Company Trigger

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

Block 2 - Research Company with AI

Type / Role
@n8n/n8n-nodes-langchain.openAi - openAi
Config choices
Version 2.1

Block 3 - Update Company Record

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

Block 4 - Workflow Description

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

Block 5 - Creator Contact Info

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

Block 6 - Video Walkthrough

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

3. Summary Table

Workflow AI Company Research Agent (n8n+Airtable)
Complexity intermediate
Nodes 6
Categories Lead Generation, AI Summarization
Author Milan Vasarhelyi - SmoothWork
Published 17 Feb 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/13457/13457.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.

Download workflow JSON Original n8n.io source Lead Generation workflows AI Summarization workflows

Frequently asked questions

What does AI Company Research Agent (n8n+Airtable) do?

Video Introduction Want to automate your i...

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.