Profile investors and send AI investment reports with Google Sheets, Alpha Vantage, Groq, Gmail and Slack
1f87a2ce-524b-4c02-bb99-517e9af6999a
Latency
6529ms
Cost
$0.0001
Tokens
425
Status
partialgemini-2.5-flash-lite
Workflow Graph
Trace
[
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "ebd47c34-04e6-486c-b5e5-5f50a70d0f2c",
"timestamp": 1780870083069
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/openai/gpt-oss-120b",
"nodeId": "llm",
"timestamp": 1780870083069
},
{
"data": {
"model": "openai/gpt-oss-120b",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1780870083069
},
{
"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": "ebd47c34-04e6-486c-b5e5-5f50a70d0f2c",
"timestamp": 1780870087206
},
{
"data": {
"nodeType": "manualTrigger"
},
"event": "node_start",
"nodeId": "a7475621-0e93-43d4-b43e-99d7d0fdea6b",
"timestamp": 1780870087209
},
{
"data": {
"initialData": {
"Age": 35,
"Name": "Alice Wonderland",
"Email": "alice.wonderland@example.com",
"Income": 120000,
"output": {
"Strategy": "Long-term investment in a mix of equities and bonds.",
"Risk Category": "Balanced",
"Market Insight": "The current market shows a bullish trend with moderate volatility, suggesting a favorable environment for growth-oriented investments. However, it's important to maintain diversification to mitigate potential downturns.",
"Profile Summary": "Alice is a 35-year-old professional with a moderate risk appetite and a stable income. She is looking for a balanced investment approach to achieve long-term growth.",
"Investor Profile": {
"Age": 35,
"Name": "Alice Wonderland",
"Email": "alice.wonderland@example.com",
"Income": 120000,
"Risk Appetite": "Medium"
},
"Suggested Approach": "Diversified growth with a focus on stable sectors.",
"Portfolio Allocation": {
"Debt": 0.3,
"Gold": 0.1,
"Equity": 0.6
}
},
"Timestamp": "2023-10-27T10:30:00Z",
"volatility": "Moderate",
"marketTrend": "Bullish",
"Global Quote": {
"eps": 6.1,
"low": 169.8,
"high": 172.5,
"open": 170,
"price": 171.9,
"change": 1.4,
"symbol": "AAPL",
"volume": 50000000,
"peRatio": 28.18,
"latestDay": "2023-10-26",
"marketCap": 2700000000000,
"changePercent": 0.82,
"dividendYield": 0.005,
"previousClose": 170.5
},
"Risk Appetite": "Medium",
"marketChangePercent": 1.5
}
},
"event": "triggered",
"nodeId": "manualTrigger",
"timestamp": 1780870087209
},
{
"data": {
"status": "ok",
"nodeType": "manualTrigger"
},
"event": "node_end",
"nodeId": "a7475621-0e93-43d4-b43e-99d7d0fdea6b",
"timestamp": 1780870087209
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "1d9a9359-14e0-4a86-b353-2b87d2f03f35",
"timestamp": 1780870087211
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1780870087211
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "1d9a9359-14e0-4a86-b353-2b87d2f03f35",
"timestamp": 1780870087211
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "0515fb4b-4a5b-4e2c-a3e6-28fa49e937a3",
"timestamp": 1780870087213
},
{
"data": {
"service": "googleSheets",
"resolved": true
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780870087213
},
{
"data": {
"url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1780870087213
},
{
"data": {
"status": 200
},
"event": "sheets.read",
"nodeId": "integration",
"timestamp": 1780870087664
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "googleSheets",
"latencyMs": 451,
"operation": "read"
},
"event": "integration_call",
"nodeId": "integration",
"timestamp": 1780870087664
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "0515fb4b-4a5b-4e2c-a3e6-28fa49e937a3",
"timestamp": 1780870087664
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "78ea63a4-89c2-4a4d-b6a7-8e33d634d1eb",
"timestamp": 1780870087666
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1780870087666
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "78ea63a4-89c2-4a4d-b6a7-8e33d634d1eb",
"timestamp": 1780870087666
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "ebea27b5-bf23-40d4-938c-2e359cfa4f07",
"timestamp": 1780870087668
},
{
"event": "fetching GET https://www.alphavantage.co/query",
"nodeId": "http",
"timestamp": 1780870087668
},
{
"data": {
"url": "https://www.alphavantage.co/query",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1780870087668
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "ebea27b5-bf23-40d4-938c-2e359cfa4f07",
"timestamp": 1780870087884
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "8af6b16d-e2ae-4306-bd97-2411d6c50888",
"timestamp": 1780870087884
},
{
"event": "execution error (simulated): Cannot read properties of undefined (reading '05. price')",
"nodeId": "code",
"timestamp": 1780870087887
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "exec-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1780870087887
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "8af6b16d-e2ae-4306-bd97-2411d6c50888",
"timestamp": 1780870087888
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "7cbcfdd6-82c8-4ef7-8d36-de872910f894",
"timestamp": 1780870087888
},
{
"event": "execution error (simulated): Cannot read properties of undefined (reading '05. price')",
"nodeId": "code",
"timestamp": 1780870087890
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "exec-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1780870087890
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "7cbcfdd6-82c8-4ef7-8d36-de872910f894",
"timestamp": 1780870087890
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "7b366d7d-d2c3-42af-9b81-a4cc9f047410",
"timestamp": 1780870087892
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1780870087892
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1780870087892
},
{
"data": {
"model": "gemini-2.5-flash-lite",
"costUsd": 0.0001094,
"provider": "openai",
"latencyMs": 1138,
"promptTokens": 202,
"completionTokens": 223
},
"event": "llm_result",
"nodeId": "_context",
"timestamp": 1780870089030
},
{
"data": {
"status": "ok",
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "7b366d7d-d2c3-42af-9b81-a4cc9f047410",
"timestamp": 1780870089030
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "7607fba0-75c2-45a0-ab1c-73a02cce27ee",
"timestamp": 1780870089033
},
{
"data": {
"inputKeys": [
"text",
"model",
"usage"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1780870089033
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "7607fba0-75c2-45a0-ab1c-73a02cce27ee",
"timestamp": 1780870089033
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "ff615a23-530a-499f-94a9-90d2ee8d8370",
"timestamp": 1780870089035
},
{
"data": {
"service": "googleSheets",
"resolved": true
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780870089035
},
{
"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": 1780870089035
},
{
"data": {
"tab": "Sink",
"status": 200
},
"event": "sheets.write",
"nodeId": "integration",
"timestamp": 1780870089175
},
{
"data": {
"mode": "write",
"status": "ok",
"service": "googleSheets",
"latencyMs": 140,
"operation": "appendOrUpdate"
},
"event": "integration_call",
"nodeId": "integration",
"timestamp": 1780870089175
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "ff615a23-530a-499f-94a9-90d2ee8d8370",
"timestamp": 1780870089175
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "7be37211-5f08-4e84-819c-d5182d993328",
"timestamp": 1780870089178
},
{
"data": {
"service": "gmail",
"resolved": true
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780870089178
},
{
"data": {
"url": "https://gmail.googleapis.com/gmail/v1/users/me/messages?maxResults=5&q=in%3Ainbox",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1780870089178
},
{
"data": {
"status": 200
},
"event": "gmail.read",
"nodeId": "integration",
"timestamp": 1780870089291
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "gmail",
"latencyMs": 113,
"operation": "read"
},
"event": "integration_call",
"nodeId": "integration",
"timestamp": 1780870089291
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "7be37211-5f08-4e84-819c-d5182d993328",
"timestamp": 1780870089291
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "55f0f02e-994e-409c-aaf3-b7e9c9df0eea",
"timestamp": 1780870089296
},
{
"data": {
"service": "slack",
"resolved": true
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780870089296
},
{
"data": {
"url": "https://slack.com/api/conversations.history?channel=C0B6WTD21QX&limit=5",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1780870089296
},
{
"data": {
"status": 200
},
"event": "slack.read",
"nodeId": "integration",
"timestamp": 1780870089598
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "slack",
"latencyMs": 302,
"operation": "read"
},
"event": "integration_call",
"nodeId": "integration",
"timestamp": 1780870089598
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "55f0f02e-994e-409c-aaf3-b7e9c9df0eea",
"timestamp": 1780870089598
}
]