Skip trace people with ScraperCity and save contact details to Google Sheets

4a2faacb-6646-4987-8308-ab5dc01c2cfb

Latency
1444ms
Cost
$0.0000
Tokens
0
Status
success
gemini-2.5-flash-lite

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "a1000000-0000-0000-0000-000000000001",
    "timestamp": 1780870182370
  },
  {
    "data": {
      "initialData": {
        "body": {
          "message": {
            "text": "Trace John Doe in New York, NY"
          },
          "googleSheetId": "1234567890abcdefghijklmnopqrstuvwxyz",
          "googleSheetName": "SkipTraceResults",
          "scraperCityApiKey": "sk_test_abcdef1234567890",
          "googleSheetsCredentials": {
            "scope": "https://www.googleapis.com/auth/spreadsheets",
            "expiry": 1678886400000,
            "tokenType": "Bearer",
            "accessToken": "ya29.a0AR2Q60_example_token_string",
            "refreshToken": "1//0example_refresh_token_string"
          }
        },
        "data": {
          "personToTrace": {
            "city": "New York",
            "state": "NY",
            "lastName": "Doe",
            "firstName": "John"
          }
        },
        "runId": "manual-run-12345",
        "status": "pending"
      }
    },
    "event": "triggered",
    "nodeId": "manualTrigger",
    "timestamp": 1780870182370
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "a1000000-0000-0000-0000-000000000001",
    "timestamp": 1780870182370
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "a1000000-0000-0000-0000-000000000002",
    "timestamp": 1780870182372
  },
  {
    "data": {
      "inputKeys": [
        "runId",
        "status",
        "data",
        "body"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780870182372
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "a1000000-0000-0000-0000-000000000002",
    "timestamp": 1780870182372
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "a1000000-0000-0000-0000-000000000003",
    "timestamp": 1780870182372
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "a1000000-0000-0000-0000-000000000003",
    "timestamp": 1780870182374
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "a1000000-0000-0000-0000-000000000004",
    "timestamp": 1780870182376
  },
  {
    "event": "fetching POST https://app.scrapercity.com/api/v1/scrape/people-finder",
    "nodeId": "http",
    "timestamp": 1780870182376
  },
  {
    "data": {
      "url": "https://app.scrapercity.com/api/v1/scrape/people-finder",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780870182376
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "a1000000-0000-0000-0000-000000000004",
    "timestamp": 1780870182939
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "a1000000-0000-0000-0000-000000000005",
    "timestamp": 1780870182942
  },
  {
    "data": {
      "inputKeys": [
        "statusCode",
        "headers",
        "body"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780870182942
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "a1000000-0000-0000-0000-000000000005",
    "timestamp": 1780870182942
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "a1000000-0000-0000-0000-000000000006",
    "timestamp": 1780870182943
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780870182943
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "a1000000-0000-0000-0000-000000000006",
    "timestamp": 1780870182943
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "a1000000-0000-0000-0000-000000000007",
    "timestamp": 1780870182945
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780870182945
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "a1000000-0000-0000-0000-000000000007",
    "timestamp": 1780870182945
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "a1000000-0000-0000-0000-000000000008",
    "timestamp": 1780870182947
  },
  {
    "event": "fetching GET https://app.scrapercity.com/api/v1/scrape/status/",
    "nodeId": "http",
    "timestamp": 1780870182947
  },
  {
    "data": {
      "url": "https://app.scrapercity.com/api/v1/scrape/status/",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780870182947
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "a1000000-0000-0000-0000-000000000008",
    "timestamp": 1780870183314
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "a1000000-0000-0000-0000-000000000009",
    "timestamp": 1780870183323
  },
  {
    "event": "false branch",
    "nodeId": "if",
    "timestamp": 1780870183323
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "a1000000-0000-0000-0000-000000000009",
    "timestamp": 1780870183323
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "a1000000-0000-0000-0000-000000000010",
    "timestamp": 1780870183327
  },
  {
    "event": "fetching GET https://app.scrapercity.com/api/downloads/",
    "nodeId": "http",
    "timestamp": 1780870183327
  },
  {
    "data": {
      "url": "https://app.scrapercity.com/api/downloads/",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780870183327
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "a1000000-0000-0000-0000-000000000010",
    "timestamp": 1780870183652
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "a1000000-0000-0000-0000-000000000011",
    "timestamp": 1780870183652
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "a1000000-0000-0000-0000-000000000011",
    "timestamp": 1780870183659
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "a1000000-0000-0000-0000-000000000012",
    "timestamp": 1780870183662
  },
  {
    "data": {
      "of": 1,
      "kept": 1
    },
    "event": "removeDuplicates",
    "nodeId": "passthrough",
    "timestamp": 1780870183662
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "a1000000-0000-0000-0000-000000000012",
    "timestamp": 1780870183662
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "a1000000-0000-0000-0000-000000000013",
    "timestamp": 1780870183663
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780870183663
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/Sink:append?valueInputOption=RAW",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780870183663
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780870183814
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 151,
      "operation": "appendOrUpdate"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780870183814
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "a1000000-0000-0000-0000-000000000013",
    "timestamp": 1780870183814
  }
]