{
  "name": "Extract and analyze Google AI overviews with LLM for SEO recommendations",
  "nodes": [
    {
      "id": "d54405a8-ce00-4f39-bcea-fae97338a27f",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -120,
        20
      ]
    },
    {
      "id": "2853ad27-91c9-405a-b696-b077823a1021",
      "name": "When clicking 'Execute workflow'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -100,
        740
      ]
    },
    {
      "id": "9dfbb1ee-6979-49bd-8963-f1b7f339feb5",
      "name": "Save AI Overview to Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        620,
        20
      ]
    },
    {
      "id": "b2453757-c908-4747-8029-2d24e5690be4",
      "name": "myURL Exists",
      "type": "n8n-nodes-base.filter",
      "position": [
        560,
        840
      ]
    },
    {
      "id": "f48fc7a2-c6ac-4426-9986-e987e5dc9a23",
      "name": "Extract Page Title and H1",
      "type": "n8n-nodes-base.html",
      "position": [
        1440,
        800
      ]
    },
    {
      "id": "d250bdc4-0b58-41f4-afa2-ba82f67d67d6",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        1660,
        700
      ]
    },
    {
      "id": "67d57eb8-2edc-4592-a9e2-0a5c0bade571",
      "name": "Fetch Page Content",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1220,
        700
      ]
    },
    {
      "id": "8d816cf1-dae5-4a47-9117-ed13dc9a4590",
      "name": "Process URLs in Batches",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        780,
        840
      ]
    },
    {
      "id": "d8db7f48-21e3-4f7b-a48a-6931cf397601",
      "name": "Get Current URL Data",
      "type": "n8n-nodes-base.set",
      "position": [
        1000,
        700
      ]
    },
    {
      "id": "c82ae7fe-8369-461c-8661-ebd51371138b",
      "name": "Save SEO Guidelines to Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2260,
        700
      ]
    },
    {
      "id": "ecd9fbfa-328f-4507-a662-0c0d6e6f620e",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -100,
        940
      ]
    },
    {
      "id": "90c30cd2-9b88-48e0-8846-065340014f29",
      "name": "Wait",
      "type": "n8n-nodes-base.wait",
      "position": [
        2480,
        840
      ]
    },
    {
      "id": "e0516ed5-69cd-4543-8816-aa70579aef2a",
      "name": "Limit",
      "type": "n8n-nodes-base.limit",
      "position": [
        340,
        840
      ]
    },
    {
      "id": "30c3e6fb-044b-4d8c-8da2-5e67d95f397b",
      "name": "Get URLs to Analyze",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        140,
        800
      ]
    },
    {
      "id": "2253258b-846f-445d-baa8-7cb754a32738",
      "name": "Gemini 2.5 Pro Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        1880,
        920
      ]
    },
    {
      "id": "5eeb0cd6-7fd9-4fd0-9053-08607bdc824c",
      "name": "Convert AI Overview to Markdown",
      "type": "n8n-nodes-base.markdown",
      "position": [
        320,
        20
      ]
    },
    {
      "id": "85e2d470-f80a-44db-8166-31b2883a310b",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -200,
        -100
      ],
      "parameters": {
        "width": 1060,
        "height": 320,
        "content": "## Get data\nThis flow get data from webhook and stores it into Google Sheets. After you get data in sheets you need paste your site url in myURL and wait for guidelines."
      }
    },
    {
      "id": "cc15d895-9211-4480-8593-97c5e7f84697",
      "name": "Generate SEO Recommendations",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        1880,
        700
      ]
    },
    {
      "id": "7443adb0-440c-4223-8362-55641f0afa21",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -200,
        480
      ],
      "parameters": {
        "width": 2920,
        "height": 680,
        "content": "## Guidelines flow\nThis flow generates guidelines and stores it in Google Sheets"
      }
    },
    {
      "id": "5607f7b6-c6b2-4325-95ae-1d749959946b",
      "name": "Extract Webhook Data",
      "type": "n8n-nodes-base.set",
      "position": [
        100,
        20
      ]
    },
    {
      "id": "93567700-0a9e-4a19-934e-ee6d98eb9ba6",
      "name": "Convert Page Content to Markdown",
      "type": "n8n-nodes-base.markdown",
      "position": [
        1440,
        600
      ]
    }
  ],
  "connections": {
    "Wait": {
      "main": [
        [
          {
            "node": "Process URLs in Batches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit": {
      "main": [
        [
          {
            "node": "myURL Exists",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge": {
      "main": [
        [
          {
            "node": "Generate SEO Recommendations",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook": {
      "main": [
        [
          {
            "node": "Extract Webhook Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "myURL Exists": {
      "main": [
        [
          {
            "node": "Process URLs in Batches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get URLs to Analyze",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Page Content": {
      "main": [
        [
          {
            "node": "Convert Page Content to Markdown",
            "type": "main",
            "index": 0
          },
          {
            "node": "Extract Page Title and H1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get URLs to Analyze": {
      "main": [
        [
          {
            "node": "Limit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Webhook Data": {
      "main": [
        [
          {
            "node": "Convert AI Overview to Markdown",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gemini 2.5 Pro Model": {
      "ai_languageModel": [
        [
          {
            "node": "Generate SEO Recommendations",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Get Current URL Data": {
      "main": [
        [
          {
            "node": "Fetch Page Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process URLs in Batches": {
      "main": [
        [],
        [
          {
            "node": "Get Current URL Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Page Title and H1": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Generate SEO Recommendations": {
      "main": [
        [
          {
            "node": "Save SEO Guidelines to Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save SEO Guidelines to Sheets": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert AI Overview to Markdown": {
      "main": [
        [
          {
            "node": "Save AI Overview to Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert Page Content to Markdown": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking 'Execute workflow'": {
      "main": [
        [
          {
            "node": "Get URLs to Analyze",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}