{
  "openruna_format": "flow-graph-v1",
  "title": "Enrich Company Data from Google Sheet with OpenAI Agent and Scraper Tool",
  "slug": "enrich-company-data-from-google-sheet-with-openai-agent-and-scraper-tool",
  "source_filename": "1694_Webhook_HTTP_Automation_Webhook.json",
  "nodes": [
    {
      "id": "Structured Output Parser",
      "name": "Structured Output Parser",
      "integration": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "kind": "action"
    },
    {
      "id": "OpenAI Chat Model",
      "name": "OpenAI Chat Model",
      "integration": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "kind": "action"
    },
    {
      "id": "Get rows from Google Sheet",
      "name": "Get rows from Google Sheet",
      "integration": "googleSheets",
      "kind": "action"
    },
    {
      "id": "Call n8n workflow  : Scrape companies homepage content",
      "name": "Call n8n workflow  : Scrape companies homepage content",
      "integration": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "kind": "action"
    },
    {
      "id": "Update Company's Row on Google Sheet",
      "name": "Update Company's Row on Google Sheet",
      "integration": "googleSheets",
      "kind": "action"
    },
    {
      "id": "ScrapingBee : Scrape company's homepage data",
      "name": "ScrapingBee : Scrape company's homepage data",
      "integration": "httpRequest",
      "kind": "action"
    },
    {
      "id": "Tool called from Agent",
      "name": "Tool called from Agent",
      "integration": "executeWorkflow",
      "kind": "trigger"
    },
    {
      "id": "Loop Over Items",
      "name": "Loop Over Items",
      "integration": "splitInBatches",
      "kind": "logic"
    },
    {
      "id": "AI Agent",
      "name": "AI Agent",
      "integration": "@n8n/n8n-nodes-langchain.agent",
      "kind": "action"
    },
    {
      "id": "Set company url",
      "name": "Set company url",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "HTML to Markdown",
      "name": "HTML to Markdown",
      "integration": "markdown",
      "kind": "action"
    },
    {
      "id": "Webhook",
      "name": "Webhook",
      "integration": "webhook",
      "kind": "trigger"
    }
  ],
  "edges": [
    {
      "from": "Webhook",
      "to": "Get rows from Google Sheet"
    },
    {
      "from": "AI Agent",
      "to": "Loop Over Items"
    },
    {
      "from": "Loop Over Items",
      "to": "Update Company's Row on Google Sheet"
    },
    {
      "from": "Loop Over Items",
      "to": "AI Agent"
    },
    {
      "from": "Set company url",
      "to": "ScrapingBee : Scrape company's homepage data"
    },
    {
      "from": "Tool called from Agent",
      "to": "Set company url"
    },
    {
      "from": "Get rows from Google Sheet",
      "to": "Loop Over Items"
    },
    {
      "from": "ScrapingBee : Scrape company's homepage data",
      "to": "HTML to Markdown"
    }
  ]
}