Web Scraping & Data Extraction

Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool

Manual

High

Nodes

Manual

Trigger

High

Complexity

7/22/2025

Added

Workflow Overview

Total Nodes

Node Types

output Parser Structured

Structured Output Parser

1 node

lm Chat Open Ai

OpenAI Chat Model

1 node

google Sheets

Get rows from Google Sheet, Update Company's Row on Google Sheet

2 nodes

tool Workflow

Call n8n workflow : Scrape companies homepage content

1 node

http Request

ScrapingBee : Scrape company's homepage data

1 node

execute Workflow Trigger

Tool called from Agent

1 node

split In Batches

Loop Over Items

1 node

sticky Note

Sticky Note

1 node

agent

AI Agent

1 node

set

Set company url

1 node

markdown

HTML to Markdown

1 node

webhook

Webhook

1 node

Workflow JSON

20.72 KB

{
  "id": "TfwQRZkTBtykx1rM",
  "meta": {
    "instanceId": "",
    "templateCredsSetupCompleted": true
  },
  "name": "Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool",
  "tags": [],
  "nodes": [
    {
      "id": "90c02c5e-228e-478b-b06d-424dc0c4f9b9",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1500,
        240
      ],
      "parameters": {
        "schemaType": "manual",
        "inputSchema": "{\n  \"Business Area\": {\n    \"type\": \"string\",\n    \"description\": \"Summary of the company's core activities or industry focus.\"\n  },\n  \"Offers or Product\": {\n    \"type\": \"string\",\n    \"description\": \"Summary of the company's main products or services.\"\n  },\n  \"Value Proposition\": {\n    \"type\": \"string\",\n    \"description\": \"Catchphrase or tagline that represents the company’s value proposition.\"\n  },\n  \"Business Model\": {\n    \"type\...

Showing first 1000 characters. Click "Expand" to view the full JSON.