{
  "name": "Automated SEO performance collection from Google Search Console to NocoDB",
  "nodes": [
    {
      "id": "29f876d8-6376-4c30-b090-d98e0b19efb7",
      "name": "NocoDB1",
      "type": "n8n-nodes-base.nocoDb",
      "position": [
        1060,
        160
      ]
    },
    {
      "id": "adbf93b4-0174-41b0-a4b3-b38407df2d1e",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": 260.6598393933048,
        "height": 313.71656632131885,
        "content": "📌 Node: Schedule Trigger\nRuns the automation on a fixed schedule (e.g., daily). Used to trigger SEO data collection from Google Search Console automatically."
      }
    },
    {
      "id": "f4c79269-74dd-4918-b7a8-bb5b22b8af57",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        0
      ],
      "parameters": {
        "width": 260.6598393933048,
        "height": 313.71656632131885,
        "content": "📌  Node: HTTP Request\nMakes a POST request to GSC API (Search Analytics endpoint). Authenticated with OAuth2. Retrieves performance data like clicks, impressions, CTR."
      }
    },
    {
      "id": "536e2048-dcf5-4309-90d6-62de2a26cc8f",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        0
      ],
      "parameters": {
        "width": 260.6598393933048,
        "height": 313.71656632131885,
        "content": "📌 Node: Code\nParses and restructures the raw GSC API response. Extracts fields like query, page, date, device, clicks, CTR, and position for database insertion.\n"
      }
    },
    {
      "id": "9f1cda9a-97c5-499d-836a-a7b69a4af6a5",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        980,
        0
      ],
      "parameters": {
        "width": 260.6598393933048,
        "height": 313.71656632131885,
        "content": "\n📌 Node: NocoDB1 (create: row)\nPushes parsed SEO data into NocoDB (`gsc_data` table). This builds a structured, queryable database of daily SEO performance.\n"
      }
    },
    {
      "id": "b56613ed-ffb0-4082-90ce-b748ee58abfc",
      "name": "Schedule Trigger1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        80,
        160
      ]
    },
    {
      "id": "9ebb1a98-4913-496f-9f97-b57886d01bc7",
      "name": "HTTP Request1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        400,
        160
      ]
    },
    {
      "id": "e65f93e1-715d-451a-b205-7c1c2ff1f6ca",
      "name": "Code1",
      "type": "n8n-nodes-base.code",
      "position": [
        720,
        160
      ]
    }
  ],
  "connections": {
    "Code1": {
      "main": [
        [
          {
            "node": "NocoDB1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request1": {
      "main": [
        [
          {
            "node": "Code1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger1": {
      "main": [
        [
          {
            "node": "HTTP Request1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}