Auto-Update job application status from Gmail to Google Sheets

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "c58a7770-4282-47f9-8b19-d29bc3ca00a6",
    "timestamp": 1780869422655
  },
  {
    "data": {
      "kind": "n8n-nodes-base.gmailTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780869422655
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "c58a7770-4282-47f9-8b19-d29bc3ca00a6",
    "timestamp": 1780869422655
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "6d9a2165-c9a9-49b1-baec-2668cd5a2c3e",
    "timestamp": 1780869422659
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/openai/gpt-oss-120b:free",
    "nodeId": "llm",
    "timestamp": 1780869422659
  },
  {
    "data": {
      "model": "openai/gpt-oss-120b:free",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780869422659
  },
  {
    "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": "6d9a2165-c9a9-49b1-baec-2668cd5a2c3e",
    "timestamp": 1780869426777
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "ff7d3ed2-0e23-40aa-ba5f-0771ec513278",
    "timestamp": 1780869426785
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780869426785
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780869426785
  },
  {
    "data": {
      "model": "gemini-2.5-flash-lite",
      "costUsd": 0.0000435,
      "provider": "openai",
      "latencyMs": 415,
      "promptTokens": 291,
      "completionTokens": 36
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1780869427202
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "ff7d3ed2-0e23-40aa-ba5f-0771ec513278",
    "timestamp": 1780869427202
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "03f69282-e1bd-4334-90ee-58389076b218",
    "timestamp": 1780869427207
  },
  {
    "data": {
      "inputKeys": [
        "text",
        "model",
        "usage"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780869427207
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "03f69282-e1bd-4334-90ee-58389076b218",
    "timestamp": 1780869427207
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "a2189395-dd35-41ff-9de0-2ee2c113a211",
    "timestamp": 1780869427209
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1780869427209
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "a2189395-dd35-41ff-9de0-2ee2c113a211",
    "timestamp": 1780869427209
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "209f278f-a893-4af4-8c5f-2064e1ed79af",
    "timestamp": 1780869427211
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780869427211
  },
  {
    "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": 1780869427211
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780869427449
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 238,
      "operation": "appendOrUpdate"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780869427449
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "209f278f-a893-4af4-8c5f-2064e1ed79af",
    "timestamp": 1780869427449
  }
]