{
  "name": "Enrich company data from Google Sheet with OpenAI Agent and ScrapingBee",
  "nodes": [
    {
      "id": "90c02c5e-228e-478b-b06d-424dc0c4f9b9",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1500,
        240
      ]
    },
    {
      "id": "81392d70-3b36-4014-8239-97ea1d69e522",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1240,
        240
      ]
    },
    {
      "id": "62d84f70-43a2-43aa-815e-56842230c9b1",
      "name": "Get rows from Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        660,
        0
      ]
    },
    {
      "id": "3b1050a8-5992-4a5b-a6a4-b91472a12dd4",
      "name": "Call n8n workflow  : Scrape companies homepage content",
      "type": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "position": [
        1380,
        260
      ]
    },
    {
      "id": "e451cc56-0cef-4bd8-b13e-210d5ddf3001",
      "name": "Update Company's Row on Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1660,
        -200
      ]
    },
    {
      "id": "f2f31704-3e93-4c3f-bb70-9f41d1c625a9",
      "name": "ScrapingBee : Scrape company's homepage data ",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1020,
        400
      ]
    },
    {
      "id": "d0180b22-8938-4590-a58a-0455ac808c68",
      "name": "Tool called from Agent",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        440,
        400
      ]
    },
    {
      "id": "2f65dece-0236-4d45-b965-7ca705fa4621",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        960,
        0
      ]
    },
    {
      "id": "78ae2393-3744-445a-bf28-6dab1f4a8aec",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -840,
        -480
      ],
      "parameters": {
        "width": 1084.896634444991,
        "height": 1812.538665002239,
        "content": "# Enrich Company Data from Google Sheet with OpenAI Scraper Agent\n\nThis workflow demonstrates how to enrich data from a list of companies in a spreadsheet. While this workflow is production-ready if a"
      }
    },
    {
      "id": "8440fbe4-a3b3-4801-95f9-55df90c862fe",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1600,
        20
      ]
    },
    {
      "id": "bf1987fb-ce72-47c1-a020-6ec41e8731e3",
      "name": "Set company url",
      "type": "n8n-nodes-base.set",
      "position": [
        760,
        400
      ]
    },
    {
      "id": "f0a86878-8db1-4761-a135-9d7a3caac288",
      "name": "HTML to Markdown",
      "type": "n8n-nodes-base.markdown",
      "position": [
        1360,
        400
      ]
    },
    {
      "id": "f53b19c5-dcb9-4239-8be8-122a9e479a55",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        300,
        0
      ]
    }
  ],
  "connections": {
    "Webhook": {
      "main": [
        [
          {
            "node": "Get rows from Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Update Company's Row on Google Sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set company url": {
      "main": [
        [
          {
            "node": "ScrapingBee : Scrape company's homepage data ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Tool called from Agent": {
      "main": [
        [
          {
            "node": "Set company url",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "AI Agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Get rows from Google Sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ScrapingBee : Scrape company's homepage data ": {
      "main": [
        [
          {
            "node": "HTML to Markdown",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Call n8n workflow  : Scrape companies homepage content": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}