{
  "name": "Weekly SEO watchlist audit to Google Sheets with Gemini and Decodo",
  "nodes": [
    {
      "id": "2cc333b3-d32b-4223-bac0-9c17ade76528",
      "name": "Done",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1616,
        208
      ]
    },
    {
      "id": "52626e91-8c78-4e20-9397-2068f67c5559",
      "name": "Read Input URLs (Google Sheets)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1168,
        400
      ]
    },
    {
      "id": "776e7963-9169-4462-a9b7-f289b2196d71",
      "name": "Loop URLs (Split in Batches)",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1392,
        400
      ]
    },
    {
      "id": "6628ae2f-d52a-4050-a734-a75707400c27",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": 576,
        "height": 720,
        "content": "## Weekly SEO Watchlist Audit to Google Sheets (Gemini + Decodo)\n\nSign up for Decodo [HERE](https://visit.decodo.com/discount) for Discount\n\nAutomatically fetches page content, generates a compact SEO"
      }
    },
    {
      "id": "7036150a-964b-4315-a41d-5f557b18b196",
      "name": "AI Model: Google Gemini",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        1856,
        624
      ]
    },
    {
      "id": "8a1f65f0-fcd4-472c-adae-96ce769ba991",
      "name": "Output Parser: Enforce SEO JSON",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1984,
        624
      ]
    },
    {
      "id": "84f5205f-945e-459c-b45c-4717ba9e54f0",
      "name": "Trigger: Weekly",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        720,
        400
      ]
    },
    {
      "id": "899ea14f-7813-4689-8438-1d5ae259323f",
      "name": "Decodo: Fetch Page Content",
      "type": "@decodo/n8n-nodes-decodo.decodo",
      "position": [
        1616,
        400
      ]
    },
    {
      "id": "6cf87396-1e7e-4df3-a9f0-7b660bdde5fc",
      "name": "Generate SEO Audit",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        1840,
        400
      ]
    },
    {
      "id": "7e73282d-d648-4823-8379-2b9936e521e9",
      "name": "Transform: Summary Row",
      "type": "n8n-nodes-base.code",
      "position": [
        2192,
        304
      ]
    },
    {
      "id": "04f7eac0-a0a0-4a5a-9335-ab104b771fea",
      "name": "Google Sheets: Append Summary",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2416,
        304
      ]
    },
    {
      "id": "7b6d68e7-4a04-415f-9676-f2a336106b33",
      "name": "Transform: Explode Issues",
      "type": "n8n-nodes-base.code",
      "position": [
        2192,
        496
      ]
    },
    {
      "id": "75d8de44-5812-4164-b3f7-f9c87eaa4cc7",
      "name": "Google Sheets: Append Issues",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2416,
        496
      ]
    },
    {
      "id": "96ff7143-a01e-4197-b5f8-d896fee165c1",
      "name": "Join Summary + Issues",
      "type": "n8n-nodes-base.merge",
      "position": [
        2640,
        496
      ]
    },
    {
      "id": "c706b3ad-70a0-49de-964b-71dbe46ae8db",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        672,
        288
      ],
      "parameters": {
        "width": 192,
        "height": 272,
        "content": "### Adjust interval to your reporting cadence (e.g., every Monday 09:00 UTC)."
      }
    },
    {
      "id": "ec1bd973-3ef6-4b85-9a88-afac819da300",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        896,
        288
      ],
      "parameters": {
        "width": 192,
        "height": 272,
        "content": "### Enter sheet_id for Input, Output, and All Issues tabs."
      }
    },
    {
      "id": "595917c9-2c82-44ec-92ff-a887eeda369d",
      "name": "Set: Configure Workflow",
      "type": "n8n-nodes-base.set",
      "position": [
        944,
        400
      ]
    },
    {
      "id": "092e361c-d545-48e6-9f9a-01f72691654e",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1120,
        288
      ],
      "parameters": {
        "width": 192,
        "height": 288,
        "content": "### Make sure your Input tab contains a column named URL.\n"
      }
    },
    {
      "id": "be6e63cc-7d51-4c0e-a9ec-6bd590548d59",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2368,
        176
      ],
      "parameters": {
        "width": 192,
        "height": 480,
        "content": "### Ensure all columns match the expected field names in this node."
      }
    },
    {
      "id": "ffdb95bd-f5a7-44fd-8cb6-2bd87454af03",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1312,
        -448
      ],
      "parameters": {
        "width": 992,
        "height": 576,
        "content": "@[youtube](Dcy5fOfB68Q)\n"
      }
    }
  ],
  "connections": {
    "Trigger: Weekly": {
      "main": [
        [
          {
            "node": "Set: Configure Workflow",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate SEO Audit": {
      "main": [
        [
          {
            "node": "Transform: Summary Row",
            "type": "main",
            "index": 0
          },
          {
            "node": "Transform: Explode Issues",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Join Summary + Issues": {
      "main": [
        [
          {
            "node": "Loop URLs (Split in Batches)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Transform: Summary Row": {
      "main": [
        [
          {
            "node": "Google Sheets: Append Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Model: Google Gemini": {
      "ai_languageModel": [
        [
          {
            "node": "Generate SEO Audit",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Set: Configure Workflow": {
      "main": [
        [
          {
            "node": "Read Input URLs (Google Sheets)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Transform: Explode Issues": {
      "main": [
        [
          {
            "node": "Google Sheets: Append Issues",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Decodo: Fetch Page Content": {
      "main": [
        [
          {
            "node": "Generate SEO Audit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets: Append Issues": {
      "main": [
        [
          {
            "node": "Join Summary + Issues",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Loop URLs (Split in Batches)": {
      "main": [
        [
          {
            "node": "Done",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Decodo: Fetch Page Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets: Append Summary": {
      "main": [
        [
          {
            "node": "Join Summary + Issues",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Output Parser: Enforce SEO JSON": {
      "ai_outputParser": [
        [
          {
            "node": "Generate SEO Audit",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Read Input URLs (Google Sheets)": {
      "main": [
        [
          {
            "node": "Loop URLs (Split in Batches)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}