Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool
13 nodes · outputParserStructured, lmChatOpenAi, googleSheets, toolWorkflow, httpRequest, executeWorkflow
- Engine
- n8n
- Nodes
- 13
- Trigger
- scheduled/triggered
- Source file
- 1694_Webhook_HTTP_Automation_Webhook.json
Workflow flow
Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured
OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
Call n8n workflow : Scrape companies homepage content
@n8n/n8n-nodes-langchain.toolWorkflow
Tool called from Agent
ExecuteWorkflow
Webhook
Webhook
Get rows from Google Sheet
Google Sheets
Set company url
Set
ScrapingBee : Scrape company's homepage data
HTTP
HTML to Markdown
Markdown
Loop Over Items
SplitInBatches
Update Company's Row on Google Sheet
Google Sheets
AI Agent
@n8n/n8n-nodes-langchain.agent
12 steps · flows top to bottom, branches left to right
Browse by integration
Import into n8n
- Download the n8n JSON file (full or sanitized).
- In n8n: Workflows → Import from file.
- Open each node and reconnect credentials to your accounts.
- Test with manual execution before enabling triggers.
Sanitized JSON removes credential IDs — safer for sharing. Flow graph JSON is OpenRuna's lightweight format for diagrams and other tools, not n8n import.
Overview
Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool is a free n8n workflow on OpenRuna — 13 nodes connecting outputParserStructured, lmChatOpenAi, googleSheets, toolWorkflow, httpRequest, executeWorkflow, splitInBatches, agent. Download the JSON, view the flow diagram, and import it into your n8n instance.
What this workflow does
"Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool" is an n8n automation built from 13 nodes spanning outputParserStructured, lmChatOpenAi, googleSheets, toolWorkflow, httpRequest, executeWorkflow, splitInBatches, agent. 13 nodes · outputParserStructured, lmChatOpenAi, googleSheets, toolWorkflow, httpRequest, executeWorkflow It starts from a scheduled/triggered trigger and routes data through every node in order. On OpenRuna you get the visual graph, the integration list, and a downloadable JSON ready to import into n8n. Use it to learn integration patterns, fork it for your own use case, or deploy it quickly after reconnecting credentials.
Use cases
- Use it as a starting template when wiring outputParserStructured, lmChatOpenAi, googleSheets, toolWorkflow, httpRequest, executeWorkflow, splitInBatches, agent — adjust node parameters to your accounts and record IDs.
- Import "Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool" into n8n, reconnect credentials for outputParserStructured, lmChatOpenAi, googleSheets, toolWorkflow, httpRequest, executeWorkflow, splitInBatches, agent, and run the same automation in your own workspace.
- Share it with your team as a documented reference for scheduled/triggered automations in the outputParserStructured stack.
- Study how data moves from outputParserStructured to lmChatOpenAi before building your own variant.
Example output
Imported into n8n, "Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool" exposes 13 configured nodes. Trigger type: scheduled/triggered. Integrations: outputParserStructured, lmChatOpenAi, googleSheets, toolWorkflow, httpRequest, executeWorkflow, splitInBatches, agent. Open each node after import to map credentials to your own outputParserStructured and lmChatOpenAi accounts. Run it once in test mode to verify any branch logic (Switch/IF nodes) before enabling production triggers.
Tips by platform
Claude
Paste the exported JSON for "Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool" into Claude and ask it to explain each of the 13 nodes. Claude is good at suggesting credential mappings for outputParserStructured, lmChatOpenAi, googleSheets, toolWorkflow, httpRequest, executeWorkflow, splitInBatches, agent, plus error-handling and idempotency improvements before you run it in production.
ChatGPT
Have ChatGPT generate a checklist for adapting "Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool" to your accounts — which outputParserStructured, lmChatOpenAi, googleSheets, toolWorkflow, httpRequest, executeWorkflow, splitInBatches, agent credentials to create and which node parameters to change first.
Cursor
Open the downloaded JSON in Cursor and use Agent mode to refactor hard-coded URLs into env vars, or to generate tests for any Code nodes. Keep the OpenRuna flow diagram open so you do not break connection order across the 13 nodes.
Frequently asked questions
- How do I import "Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool" into n8n?
- Click Download n8n JSON on this page, then in n8n choose Workflows → Import from file and select the downloaded file. Reconnect credentials on each node — the export carries credential IDs from the original author's instance, not working secrets.
- Which integrations does "Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool" use?
- It uses: outputParserStructured, lmChatOpenAi, googleSheets, toolWorkflow, httpRequest, executeWorkflow, splitInBatches, agent. The flow diagram above shows how each service connects across the 13 nodes. Filter OpenRuna by integration to find related workflows and tools.
- Can I import a sanitized export without credentials?
- Yes. Use "Download sanitized JSON" to strip credential references before sharing internally. You will still add your own outputParserStructured and lmChatOpenAi credentials in n8n after import.
- What trigger type does "Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool" use?
- Trigger type: scheduled/triggered. After import, confirm the trigger node (webhook, schedule, or app event) matches your environment, then activate the workflow when you are ready to run it.
- Is "Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool" free to use?
- OpenRuna catalogs community n8n workflows under open licenses. Check the source corpus link for the original license; commercial use may require verifying the third-party API terms for outputParserStructured, lmChatOpenAi, googleSheets, toolWorkflow, httpRequest, executeWorkflow, splitInBatches, agent.
Related resources
- Agent
PraisonAI
24/7 AI employee team for automating complex challenges. Low-code multi-agent framework with handoffs, guardrails, memory, RAG, and 100+ LLM providers
- Agent
Prompt Optimizer
AI prompt optimization tool with multi-round iterative improvements, dual-mode optimization for system and user prompts, and multi-model support. Available as web app, desktop app, Chrome extension, and Docker deployment. AGPL-3.0 licensed
- Agent
Archon
Workflow engine for deterministic AI coding agents. Define development processes as YAML workflows (planning → implementation → validation → review → PR) with isolated Git worktrees for parallel execution. MIT licensed
- Agent
A2A Protocol
Agent2Agent (A2A) open protocol enabling communication and interoperability between opaque agentic applications. Donated to Linux Foundation by Google with 50+ technology partners. Apache 2.0 licensed
- Agent
CAMEL
First and best multi-agent framework for building scalable agent systems. Apache 2.0 licensed with extensive tooling for agent communication and task automation
- Agent
Neuron AI
PHP Agentic Framework for building production-ready AI driven applications. Connect components (LLMs, vector DBs, memory) to agents that can interact with your data. MIT licensed
- Agent
smolagents
Lightweight agent framework centered on tool use and code-executing workflows
- Agent
Supermemory
Memory API and app for AI agents that provides fast, scalable, context-aware storage and retrieval across projects. MIT licensed
