Scrape and qualify HR job leads with Apify, Google Sheets and OpenAI GPT-4o-mini
d0ec4e7c-39c4-41db-9da4-5a36155178ae
Latency
5597ms
Cost
$0.0000
Tokens
0
Status
partialgemini-2.5-flash-lite
Workflow Graph
Trace
[
{
"data": {
"nodeType": "trigger"
},
"event": "node_start",
"nodeId": "ebe65da7-02d2-4481-a2f5-639e0c2b6697",
"timestamp": 1780869415536
},
{
"data": {
"kind": "n8n-nodes-base.formTrigger"
},
"event": "seeded",
"nodeId": "trigger",
"timestamp": 1780869415536
},
{
"data": {
"status": "ok",
"nodeType": "trigger"
},
"event": "node_end",
"nodeId": "ebe65da7-02d2-4481-a2f5-639e0c2b6697",
"timestamp": 1780869415536
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "95f70dc7-5ead-4a29-8408-a5bf2afd0f2d",
"timestamp": 1780869415536
},
{
"event": "execution error (simulated): $input.first(...).json.Job Roles.split is not a function",
"nodeId": "code",
"timestamp": 1780869415537
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "exec-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1780869415537
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "95f70dc7-5ead-4a29-8408-a5bf2afd0f2d",
"timestamp": 1780869415538
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "1bc35fcc-51b9-42e9-a1b4-c05fc6b8918d",
"timestamp": 1780869415539
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1780869415539
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "1bc35fcc-51b9-42e9-a1b4-c05fc6b8918d",
"timestamp": 1780869415539
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "38ba3296-d66e-4526-8277-2b9a2623b16a",
"timestamp": 1780869415539
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "38ba3296-d66e-4526-8277-2b9a2623b16a",
"timestamp": 1780869415541
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "d26e5c4e-d7d0-4072-8a14-98dcd5355f1a",
"timestamp": 1780869415542
},
{
"data": {
"service": "googleSheets",
"resolved": true
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780869415542
},
{
"data": {
"url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1780869415542
},
{
"data": {
"status": 200
},
"event": "sheets.read",
"nodeId": "integration",
"timestamp": 1780869415688
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "googleSheets",
"latencyMs": 146,
"operation": "read"
},
"event": "integration_call",
"nodeId": "integration",
"timestamp": 1780869415688
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "d26e5c4e-d7d0-4072-8a14-98dcd5355f1a",
"timestamp": 1780869415688
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "4fed2722-26fe-49b3-91aa-1c58f23b1a64",
"timestamp": 1780869415688
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "4fed2722-26fe-49b3-91aa-1c58f23b1a64",
"timestamp": 1780869415693
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "4ab93d56-5387-45dd-936a-c0480a265ca1",
"timestamp": 1780869415697
},
{
"data": {
"service": "googleSheets",
"resolved": true
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780869415697
},
{
"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": 1780869415697
},
{
"data": {
"tab": "Sink",
"status": 200
},
"event": "sheets.write",
"nodeId": "integration",
"timestamp": 1780869415840
},
{
"data": {
"mode": "write",
"status": "ok",
"service": "googleSheets",
"latencyMs": 143,
"operation": "append"
},
"event": "integration_call",
"nodeId": "integration",
"timestamp": 1780869415840
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "4ab93d56-5387-45dd-936a-c0480a265ca1",
"timestamp": 1780869415840
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "9891f9b8-220e-4a52-bed3-b59d2fad45aa",
"timestamp": 1780869415844
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1780869415845
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "9891f9b8-220e-4a52-bed3-b59d2fad45aa",
"timestamp": 1780869415845
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "7f1acfec-3935-4e47-8dc3-8fa014c6571f",
"timestamp": 1780869415848
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1780869415848
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1780869415848
},
{
"data": {
"error": "Google Gemini API error (500): {\n \"error\": {\n \"code\": 500,\n \"message\": \"An internal error has occurred. Please retry or report in https://developers.generativeai.google/guide/troubleshooting\",\n \"status\": \"INTERNAL\"\n }\n}\n",
"status": "error",
"degraded": true,
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "7f1acfec-3935-4e47-8dc3-8fa014c6571f",
"timestamp": 1780869419953
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "b942d8f6-178f-49a7-bfae-37fa69c4520e",
"timestamp": 1780869419953
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "b942d8f6-178f-49a7-bfae-37fa69c4520e",
"timestamp": 1780869419963
},
{
"data": {
"nodeType": "if"
},
"event": "node_start",
"nodeId": "b2640e0a-e2ef-4da5-b5dd-e7558214ad22",
"timestamp": 1780869419966
},
{
"event": "false branch",
"nodeId": "if",
"timestamp": 1780869419966
},
{
"data": {
"status": "ok",
"nodeType": "if"
},
"event": "node_end",
"nodeId": "b2640e0a-e2ef-4da5-b5dd-e7558214ad22",
"timestamp": 1780869419966
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "6906f1c0-387a-46cf-9033-1f740a6b456d",
"timestamp": 1780869419968
},
{
"data": {
"inputKeys": [
"ok",
"status",
"company_name",
"company_source",
"lead_score",
"decision",
"reason",
"industry",
"country"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1780869419968
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "6906f1c0-387a-46cf-9033-1f740a6b456d",
"timestamp": 1780869419968
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "7e94057c-8d2d-49bc-9088-a599c4d899ae",
"timestamp": 1780869419970
},
{
"data": {
"service": "googleSheets",
"resolved": true
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780869419970
},
{
"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": 1780869419970
},
{
"data": {
"tab": "Sink",
"status": 200
},
"event": "sheets.write",
"nodeId": "integration",
"timestamp": 1780869420202
},
{
"data": {
"mode": "write",
"status": "ok",
"service": "googleSheets",
"latencyMs": 232,
"operation": "appendOrUpdate"
},
"event": "integration_call",
"nodeId": "integration",
"timestamp": 1780869420202
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "7e94057c-8d2d-49bc-9088-a599c4d899ae",
"timestamp": 1780869420202
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "7c9f0806-b406-4fbc-96d8-3464a5fc2f45",
"timestamp": 1780869420207
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1780869420207
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "7c9f0806-b406-4fbc-96d8-3464a5fc2f45",
"timestamp": 1780869420207
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "485a21f5-1f73-4f82-ac54-f051f0f30506",
"timestamp": 1780869420210
},
{
"event": "fetching POST https://api.apify.com/v2/acts/agentx~all-jobs-scraper/run-sync-get-dataset-items",
"nodeId": "http",
"timestamp": 1780869420210
},
{
"data": {
"url": "https://api.apify.com/v2/acts/agentx~all-jobs-scraper/run-sync-get-dataset-items",
"method": "POST"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1780869420210
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "485a21f5-1f73-4f82-ac54-f051f0f30506",
"timestamp": 1780869420556
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "66197d6c-a845-4379-b589-41a449b52887",
"timestamp": 1780869420562
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "firecrawl",
"latencyMs": 250,
"operation": "scrape",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1780869420813
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "66197d6c-a845-4379-b589-41a449b52887",
"timestamp": 1780869420813
},
{
"data": {
"nodeType": "if"
},
"event": "node_start",
"nodeId": "d0471948-3460-4358-9497-23e59d3e8ecb",
"timestamp": 1780869420819
},
{
"event": "false branch",
"nodeId": "if",
"timestamp": 1780869420819
},
{
"data": {
"status": "ok",
"nodeType": "if"
},
"event": "node_end",
"nodeId": "d0471948-3460-4358-9497-23e59d3e8ecb",
"timestamp": 1780869420819
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "0890e82f-036e-4a0e-82a3-11c78793dd6b",
"timestamp": 1780869420821
},
{
"data": {
"service": "googleSheets",
"resolved": true
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780869420821
},
{
"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": 1780869420821
},
{
"data": {
"tab": "Sink",
"status": 200
},
"event": "sheets.write",
"nodeId": "integration",
"timestamp": 1780869420977
},
{
"data": {
"mode": "write",
"status": "ok",
"service": "googleSheets",
"latencyMs": 156,
"operation": "appendOrUpdate"
},
"event": "integration_call",
"nodeId": "integration",
"timestamp": 1780869420977
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "0890e82f-036e-4a0e-82a3-11c78793dd6b",
"timestamp": 1780869420977
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "3fec290e-1367-4ce5-b0cd-7ca29eb2f2dc",
"timestamp": 1780869420984
},
{
"data": {
"service": "googleSheets",
"resolved": true
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780869420984
},
{
"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": 1780869420984
},
{
"data": {
"tab": "Sink",
"status": 200
},
"event": "sheets.write",
"nodeId": "integration",
"timestamp": 1780869421133
},
{
"data": {
"mode": "write",
"status": "ok",
"service": "googleSheets",
"latencyMs": 149,
"operation": "appendOrUpdate"
},
"event": "integration_call",
"nodeId": "integration",
"timestamp": 1780869421133
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "3fec290e-1367-4ce5-b0cd-7ca29eb2f2dc",
"timestamp": 1780869421133
}
]