{
  "name": "Validate & enrich phone numbers in Google Sheets with RapidAPI",
  "nodes": [
    {
      "id": "ae2548f3-672a-4fe2-9d1e-04c98bac8e26",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        0
      ]
    },
    {
      "id": "3ceca160-6e38-42db-8175-a64e5d56cdf4",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        220,
        0
      ]
    },
    {
      "id": "31e4f63b-30a7-4bda-b08a-85306912ca34",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        560,
        0
      ]
    },
    {
      "id": "ff87e1b1-858b-4f99-89b2-9396a151626b",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        840,
        20
      ]
    },
    {
      "id": "e61fda30-c825-4d14-aabf-04ce8bbbf3ca",
      "name": "Google Sheets1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1200,
        180
      ]
    },
    {
      "id": "27898315-d755-48c7-8da0-a560ef937c89",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -840,
        -180
      ],
      "parameters": {
        "width": 560,
        "height": 700,
        "content": "# 📋 Phone Number Validation with Google Sheets \n\n## 🧩 **Use Case**\nAutomatically validate phone numbers from a Google Sheet using RapidAPI and update the results back to the same sheet.\n\n## ✅ **Benefi"
      }
    },
    {
      "id": "773175b3-9bf1-4843-81ea-f809c883f10e",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        -180
      ],
      "parameters": {
        "width": null,
        "height": 340,
        "content": "### 🔘 When clicking ‘Execute workflow’\nManually starts the workflow from the n8n editor.  \nUsed during development or one-time execution."
      }
    },
    {
      "id": "00f5d71c-1a2e-4006-9111-46b6a863475b",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        200,
        -180
      ],
      "parameters": {
        "width": null,
        "height": 340,
        "content": "### 📄 Google Sheets (Read)\nFetches phone numbers from a specified Google Sheet.  \nUses a service account for authentication and reads all rows."
      }
    },
    {
      "id": "bac029d1-2ce5-4499-a1b9-9d9d2112f196",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        480,
        -180
      ],
      "parameters": {
        "width": null,
        "height": 340,
        "content": "### 🔁 Loop Over Items (Split In Batches)\nLoops through each phone number one at a time.  \nEnsures individual API processing per phone number."
      }
    },
    {
      "id": "6fa7f8c8-7c17-4f83-a698-9ecc36201626",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        760,
        -180
      ],
      "parameters": {
        "width": null,
        "height": 340,
        "content": "### 🌐 HTTP Request (RapidAPI)\nSends a POST request to the RapidAPI phone validation endpoint.  \nReceives validation results like `is_valid`, `country`, `location`, and `timezone`."
      }
    },
    {
      "id": "32337c3b-6b95-46ac-b563-3ad05c55892c",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1140,
        -40
      ],
      "parameters": {
        "width": null,
        "height": 420,
        "content": "\n### 📥 Google Sheets1 (Update)\nUpdates the original row in the Google Sheet with the API response.  \nMatches based on the phone number and adds new data to columns."
      }
    }
  ],
  "connections": {
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Google Sheets1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets1": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}