{
  "name": "Skip trace people with ScraperCity and save contact details to Google Sheets",
  "nodes": [
    {
      "id": "a1000000-0000-0000-0000-000000000001",
      "name": "When clicking 'Execute workflow'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -2000,
        400
      ]
    },
    {
      "id": "a1000000-0000-0000-0000-000000000002",
      "name": "Configure Search Inputs",
      "type": "n8n-nodes-base.set",
      "position": [
        -1750,
        400
      ]
    },
    {
      "id": "a1000000-0000-0000-0000-000000000003",
      "name": "Build Request Body",
      "type": "n8n-nodes-base.code",
      "position": [
        -1500,
        400
      ]
    },
    {
      "id": "a1000000-0000-0000-0000-000000000004",
      "name": "Submit Skip Trace Job",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1250,
        400
      ]
    },
    {
      "id": "a1000000-0000-0000-0000-000000000005",
      "name": "Store Run ID",
      "type": "n8n-nodes-base.set",
      "position": [
        -1000,
        400
      ]
    },
    {
      "id": "a1000000-0000-0000-0000-000000000006",
      "name": "Polling Loop",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -750,
        400
      ]
    },
    {
      "id": "a1000000-0000-0000-0000-000000000007",
      "name": "Wait 60 Seconds",
      "type": "n8n-nodes-base.wait",
      "position": [
        -500,
        400
      ]
    },
    {
      "id": "a1000000-0000-0000-0000-000000000008",
      "name": "Check Scrape Status",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -250,
        400
      ]
    },
    {
      "id": "a1000000-0000-0000-0000-000000000009",
      "name": "Is Scrape Complete?",
      "type": "n8n-nodes-base.if",
      "position": [
        0,
        400
      ]
    },
    {
      "id": "a1000000-0000-0000-0000-000000000010",
      "name": "Download Results CSV",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        250,
        400
      ]
    },
    {
      "id": "a1000000-0000-0000-0000-000000000011",
      "name": "Parse and Format CSV Results",
      "type": "n8n-nodes-base.code",
      "position": [
        500,
        400
      ]
    },
    {
      "id": "a1000000-0000-0000-0000-000000000012",
      "name": "Remove Duplicate Contacts",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        750,
        400
      ]
    },
    {
      "id": "a1000000-0000-0000-0000-000000000013",
      "name": "Write Results to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1000,
        400
      ]
    },
    {
      "id": "a1000000-0000-0000-0000-000000000020",
      "name": "Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2600,
        100
      ],
      "parameters": {
        "width": 450,
        "height": 580,
        "content": "## How it works\n1. You enter names, phone numbers, or emails in the Configure Search Inputs node.\n2. The workflow submits a skip trace job to the ScraperCity People Finder API.\n3. It polls for complet"
      }
    },
    {
      "id": "a1000000-0000-0000-0000-000000000021",
      "name": "Section - Configuration",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2040,
        -160
      ],
      "parameters": {
        "width": 980,
        "height": 330,
        "content": "## Configuration\nEnter comma-separated names, phones, or emails in **Configure Search Inputs**. **Build Request Body** converts them into arrays for the API."
      }
    },
    {
      "id": "a1000000-0000-0000-0000-000000000022",
      "name": "Section - Submit Job",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1040,
        -160
      ],
      "parameters": {
        "width": 980,
        "height": 330,
        "content": "## Submit Job\n**Submit Skip Trace Job** POSTs to the ScraperCity People Finder endpoint. **Store Run ID** saves the returned job ID for later polling."
      }
    },
    {
      "id": "a1000000-0000-0000-0000-000000000023",
      "name": "Section - Async Polling Loop",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -40,
        -160
      ],
      "parameters": {
        "width": 980,
        "height": 330,
        "content": "## Async Polling Loop\n**Wait 60 Seconds** pauses between checks. **Check Scrape Status** hits the status endpoint. **Is Scrape Complete?** routes to download on success or loops back."
      }
    },
    {
      "id": "a1000000-0000-0000-0000-000000000024",
      "name": "Section - Download and Output",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        -160
      ],
      "parameters": {
        "width": 300,
        "height": 330,
        "content": "## Download and Output\n**Download Results CSV** fetches the file. **Parse and Format CSV Results** splits into records. **Remove Duplicate Contacts** dedupes. **Write Results to Google Sheets** append"
      }
    }
  ],
  "connections": {
    "Polling Loop": {
      "main": [
        [
          {
            "node": "Wait 60 Seconds",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "Store Run ID": {
      "main": [
        [
          {
            "node": "Polling Loop",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 60 Seconds": {
      "main": [
        [
          {
            "node": "Check Scrape Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Request Body": {
      "main": [
        [
          {
            "node": "Submit Skip Trace Job",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Scrape Status": {
      "main": [
        [
          {
            "node": "Is Scrape Complete?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Is Scrape Complete?": {
      "main": [
        [
          {
            "node": "Download Results CSV",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Polling Loop",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download Results CSV": {
      "main": [
        [
          {
            "node": "Parse and Format CSV Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Submit Skip Trace Job": {
      "main": [
        [
          {
            "node": "Store Run ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Configure Search Inputs": {
      "main": [
        [
          {
            "node": "Build Request Body",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Remove Duplicate Contacts": {
      "main": [
        [
          {
            "node": "Write Results to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse and Format CSV Results": {
      "main": [
        [
          {
            "node": "Remove Duplicate Contacts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking 'Execute workflow'": {
      "main": [
        [
          {
            "node": "Configure Search Inputs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}