{
  "name": "Track daily SEO rankings with DataForSEO and Google Sheets",
  "nodes": [
    {
      "id": "12b77eba-974e-438f-bed3-d282010a51fe",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -120,
        -180
      ]
    },
    {
      "id": "30693f14-7ea0-41e9-8a55-70279c1ff4c9",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        60,
        260
      ]
    },
    {
      "id": "8700a445-a671-4ccf-ab5d-b49581999bc2",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        120,
        -560
      ],
      "parameters": {
        "width": 280,
        "height": 720,
        "content": "## 📄 **Fetch Keyword List (Google Sheets)**\n\nReads your keyword list directly from Google Sheets.  \n👉 Example sheet: [Keyword List](https://docs.google.com/spreadsheets/d/1ShdLc4td6MSQf49l4tDlVohRlFxN"
      }
    },
    {
      "id": "74506eb2-5e79-46a7-b484-00041afe6743",
      "name": "Fetch Keyword List (Google Sheets)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        220,
        -40
      ]
    },
    {
      "id": "bed29055-a0f1-4739-b65b-6d8b612e39f0",
      "name": "Fetch SERP Data (DataForSEO API)",
      "type": "n8n-nodes-dataforseo.dataForSeo",
      "position": [
        660,
        0
      ]
    },
    {
      "id": "73c65e58-ed21-4c88-8abf-7ec37b61c38b",
      "name": "Extract Query, Rank & Domain",
      "type": "n8n-nodes-base.code",
      "position": [
        280,
        260
      ]
    },
    {
      "id": "3d158ce9-c0a5-47bf-92b8-b41c4bb71b0a",
      "name": "Add Timestamp & Prepare Output",
      "type": "n8n-nodes-base.set",
      "position": [
        500,
        260
      ]
    },
    {
      "id": "d21074e7-2552-42c7-816b-79da4e9960fa",
      "name": "Append Results to Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        740,
        560
      ]
    },
    {
      "id": "f14d433f-4a51-4bf7-95fa-a616a788e4d5",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -220,
        -400
      ],
      "parameters": {
        "width": 280,
        "height": 400,
        "content": "## 🕒 **Daily Schedule Trigger**\n\nStarts the workflow automatically `every day`.\n  \n⚠️ Adjust the time or interval in node settings.  "
      }
    },
    {
      "id": "5aeafcc6-98e9-4cd8-8c66-184ebb882cc0",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        500,
        -560
      ],
      "parameters": {
        "width": 440,
        "height": 720,
        "content": "## 🔍 **Fetch SERP Data (DataForSEO API)**\n\nUses the DataForSEO API to retrieve Google Search results for each keyword.  \nPulls details like `rank`, `domain`, `title`, and `url` for the top results.\n\n⚙"
      }
    },
    {
      "id": "61d504d9-512b-4aa9-acfc-6b257c6e5fbd",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        40,
        440
      ],
      "parameters": {
        "width": 900,
        "height": 300,
        "content": "## 📊 **Append Results to Google Sheet**\n\nWrites the processed data (`query`, `rank`, `domain`, `date`) into your Google Sheet.  \n👉 Output Sheet: [Daily Rank Tracker](https://docs.google.com/spreadshee"
      }
    },
    {
      "id": "ecbc3949-16b9-4291-9e98-8c7e6c18d33d",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        980,
        280
      ],
      "parameters": {
        "width": 780,
        "height": 460,
        "content": "## 📋 **Sample Output (Google Sheet)**\n\nExample of how results are saved daily:\n\n| query | rank | domain | date |\n|--------|-------|------------------------|----------------|\n| cloud host | 1 | cloudho"
      }
    }
  ],
  "connections": {
    "Split Out": {
      "main": [
        [
          {
            "node": "Extract Query, Rank & Domain",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Fetch Keyword List (Google Sheets)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Query, Rank & Domain": {
      "main": [
        [
          {
            "node": "Add Timestamp & Prepare Output",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Timestamp & Prepare Output": {
      "main": [
        [
          {
            "node": "Append Results to Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch SERP Data (DataForSEO API)": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Keyword List (Google Sheets)": {
      "main": [
        [
          {
            "node": "Fetch SERP Data (DataForSEO API)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}