{
  "name": "Google Search Console and analytics analysis with AI optimizations",
  "nodes": [
    {
      "id": "4a4b478e-b5f8-4ddc-a6cc-48f1274cb5d6",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -300,
        -300
      ]
    },
    {
      "id": "b52900dd-a2bd-42bb-8e1d-ce3cff259ec7",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        40,
        580
      ]
    },
    {
      "id": "1ebe691b-6b76-4956-b181-c2be251d48be",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -40,
        480
      ],
      "parameters": {
        "width": 1620,
        "height": 640,
        "content": "## Get Google Data and Push It Through AI"
      }
    },
    {
      "id": "7194a576-50ab-4df0-b6db-d6a74bcbb927",
      "name": "Enforce Order - Positions Last",
      "type": "n8n-nodes-base.merge",
      "position": [
        280,
        260
      ]
    },
    {
      "id": "be892b2b-6141-415c-a503-d4f7d467cc6a",
      "name": "Remove Duplicates",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        940,
        -60
      ]
    },
    {
      "id": "ebb767ad-a8db-449a-8d52-56731248e9e5",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        240,
        -140
      ],
      "parameters": {
        "width": 880,
        "height": 320,
        "content": "## Get All Pages From Sitemap"
      }
    },
    {
      "id": "d421db5a-c224-44ef-a471-d64ca8ddaa69",
      "name": "Get sitemap XML",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        280,
        -60
      ]
    },
    {
      "id": "6bf0e08e-1cfa-4484-b953-cd215447d053",
      "name": "Convert to JSON",
      "type": "n8n-nodes-base.xml",
      "position": [
        500,
        -60
      ]
    },
    {
      "id": "b5ab24fc-8c0f-4158-9452-35fc682246ff",
      "name": "Split Out to Table",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        720,
        -60
      ]
    },
    {
      "id": "81c644b2-1de8-4f51-be73-ac2246fb3c5f",
      "name": "Limit for Testing Purposes",
      "type": "n8n-nodes-base.limit",
      "position": [
        1400,
        -60
      ]
    },
    {
      "id": "77c271b5-99b9-4adf-8b7f-7dc0846325bd",
      "name": "Wait to Comply with API Limits",
      "type": "n8n-nodes-base.wait",
      "position": [
        900,
        500
      ]
    },
    {
      "id": "00b83323-17ef-44a1-82b1-eb867e532556",
      "name": "Globals - CHANGE ME!",
      "type": "n8n-nodes-base.set",
      "position": [
        40,
        -60
      ]
    },
    {
      "id": "cde1f4e7-f45d-4c64-906e-3b191550fc9a",
      "name": "Get Page GSC Status",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        280,
        560
      ]
    },
    {
      "id": "c4856013-3111-4c04-b4d2-f92ad8f1cd88",
      "name": "Get Page GSC Stats",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        280,
        740
      ]
    },
    {
      "id": "b5e8f02d-320c-4fab-9e38-2a6dbb97e7b1",
      "name": "Merge Status and Stats",
      "type": "n8n-nodes-base.merge",
      "position": [
        540,
        680
      ]
    },
    {
      "id": "c7ff4009-65be-4d4a-b3dd-f711e7cefebb",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        660,
        880
      ]
    },
    {
      "id": "133cbc78-a835-4d6c-a366-187d3f2ca4b1",
      "name": "Get Google Analytics Data",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        280,
        920
      ]
    },
    {
      "id": "fc55254f-012b-4387-af4c-54211b386182",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequestTool",
      "position": [
        940,
        880
      ]
    },
    {
      "id": "3658c627-a22b-4f4c-b2ee-33e9a361bb1e",
      "name": "Merge AI Output With AI Input",
      "type": "n8n-nodes-base.merge",
      "position": [
        1400,
        900
      ]
    },
    {
      "id": "b92d08c4-13a3-4c92-b37f-da3a7a5ee7dc",
      "name": "Markdown to HTML",
      "type": "n8n-nodes-base.markdown",
      "position": [
        1120,
        900
      ]
    },
    {
      "id": "a77ef66d-1313-43ee-b23f-c23a24529026",
      "name": "Keep Only Valuable Columns",
      "type": "n8n-nodes-base.set",
      "position": [
        500,
        260
      ]
    },
    {
      "id": "fad58242-29c7-4c48-ae3f-667559cfd644",
      "name": "Change to HTML table for sending",
      "type": "n8n-nodes-base.html",
      "position": [
        720,
        260
      ]
    },
    {
      "id": "3d737f97-9d5c-4f0c-8a2a-cbe98e0879d2",
      "name": "Send Email with Full report",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        940,
        260
      ]
    },
    {
      "id": "8888143f-73ed-4ac7-84ee-b5b4bcf64c6e",
      "name": "Sort For Testing Purposes",
      "type": "n8n-nodes-base.sort",
      "position": [
        1180,
        -60
      ]
    },
    {
      "id": "fd4431b6-8a0a-4a2b-a70b-17d3fc2f34b5",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1140,
        -140
      ],
      "parameters": {
        "width": 440,
        "height": 320,
        "content": "## Limit for Testing"
      }
    },
    {
      "id": "b821114e-234c-4183-a957-d5048f366ecd",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -20,
        -140
      ],
      "parameters": {
        "width": null,
        "height": 320,
        "content": "## Setup Me First"
      }
    },
    {
      "id": "2e0a5df7-7dd1-4ca7-b9e7-763928b32913",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        240,
        200
      ],
      "parameters": {
        "width": 1340,
        "height": 260,
        "content": "## Get Email Report"
      }
    },
    {
      "id": "a16024d1-28a1-4b73-85b7-fc15e9620184",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -420,
        -140
      ],
      "parameters": {
        "width": 380,
        "height": 320,
        "content": "- sitemap_url - self exlpainatory\n- search_console_selector - for example \"sc-domain:sailingbyte.com\" but can be URL aswell- depends on how did you set up your search console\n- analysis_start_date and"
      }
    },
    {
      "id": "cd5d0d57-f04a-4094-8f26-855dd1051589",
      "name": "SEO analyst",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        780,
        680
      ]
    }
  ],
  "connections": {
    "SEO analyst": {
      "main": [
        [
          {
            "node": "Markdown to HTML",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "ai_tool": [
        [
          {
            "node": "SEO analyst",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Convert to JSON": {
      "main": [
        [
          {
            "node": "Split Out to Table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get sitemap XML": {
      "main": [
        [
          {
            "node": "Convert to JSON",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Enforce Order - Positions Last",
            "type": "main",
            "index": 1
          }
        ],
        [
          {
            "node": "Get Page GSC Status",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get Page GSC Stats",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get Google Analytics Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Markdown to HTML": {
      "main": [
        [
          {
            "node": "Merge AI Output With AI Input",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "SEO analyst",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Remove Duplicates": {
      "main": [
        [
          {
            "node": "Sort For Testing Purposes",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Page GSC Stats": {
      "main": [
        [
          {
            "node": "Merge Status and Stats",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Split Out to Table": {
      "main": [
        [
          {
            "node": "Remove Duplicates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Page GSC Status": {
      "main": [
        [
          {
            "node": "Merge Status and Stats",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Globals - CHANGE ME!": {
      "main": [
        [
          {
            "node": "Get sitemap XML",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Status and Stats": {
      "main": [
        [
          {
            "node": "SEO analyst",
            "type": "main",
            "index": 0
          },
          {
            "node": "Wait to Comply with API Limits",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Google Analytics Data": {
      "main": [
        [
          {
            "node": "Merge Status and Stats",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Sort For Testing Purposes": {
      "main": [
        [
          {
            "node": "Limit for Testing Purposes",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Keep Only Valuable Columns": {
      "main": [
        [
          {
            "node": "Change to HTML table for sending",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit for Testing Purposes": {
      "main": [
        [
          {
            "node": "Enforce Order - Positions Last",
            "type": "main",
            "index": 0
          },
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge AI Output With AI Input": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Enforce Order - Positions Last": {
      "main": [
        [
          {
            "node": "Keep Only Valuable Columns",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait to Comply with API Limits": {
      "main": [
        [
          {
            "node": "Merge AI Output With AI Input",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Change to HTML table for sending": {
      "main": [
        [
          {
            "node": "Send Email with Full report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Globals - CHANGE ME!",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}