Analyze sales deal outcomes with Azure OpenAI and Google Sheets reporting
e3b230fb-b35b-47bb-b568-2ea08d65d715
Latency
17286ms
Cost
$0.0000
Tokens
0
Status
partialgemini-2.5-flash-lite
Workflow Graph
Trace
[
{
"data": {
"nodeType": "manualTrigger"
},
"event": "node_start",
"nodeId": "073e3c65-5662-4c40-8f7c-abb1b5d54030",
"timestamp": 1780869023709
},
{
"data": {
"initialData": {
"deals": [
{
"notes": "Client expressed strong interest in advanced analytics capabilities. Discussed integration with existing data infrastructure. Follow-up scheduled for next week.",
"dealId": "D1001",
"status": "Closed Won",
"dealName": "Project Phoenix - Phase 2",
"closeDate": "2023-10-26T10:00:00Z",
"dealValue": 75000.5,
"customerName": "Innovate Solutions Inc.",
"salesRepEmail": "alice.smith@example.com"
},
{
"notes": "Competitor offered a significantly lower price. Client cited budget constraints as the primary reason for not proceeding. Will keep them in mind for future opportunities.",
"dealId": "D1002",
"status": "Closed Lost",
"dealName": "Cloud Migration Strategy",
"closeDate": "2023-10-25T14:30:00Z",
"dealValue": 120000,
"customerName": "Global Enterprises Ltd.",
"salesRepEmail": "bob.johnson@example.com"
},
{
"notes": "Successful demo of the interactive dashboard. Client was impressed with the real-time data updates and user-friendly interface. Contract is being finalized.",
"dealId": "D1003",
"status": "Closed Won",
"dealName": "Data Visualization Dashboard",
"closeDate": "2023-10-26T09:15:00Z",
"dealValue": 30000.75,
"customerName": "TechForward Corp.",
"salesRepEmail": "alice.smith@example.com"
}
],
"reportDateRange": {
"endDate": "2023-10-31T23:59:59Z",
"startDate": "2023-10-01T00:00:00Z"
}
}
},
"event": "triggered",
"nodeId": "manualTrigger",
"timestamp": 1780869023709
},
{
"data": {
"status": "ok",
"nodeType": "manualTrigger"
},
"event": "node_end",
"nodeId": "073e3c65-5662-4c40-8f7c-abb1b5d54030",
"timestamp": 1780869023709
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "3914f8f7-955b-4464-9548-89f6b79f67bb",
"timestamp": 1780869023711
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1780869023711
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1780869023711
},
{
"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": "3914f8f7-955b-4464-9548-89f6b79f67bb",
"timestamp": 1780869027781
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "5529bf2c-a211-43bb-8a1a-1c2027fb7daf",
"timestamp": 1780869027783
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1780869027783
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1780869027783
},
{
"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": "5529bf2c-a211-43bb-8a1a-1c2027fb7daf",
"timestamp": 1780869031886
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "38f26876-4138-49fc-8f79-93ac5ad7876d",
"timestamp": 1780869031888
},
{
"data": {
"service": "googleSheets",
"resolved": true
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780869031888
},
{
"data": {
"url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1780869031888
},
{
"data": {
"status": 200
},
"event": "sheets.read",
"nodeId": "integration",
"timestamp": 1780869032027
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "googleSheets",
"latencyMs": 139,
"operation": "read"
},
"event": "integration_call",
"nodeId": "integration",
"timestamp": 1780869032027
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "38f26876-4138-49fc-8f79-93ac5ad7876d",
"timestamp": 1780869032027
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "e47ac8b4-ccb8-49df-82f0-05fdbff7828a",
"timestamp": 1780869032027
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "no-source",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1780869032027
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "e47ac8b4-ccb8-49df-82f0-05fdbff7828a",
"timestamp": 1780869032027
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "9cb26417-5674-44cb-ab6f-28c44b168094",
"timestamp": 1780869032027
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "no-source",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1780869032027
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "9cb26417-5674-44cb-ab6f-28c44b168094",
"timestamp": 1780869032027
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "60a74709-38da-48d6-9227-eeed1734c0f6",
"timestamp": 1780869032029
},
{
"data": {
"service": "googleSheets",
"resolved": true
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780869032029
},
{
"data": {
"url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1780869032029
},
{
"data": {
"status": 200
},
"event": "sheets.read",
"nodeId": "integration",
"timestamp": 1780869032173
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "googleSheets",
"latencyMs": 144,
"operation": "read"
},
"event": "integration_call",
"nodeId": "integration",
"timestamp": 1780869032173
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "60a74709-38da-48d6-9227-eeed1734c0f6",
"timestamp": 1780869032173
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "3f508420-a1a3-4a46-b07b-a6bd0664f789",
"timestamp": 1780869032177
},
{
"data": {
"service": "googleSheets",
"resolved": true
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780869032177
},
{
"data": {
"url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1780869032177
},
{
"data": {
"status": 200
},
"event": "sheets.read",
"nodeId": "integration",
"timestamp": 1780869032336
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "googleSheets",
"latencyMs": 159,
"operation": "read"
},
"event": "integration_call",
"nodeId": "integration",
"timestamp": 1780869032336
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "3f508420-a1a3-4a46-b07b-a6bd0664f789",
"timestamp": 1780869032336
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "5bb2b739-60d9-4043-9771-979ad1c593da",
"timestamp": 1780869032336
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "no-source",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1780869032336
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "5bb2b739-60d9-4043-9771-979ad1c593da",
"timestamp": 1780869032336
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "a06f354f-3cdc-47bf-9ef3-c25b76135778",
"timestamp": 1780869032339
},
{
"data": {
"service": "smtp",
"resolved": false
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780869032339
},
{
"data": {
"mode": "write",
"status": "ok",
"service": "smtp",
"latencyMs": 500,
"operation": "read",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1780869032840
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "a06f354f-3cdc-47bf-9ef3-c25b76135778",
"timestamp": 1780869032840
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "dd009347-1c1e-4d77-880f-98a1268feab6",
"timestamp": 1780869032844
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1780869032844
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1780869032844
},
{
"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": "dd009347-1c1e-4d77-880f-98a1268feab6",
"timestamp": 1780869036894
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "c59c230c-fb7d-47ea-aa19-210c5b65dccd",
"timestamp": 1780869036896
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1780869036896
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "c59c230c-fb7d-47ea-aa19-210c5b65dccd",
"timestamp": 1780869036896
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "62ebbddb-b10b-4af2-ae56-4e642e5cd610",
"timestamp": 1780869036897
},
{
"data": {
"inputKeys": [],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1780869036897
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "62ebbddb-b10b-4af2-ae56-4e642e5cd610",
"timestamp": 1780869036897
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "d114ef1f-19de-49ce-92c6-df5e75c187c2",
"timestamp": 1780869036898
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1780869036898
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1780869036898
},
{
"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": "d114ef1f-19de-49ce-92c6-df5e75c187c2",
"timestamp": 1780869040995
}
]