{
  "name": "Automate weekly SEO report with GPT-4 insights and Slack delivery",
  "nodes": [
    {
      "id": "43d47434-1125-439d-ba6a-cab092db3f46",
      "name": "Configuration",
      "type": "n8n-nodes-base.set",
      "position": [
        -1380,
        520
      ]
    },
    {
      "id": "448882ac-8fe0-45fb-b86f-7d019f9268ac",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2120,
        420
      ],
      "parameters": {
        "width": 420,
        "height": 560,
        "content": "# Welcome to Weekly SEO Report Workflow!\n\n**This workflow has the following sequence:**\n1. Time trigger (e.g. every Monday at 8 a.m.)\n2. Retrieval of Google Search Console data from the last month and"
      }
    },
    {
      "id": "319de69b-177d-4d42-b4cb-3e35ba5e80dc",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1440,
        420
      ],
      "parameters": {
        "width": 220,
        "height": 320,
        "content": "**Here you'll configure:**\n- Site URL\n- Date range"
      }
    },
    {
      "id": "0b8f7ebe-4629-405a-84ff-0dcf9334f272",
      "name": "Pdforge",
      "type": "n8n-nodes-pdforge.pdforge",
      "position": [
        600,
        520
      ]
    },
    {
      "id": "c744768d-3ffc-4ec8-8526-62992e9cdea0",
      "name": "Download Binary",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        820,
        520
      ]
    },
    {
      "id": "1f0baeea-eb35-4dff-b9c4-1b4a95b53121",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -40,
        700
      ]
    },
    {
      "id": "41fa4fa0-72a7-4402-b1ae-73615d55b3ec",
      "name": "Generate variables",
      "type": "n8n-nodes-base.code",
      "position": [
        380,
        520
      ]
    },
    {
      "id": "639a05bc-e87f-4d1b-afb7-d95a3926676c",
      "name": "Slack - Send Message with File",
      "type": "n8n-nodes-base.slack",
      "position": [
        1040,
        520
      ]
    },
    {
      "id": "16032072-de5c-40c5-b8c3-52c6575e1157",
      "name": "Weekly at monday 8am",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1600,
        520
      ]
    },
    {
      "id": "94ab0f9b-2c78-4e41-8388-2c707b4965ca",
      "name": "HTTP Request - Google Search Console - Query - Previous Month",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1100,
        1120
      ]
    },
    {
      "id": "ef74bcb0-c187-4135-ac30-fe6ec31723bf",
      "name": "HTTP Request - Google Search Console - Page - Previous month",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1100,
        1320
      ]
    },
    {
      "id": "58b0abf2-d9f7-41bc-b6cb-c4c57b60e6d2",
      "name": "Split Out Pages - Previous month",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -880,
        1320
      ]
    },
    {
      "id": "0c7e046b-6a6c-4465-b265-c353f40fc7e0",
      "name": "Format Query - Previous month",
      "type": "n8n-nodes-base.set",
      "position": [
        -660,
        1120
      ]
    },
    {
      "id": "72775f4f-742e-4597-bf75-971d1d280285",
      "name": "HTTP Request - Google Search Console - Date",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1100,
        -80
      ]
    },
    {
      "id": "c5be25f2-011b-4680-ab57-aab7f2ef96f7",
      "name": "Split Out Date",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -880,
        -80
      ]
    },
    {
      "id": "ce7e232a-47dc-4844-b603-de92e3b2b624",
      "name": "Format Date",
      "type": "n8n-nodes-base.set",
      "position": [
        -660,
        -80
      ]
    },
    {
      "id": "26335560-27b4-4d61-ae22-52a2932bb2c8",
      "name": "HTTP Request - Google Search Console - Overview",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1100,
        -280
      ]
    },
    {
      "id": "f6f9d96e-6db8-4626-b717-cd9b020b98a8",
      "name": "Split Out Overview",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -880,
        -280
      ]
    },
    {
      "id": "ab057902-8e4c-4beb-bc00-13fcd3d4d0ce",
      "name": "Format Overview",
      "type": "n8n-nodes-base.set",
      "position": [
        -660,
        -280
      ]
    },
    {
      "id": "61e0c8ee-f857-4089-ad25-85b3d9a5d44e",
      "name": "HTTP Request - Google Search Console - Page",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1100,
        320
      ]
    },
    {
      "id": "73834d1c-19a3-4161-892c-7bd3615b41e9",
      "name": "Split Out Pages",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -880,
        320
      ]
    },
    {
      "id": "945371f9-5929-415b-990b-3074653c0c17",
      "name": "HTTP Request - Google Search Console - Device",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1100,
        520
      ]
    },
    {
      "id": "99d8bd82-b42f-4251-9ab2-1da57af41bf1",
      "name": "Split Out Devices",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -880,
        520
      ]
    },
    {
      "id": "6774bd8f-e3f7-4bde-a59f-da4caff3b4d2",
      "name": "Format Devices",
      "type": "n8n-nodes-base.set",
      "position": [
        -660,
        520
      ]
    },
    {
      "id": "7222f304-0e37-4583-ad6c-53a0ef021833",
      "name": "HTTP Request - Google Search Console - Country",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1100,
        720
      ]
    },
    {
      "id": "316674b1-8bc4-413f-8011-a70f12578dde",
      "name": "Split Out Country",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -880,
        720
      ]
    },
    {
      "id": "2fc1ba15-52d7-4eb3-92b2-dc68a2d44e27",
      "name": "Format Country",
      "type": "n8n-nodes-base.set",
      "position": [
        -660,
        720
      ]
    },
    {
      "id": "46bfc8e3-f7ee-43bc-a397-35760f2bdee7",
      "name": "HTTP Request - Google Search Console - Query",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1100,
        120
      ]
    },
    {
      "id": "13fca08f-2bc8-41ac-af85-568b68ff2767",
      "name": "Split Out Query",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -880,
        120
      ]
    },
    {
      "id": "0959323a-313d-4da9-85f1-3af769dcfd00",
      "name": "Format Query",
      "type": "n8n-nodes-base.set",
      "position": [
        -660,
        120
      ]
    },
    {
      "id": "b46adb8d-2ecb-42b4-9497-7dac642ec733",
      "name": "Format Page - Previous month",
      "type": "n8n-nodes-base.set",
      "position": [
        -660,
        1320
      ]
    },
    {
      "id": "baf8ea63-023b-4df5-8327-93fcae96a77c",
      "name": "Format Page",
      "type": "n8n-nodes-base.set",
      "position": [
        -660,
        320
      ]
    },
    {
      "id": "ed5e27a0-c217-4fe6-8267-b732eb3dbe09",
      "name": "HTTP Request - Google Search Console - Overview - Previous Month",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1100,
        920
      ]
    },
    {
      "id": "e4c320dd-ab02-48d5-af80-0bc1e918366d",
      "name": "Split Out Query - Previous month",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -880,
        1120
      ]
    },
    {
      "id": "2fcfa4eb-2b42-4d34-a393-2710f9ab634d",
      "name": "Split Out Overview - Previous month",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -880,
        920
      ]
    },
    {
      "id": "ec6c8668-bf12-4aa0-9c3c-9a3c8975f996",
      "name": "Format Overview - Previous month",
      "type": "n8n-nodes-base.set",
      "position": [
        -660,
        920
      ]
    },
    {
      "id": "1eee216f-b8cb-43d6-913a-1fcecf7bd785",
      "name": "Format data",
      "type": "n8n-nodes-base.code",
      "position": [
        -220,
        520
      ]
    },
    {
      "id": "beac970b-49f9-4a23-9a46-5aeb8e062f87",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        -440,
        400
      ]
    },
    {
      "id": "c3190924-430d-4950-a715-fb577d4a0ee6",
      "name": "Generating Insights for SEO Results",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        0,
        520
      ]
    },
    {
      "id": "c39bd736-3d76-4236-b79f-9e1e52f0fd7a",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1800,
        -180
      ],
      "parameters": {
        "width": 580,
        "height": 540,
        "content": "## To connect to Google OAuth2, you'll need to fill these information\n\n### Step 1: Enable & configure your Search Console API credentials\n\n\t**1.\tEnable the API**\n\t•\tIn the [Google Cloud Console](https"
      }
    },
    {
      "id": "ccc3a82c-b906-4332-8739-e46b0e70f7d5",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1600,
        840
      ],
      "parameters": {
        "width": 360,
        "height": 320,
        "content": "**If you're unsure of your siteUrl, use this node to check the list of siteUrls your user have access**"
      }
    },
    {
      "id": "fd06a84f-de27-441d-9de9-e9691ea71d96",
      "name": "HTTP Request - Google Search Console - List SiteUrls I'm Responsable",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1480,
        960
      ]
    }
  ],
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Format data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Pdforge": {
      "main": [
        [
          {
            "node": "Download Binary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Date": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Format Page": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "Format data": {
      "main": [
        [
          {
            "node": "Generating Insights for SEO Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Query": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Configuration": {
      "main": [
        [
          {
            "node": "HTTP Request - Google Search Console - Date",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request - Google Search Console - Page",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request - Google Search Console - Device",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request - Google Search Console - Country",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request - Google Search Console - Query - Previous Month",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request - Google Search Console - Page - Previous month",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request - Google Search Console - Overview",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request - Google Search Console - Overview - Previous Month",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP Request - Google Search Console - Query",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Country": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 5
          }
        ]
      ]
    },
    "Format Devices": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 4
          }
        ]
      ]
    },
    "Split Out Date": {
      "main": [
        [
          {
            "node": "Format Date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download Binary": {
      "main": [
        [
          {
            "node": "Slack - Send Message with File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Overview": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Pages": {
      "main": [
        [
          {
            "node": "Format Page",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Query": {
      "main": [
        [
          {
            "node": "Format Query",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Generating Insights for SEO Results",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Country": {
      "main": [
        [
          {
            "node": "Format Country",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Devices": {
      "main": [
        [
          {
            "node": "Format Devices",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate variables": {
      "main": [
        [
          {
            "node": "Pdforge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Overview": {
      "main": [
        [
          {
            "node": "Format Overview",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Weekly at monday 8am": {
      "main": [
        [
          {
            "node": "Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Page - Previous month": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 8
          }
        ]
      ]
    },
    "Format Query - Previous month": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 7
          }
        ]
      ]
    },
    "Slack - Send Message with File": {
      "main": [
        []
      ]
    },
    "Format Overview - Previous month": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 6
          }
        ]
      ]
    },
    "Split Out Pages - Previous month": {
      "main": [
        [
          {
            "node": "Format Page - Previous month",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Query - Previous month": {
      "main": [
        [
          {
            "node": "Format Query - Previous month",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generating Insights for SEO Results": {
      "main": [
        [
          {
            "node": "Generate variables",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Overview - Previous month": {
      "main": [
        [
          {
            "node": "Format Overview - Previous month",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request - Google Search Console - Date": {
      "main": [
        [
          {
            "node": "Split Out Date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request - Google Search Console - Page": {
      "main": [
        [
          {
            "node": "Split Out Pages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request - Google Search Console - Query": {
      "main": [
        [
          {
            "node": "Split Out Query",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request - Google Search Console - Device": {
      "main": [
        [
          {
            "node": "Split Out Devices",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request - Google Search Console - Country": {
      "main": [
        [
          {
            "node": "Split Out Country",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request - Google Search Console - Overview": {
      "main": [
        [
          {
            "node": "Split Out Overview",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request - Google Search Console - Page - Previous month": {
      "main": [
        [
          {
            "node": "Split Out Pages - Previous month",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request - Google Search Console - Query - Previous Month": {
      "main": [
        [
          {
            "node": "Split Out Query - Previous month",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request - Google Search Console - Overview - Previous Month": {
      "main": [
        [
          {
            "node": "Split Out Overview - Previous month",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}