Generate sales reports from Google Sheets with Azure OpenAI and Telegram

[
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "2d4ef4d1-c628-4576-9a56-d169e424a0cf",
    "timestamp": 1780868922358
  },
  {
    "data": {
      "initialData": {
        "sheet_name": "Sales Data",
        "report_type": "monthly_summary",
        "openai_model": "gpt-3.5-turbo",
        "google_sheet_id": "1a2b3c4d5e6f7g8h9i0j1k2l3m4n5o6p7q8r9s0t",
        "telegram_chat_id": "1234567890",
        "report_date_range": {
          "end_date": "2023-10-31",
          "start_date": "2023-10-01"
        }
      }
    },
    "event": "triggered",
    "nodeId": "manualTrigger",
    "timestamp": 1780868922358
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "2d4ef4d1-c628-4576-9a56-d169e424a0cf",
    "timestamp": 1780868922358
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "6fd47a46-50a7-4f48-a5d2-12bd5c80d21d",
    "timestamp": 1780868922361
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780868922361
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780868922361
  },
  {
    "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": "6fd47a46-50a7-4f48-a5d2-12bd5c80d21d",
    "timestamp": 1780868926488
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "d0bf8e09-9a35-4af3-ae16-531b1ff12133",
    "timestamp": 1780868926492
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780868926492
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780868926492
  },
  {
    "data": {
      "status": 200
    },
    "event": "sheets.read",
    "nodeId": "integration",
    "timestamp": 1780868926647
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 155,
      "operation": "read"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780868926647
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "d0bf8e09-9a35-4af3-ae16-531b1ff12133",
    "timestamp": 1780868926647
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "0c14ff2d-d8bc-4f33-a7e0-1e6ba33b030e",
    "timestamp": 1780868926650
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780868926650
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780868926650
  },
  {
    "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": "0c14ff2d-d8bc-4f33-a7e0-1e6ba33b030e",
    "timestamp": 1780868930869
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "19ac86d6-958a-4000-b464-b3e23b81e296",
    "timestamp": 1780868930879
  },
  {
    "data": {
      "service": "telegram",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780868930879
  },
  {
    "data": {
      "url": "https://api.telegram.org/bot8601839237:AAEoFA4ys16Txlcu68Orq7B6q_QPBOVBDvs/getUpdates?limit=5",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780868930879
  },
  {
    "data": {
      "mode": "read",
      "error": "telegram.getUpdates failed: HTTP 409",
      "status": "error",
      "service": "telegram",
      "operation": "read"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780868931959
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "19ac86d6-958a-4000-b464-b3e23b81e296",
    "timestamp": 1780868931959
  }
]