(5/5)

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

Automated workflow: Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool. This workflow integrates 13 different services: webhook, stickyNote, httpRequest, markdown, splitInBatches. It contains 20 nodes and follows best practices for error handling and security.

Integrations Used (4)

Workflow Structure (12 nodes)

100%

Webhook

Google Sheets

Get rows from Google Sheet

Split In Batches

Loop Over Items

No Op

AI Agent

Google Sheets

Update Company's Row on Google Sheet

Execute Workflow Trigger

Tool called from Agent

Set

Set company url

Http Request

ScrapingBee : Scrape company's homepage data

No Op

OpenAI Chat Model

Markdown

HTML to Markdown

No Op

Call n8n workflow : Scrape companies homepage content

No Op

Structured Output Parser

Node Types:

default

action

http

trigger

logic

transform

Requires credentials

Prerequisites

Required Credentials (2)

Google

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

Docs

OpenAI

Used by: OpenAI Chat Model

Docs

Complexity

Complex

Advanced features used. Requires n8n experience.

Setup time: ~35 min

Score: 52/100

Loops

6 Integrations

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json

{
  "id": "TfwQRZkTBtykx1rM",
  "meta": {
    "instanceId": "workflow-7aa284fe",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:08:01.345370",
    "updatedAt": "2025-09-29T07:08:01.345417",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "name": "Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool",
  "tags": [
    "automation",
    "n8n",
    "production-ready",
    "excellent",
...