AI Review Clustering and Google Sheets Export
8397aa02-125d-403a-8933-9db6c464425c
Latency
5539ms
Cost
$0.0001
Tokens
165
Status
partialgemini-2.5-flash-lite
Workflow Graph
Trace
[
{
"data": {
"nodeType": "manualTrigger"
},
"event": "node_start",
"nodeId": "63501cc8-77c9-4037-9f70-da23b6d20b03",
"timestamp": 1780866893047
},
{
"data": {
"initialData": {
"output": "This is the processed output for the review.",
"points": [
"Excellent quality",
"Easy to use",
"Highly recommended"
],
"companyId": "comp-abc-123",
"review_url": "https://example.com/reviews/12345",
"review_date": {
"toDateTime": "2023-10-26T10:00:00Z"
},
"review_text": "This product exceeded all my expectations! The quality is superb and it's incredibly easy to use. Highly recommend!",
"review_title": "Absolutely Fantastic Product!",
"review_author": {
"date": "2023-10-26T10:00:00Z",
"name": "Alice Smith",
"country": "USA",
"reviews_count": 15,
"date_of_experience": "2023-09-15T00:00:00Z"
},
"review_rating": 5,
"review_country": "USA",
"review_date_to": "2023-12-31T23:59:59Z",
"review_date_from": "2023-01-01T00:00:00Z",
"review_date_of_experience": {
"toDateTime": "2023-09-15T00:00:00Z"
},
"review_author_reviews_count": 15
}
},
"event": "triggered",
"nodeId": "manualTrigger",
"timestamp": 1780866893047
},
{
"data": {
"status": "ok",
"nodeType": "manualTrigger"
},
"event": "node_end",
"nodeId": "63501cc8-77c9-4037-9f70-da23b6d20b03",
"timestamp": 1780866893047
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "afd8907c-9a59-4dcc-94c5-2114fb2a7d5d",
"timestamp": 1780866893048
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1780866893048
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "afd8907c-9a59-4dcc-94c5-2114fb2a7d5d",
"timestamp": 1780866893048
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "e22d92b8-e8e9-42aa-9d02-2e70234f11ed",
"timestamp": 1780866893049
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1780866893049
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "e22d92b8-e8e9-42aa-9d02-2e70234f11ed",
"timestamp": 1780866893049
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "f21369b9-1dd5-4b35-a1f3-00fd67794051",
"timestamp": 1780866893051
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1780866893051
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1780866893051
},
{
"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": "f21369b9-1dd5-4b35-a1f3-00fd67794051",
"timestamp": 1780866897155
},
{
"data": {
"nodeType": "trigger"
},
"event": "node_start",
"nodeId": "64af9cc7-a194-4427-ba78-d9a1136b962f",
"timestamp": 1780866897160
},
{
"data": {
"kind": "n8n-nodes-base.executeWorkflowTrigger"
},
"event": "seeded",
"nodeId": "trigger",
"timestamp": 1780866897160
},
{
"data": {
"status": "ok",
"nodeType": "trigger"
},
"event": "node_end",
"nodeId": "64af9cc7-a194-4427-ba78-d9a1136b962f",
"timestamp": 1780866897160
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "f0ea6b63-c96d-4b3f-8a21-d0f2dbb4efc3",
"timestamp": 1780866897163
},
{
"data": {
"inputKeys": [
"review_author",
"review_author_reviews_count",
"review_country",
"review_date",
"review_date_of_experience",
"review_rating",
"review_text",
"review_title",
"review_url",
"companyId",
"points",
"review_date_from",
"review_date_to",
"output"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1780866897163
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "f0ea6b63-c96d-4b3f-8a21-d0f2dbb4efc3",
"timestamp": 1780866897163
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "a6b9abf9-a17a-4f30-9f90-6183770c4933",
"timestamp": 1780866897165
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1780866897165
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "a6b9abf9-a17a-4f30-9f90-6183770c4933",
"timestamp": 1780866897165
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "f6a6209c-d269-4238-8e92-230df7b41df9",
"timestamp": 1780866897166
},
{
"data": {
"inputKeys": [
"review_author",
"review_author_reviews_count",
"review_country",
"review_date",
"review_date_of_experience",
"review_rating",
"review_text",
"review_title",
"review_url",
"companyId",
"points",
"review_date_from",
"review_date_to",
"output"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1780866897166
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "f6a6209c-d269-4238-8e92-230df7b41df9",
"timestamp": 1780866897166
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "1f60c3a5-a47a-4313-9b29-8ea652d573f7",
"timestamp": 1780866897167
},
{
"event": "fetching POST http://qdrant:6333/collections/trustpilot_reviews/points/delete",
"nodeId": "http",
"timestamp": 1780866897168
},
{
"data": {
"url": "http://qdrant:6333/collections/trustpilot_reviews/points/delete",
"method": "POST"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1780866897168
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "fetch-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1780866897173
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "1f60c3a5-a47a-4313-9b29-8ea652d573f7",
"timestamp": 1780866897173
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "85cb48b1-0ab9-4f88-88f3-82fcfb041ebe",
"timestamp": 1780866897175
},
{
"event": "fetching POST http://qdrant:6333/collections/trustpilot_reviews/points/scroll",
"nodeId": "http",
"timestamp": 1780866897175
},
{
"data": {
"url": "http://qdrant:6333/collections/trustpilot_reviews/points/scroll",
"method": "POST"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1780866897175
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "fetch-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1780866897178
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "85cb48b1-0ab9-4f88-88f3-82fcfb041ebe",
"timestamp": 1780866897178
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "139ccadd-9135-4681-b2eb-403b8d8bd710",
"timestamp": 1780866897180
},
{
"event": "fetching GET https://uk.trustpilot.com/review/comp-abc-123?sort=recency",
"nodeId": "http",
"timestamp": 1780866897180
},
{
"data": {
"url": "https://uk.trustpilot.com/review/comp-abc-123?sort=recency",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1780866897180
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "139ccadd-9135-4681-b2eb-403b8d8bd710",
"timestamp": 1780866897385
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "4d895cf9-452c-401e-a6f3-b9d3a359a96d",
"timestamp": 1780866897385
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "no-source",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1780866897385
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "4d895cf9-452c-401e-a6f3-b9d3a359a96d",
"timestamp": 1780866897385
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "9290e116-c001-49d5-ae4c-d91cd246f2c2",
"timestamp": 1780866897390
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1780866897390
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "9290e116-c001-49d5-ae4c-d91cd246f2c2",
"timestamp": 1780866897390
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "5fc6e0b6-507f-4cfd-951b-be3709b86ac2",
"timestamp": 1780866897392
},
{
"data": {
"count": 1
},
"event": "splitOut",
"nodeId": "passthrough",
"timestamp": 1780866897392
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "5fc6e0b6-507f-4cfd-951b-be3709b86ac2",
"timestamp": 1780866897392
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "00de989c-d9e9-4b42-b5db-7097800a6017",
"timestamp": 1780866897394
},
{
"data": {
"inputKeys": [
"statusCode",
"headers",
"body"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1780866897394
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "00de989c-d9e9-4b42-b5db-7097800a6017",
"timestamp": 1780866897394
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "b0075699-6513-4781-b5de-81d1ab81dfe1",
"timestamp": 1780866897396
},
{
"data": {
"of": 1,
"kept": 1
},
"event": "filter",
"nodeId": "passthrough",
"timestamp": 1780866897396
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "b0075699-6513-4781-b5de-81d1ab81dfe1",
"timestamp": 1780866897396
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "4aa3e50d-fcce-48a7-8237-c12f8592f69e",
"timestamp": 1780866897397
},
{
"data": {
"count": 1
},
"event": "splitOut",
"nodeId": "passthrough",
"timestamp": 1780866897397
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "4aa3e50d-fcce-48a7-8237-c12f8592f69e",
"timestamp": 1780866897397
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "0188986f-fbe9-4c06-892a-3cb71b52a309",
"timestamp": 1780866897398
},
{
"event": "fetching POST http://qdrant:6333/collections/trustpilot_reviews/points",
"nodeId": "http",
"timestamp": 1780866897398
},
{
"data": {
"url": "http://qdrant:6333/collections/trustpilot_reviews/points",
"method": "POST"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1780866897398
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "fetch-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1780866897403
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "0188986f-fbe9-4c06-892a-3cb71b52a309",
"timestamp": 1780866897403
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "a4f82a1b-5a76-46b6-a7a3-84ab09b46699",
"timestamp": 1780866897404
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1780866897404
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "a4f82a1b-5a76-46b6-a7a3-84ab09b46699",
"timestamp": 1780866897404
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "9bba9480-792e-48e3-ad9f-8809ce3aba09",
"timestamp": 1780866897405
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1780866897405
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1780866897405
},
{
"data": {
"model": "gemini-2.5-flash-lite",
"costUsd": 0.00006390000000000001,
"provider": "openai",
"latencyMs": 933,
"promptTokens": 7,
"completionTokens": 158
},
"event": "llm_result",
"nodeId": "_context",
"timestamp": 1780866898339
},
{
"data": {
"status": "ok",
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "9bba9480-792e-48e3-ad9f-8809ce3aba09",
"timestamp": 1780866898339
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "d3c6e81f-34bb-4be9-b869-2c219b87c4fb",
"timestamp": 1780866898343
},
{
"data": {
"inputKeys": [
"0"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1780866898343
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "d3c6e81f-34bb-4be9-b869-2c219b87c4fb",
"timestamp": 1780866898343
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "69bbd197-c78f-4dae-9300-fe23d4d49855",
"timestamp": 1780866898346
},
{
"data": {
"inputKeys": [
"text",
"model",
"usage"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1780866898346
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "69bbd197-c78f-4dae-9300-fe23d4d49855",
"timestamp": 1780866898346
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "61c3117c-757c-45dd-b9d5-1122b793be30",
"timestamp": 1780866898347
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1780866898347
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "61c3117c-757c-45dd-b9d5-1122b793be30",
"timestamp": 1780866898347
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "d77daa23-6acf-4daa-bf4c-33da4d05a54c",
"timestamp": 1780866898349
},
{
"data": {
"service": "googleSheets",
"resolved": true
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1780866898349
},
{
"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": 1780866898349
},
{
"data": {
"tab": "Sink",
"status": 200
},
"event": "sheets.write",
"nodeId": "integration",
"timestamp": 1780866898586
},
{
"data": {
"mode": "write",
"status": "ok",
"service": "googleSheets",
"latencyMs": 237,
"operation": "append"
},
"event": "integration_call",
"nodeId": "integration",
"timestamp": 1780866898586
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "d77daa23-6acf-4daa-bf4c-33da4d05a54c",
"timestamp": 1780866898586
}
]