AI Review Clustering and Google Sheets Export
563bccde-e698-4f48-832c-44359ea119e3
Latency
7479ms
Cost
$0.0021
Tokens
833
Status
successgemini-3-flash-preview
Workflow Graph
Trace
[
{
"data": {
"nodeType": "manualTrigger"
},
"event": "node_start",
"nodeId": "63501cc8-77c9-4037-9f70-da23b6d20b03",
"timestamp": 1782945966768
},
{
"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": 1782945966768
},
{
"data": {
"status": "ok",
"nodeType": "manualTrigger"
},
"event": "node_end",
"nodeId": "63501cc8-77c9-4037-9f70-da23b6d20b03",
"timestamp": 1782945966768
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "afd8907c-9a59-4dcc-94c5-2114fb2a7d5d",
"timestamp": 1782945966771
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1782945966771
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "afd8907c-9a59-4dcc-94c5-2114fb2a7d5d",
"timestamp": 1782945966771
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "e22d92b8-e8e9-42aa-9d02-2e70234f11ed",
"timestamp": 1782945966773
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1782945966773
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "e22d92b8-e8e9-42aa-9d02-2e70234f11ed",
"timestamp": 1782945966773
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "f21369b9-1dd5-4b35-a1f3-00fd67794051",
"timestamp": 1782945966775
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1782945966775
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1782945966775
},
{
"data": {
"model": "gemini-3-flash-preview",
"costUsd": 0.0017653,
"provider": "openai",
"latencyMs": 5208,
"promptTokens": 1,
"completionTokens": 706
},
"event": "llm_result",
"nodeId": "_context",
"timestamp": 1782945971986
},
{
"data": {
"status": "ok",
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "f21369b9-1dd5-4b35-a1f3-00fd67794051",
"timestamp": 1782945971986
},
{
"data": {
"nodeType": "trigger"
},
"event": "node_start",
"nodeId": "64af9cc7-a194-4427-ba78-d9a1136b962f",
"timestamp": 1782945971989
},
{
"data": {
"kind": "n8n-nodes-base.executeWorkflowTrigger"
},
"event": "seeded",
"nodeId": "trigger",
"timestamp": 1782945971989
},
{
"data": {
"status": "ok",
"nodeType": "trigger"
},
"event": "node_end",
"nodeId": "64af9cc7-a194-4427-ba78-d9a1136b962f",
"timestamp": 1782945971989
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "f0ea6b63-c96d-4b3f-8a21-d0f2dbb4efc3",
"timestamp": 1782945971992
},
{
"data": {
"inputKeys": [
"output",
"points",
"companyId",
"review_url",
"review_date",
"review_text",
"review_title",
"review_author",
"review_rating",
"review_country",
"review_date_to",
"review_date_from",
"review_date_of_experience",
"review_author_reviews_count"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1782945971992
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "f0ea6b63-c96d-4b3f-8a21-d0f2dbb4efc3",
"timestamp": 1782945971992
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "a6b9abf9-a17a-4f30-9f90-6183770c4933",
"timestamp": 1782945971994
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1782945971994
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "a6b9abf9-a17a-4f30-9f90-6183770c4933",
"timestamp": 1782945971994
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "f6a6209c-d269-4238-8e92-230df7b41df9",
"timestamp": 1782945971995
},
{
"data": {
"inputKeys": [
"output",
"points",
"companyId",
"review_url",
"review_date",
"review_text",
"review_title",
"review_author",
"review_rating",
"review_country",
"review_date_to",
"review_date_from",
"review_date_of_experience",
"review_author_reviews_count"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1782945971995
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "f6a6209c-d269-4238-8e92-230df7b41df9",
"timestamp": 1782945971995
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "1f60c3a5-a47a-4313-9b29-8ea652d573f7",
"timestamp": 1782945971997
},
{
"event": "fetching POST http://qdrant:6333/collections/trustpilot_reviews/points/delete",
"nodeId": "http",
"timestamp": 1782945971997
},
{
"data": {
"url": "http://qdrant:6333/collections/trustpilot_reviews/points/delete",
"method": "POST"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1782945971997
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "fetch-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1782945972001
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "1f60c3a5-a47a-4313-9b29-8ea652d573f7",
"timestamp": 1782945972001
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "85cb48b1-0ab9-4f88-88f3-82fcfb041ebe",
"timestamp": 1782945972003
},
{
"event": "fetching POST http://qdrant:6333/collections/trustpilot_reviews/points/scroll",
"nodeId": "http",
"timestamp": 1782945972003
},
{
"data": {
"url": "http://qdrant:6333/collections/trustpilot_reviews/points/scroll",
"method": "POST"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1782945972003
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "fetch-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1782945972006
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "85cb48b1-0ab9-4f88-88f3-82fcfb041ebe",
"timestamp": 1782945972006
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "139ccadd-9135-4681-b2eb-403b8d8bd710",
"timestamp": 1782945972007
},
{
"event": "fetching GET https://uk.trustpilot.com/review/comp-abc-123?sort=recency",
"nodeId": "http",
"timestamp": 1782945972007
},
{
"data": {
"url": "https://uk.trustpilot.com/review/comp-abc-123?sort=recency",
"method": "GET"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1782945972007
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "139ccadd-9135-4681-b2eb-403b8d8bd710",
"timestamp": 1782945972204
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "4d895cf9-452c-401e-a6f3-b9d3a359a96d",
"timestamp": 1782945972204
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "no-source",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1782945972204
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "4d895cf9-452c-401e-a6f3-b9d3a359a96d",
"timestamp": 1782945972204
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "9290e116-c001-49d5-ae4c-d91cd246f2c2",
"timestamp": 1782945972208
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1782945972208
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "9290e116-c001-49d5-ae4c-d91cd246f2c2",
"timestamp": 1782945972208
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "5fc6e0b6-507f-4cfd-951b-be3709b86ac2",
"timestamp": 1782945972213
},
{
"data": {
"count": 1
},
"event": "splitOut",
"nodeId": "passthrough",
"timestamp": 1782945972213
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "5fc6e0b6-507f-4cfd-951b-be3709b86ac2",
"timestamp": 1782945972213
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "00de989c-d9e9-4b42-b5db-7097800a6017",
"timestamp": 1782945972216
},
{
"data": {
"inputKeys": [
"statusCode",
"headers",
"body"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1782945972216
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "00de989c-d9e9-4b42-b5db-7097800a6017",
"timestamp": 1782945972216
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "b0075699-6513-4781-b5de-81d1ab81dfe1",
"timestamp": 1782945972218
},
{
"data": {
"of": 1,
"kept": 1
},
"event": "filter",
"nodeId": "passthrough",
"timestamp": 1782945972218
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "b0075699-6513-4781-b5de-81d1ab81dfe1",
"timestamp": 1782945972218
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "4aa3e50d-fcce-48a7-8237-c12f8592f69e",
"timestamp": 1782945972220
},
{
"data": {
"count": 1
},
"event": "splitOut",
"nodeId": "passthrough",
"timestamp": 1782945972220
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "4aa3e50d-fcce-48a7-8237-c12f8592f69e",
"timestamp": 1782945972220
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "0188986f-fbe9-4c06-892a-3cb71b52a309",
"timestamp": 1782945972221
},
{
"event": "fetching POST http://qdrant:6333/collections/trustpilot_reviews/points",
"nodeId": "http",
"timestamp": 1782945972221
},
{
"data": {
"url": "http://qdrant:6333/collections/trustpilot_reviews/points",
"method": "POST"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1782945972221
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "fetch-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1782945972224
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "0188986f-fbe9-4c06-892a-3cb71b52a309",
"timestamp": 1782945972224
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "a4f82a1b-5a76-46b6-a7a3-84ab09b46699",
"timestamp": 1782945972227
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1782945972227
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "a4f82a1b-5a76-46b6-a7a3-84ab09b46699",
"timestamp": 1782945972227
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "9bba9480-792e-48e3-ad9f-8809ce3aba09",
"timestamp": 1782945972229
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1782945972229
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1782945972229
},
{
"data": {
"model": "gemini-3-flash-preview",
"costUsd": 0.0002996,
"provider": "openai",
"latencyMs": 1504,
"promptTokens": 7,
"completionTokens": 119
},
"event": "llm_result",
"nodeId": "_context",
"timestamp": 1782945973735
},
{
"data": {
"status": "ok",
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "9bba9480-792e-48e3-ad9f-8809ce3aba09",
"timestamp": 1782945973735
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "d3c6e81f-34bb-4be9-b869-2c219b87c4fb",
"timestamp": 1782945973738
},
{
"data": {
"inputKeys": [
"0"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1782945973738
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "d3c6e81f-34bb-4be9-b869-2c219b87c4fb",
"timestamp": 1782945973738
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "69bbd197-c78f-4dae-9300-fe23d4d49855",
"timestamp": 1782945973742
},
{
"data": {
"inputKeys": [
"text",
"model",
"usage"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1782945973742
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "69bbd197-c78f-4dae-9300-fe23d4d49855",
"timestamp": 1782945973742
},
{
"data": {
"nodeType": "passthrough"
},
"event": "node_start",
"nodeId": "61c3117c-757c-45dd-b9d5-1122b793be30",
"timestamp": 1782945973744
},
{
"data": {},
"event": "noOp",
"nodeId": "passthrough",
"timestamp": 1782945973744
},
{
"data": {
"status": "ok",
"nodeType": "passthrough"
},
"event": "node_end",
"nodeId": "61c3117c-757c-45dd-b9d5-1122b793be30",
"timestamp": 1782945973744
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "d77daa23-6acf-4daa-bf4c-33da4d05a54c",
"timestamp": 1782945973746
},
{
"data": {
"mode": "write",
"status": "ok",
"service": "googleSheets",
"safeMode": true,
"latencyMs": 500,
"operation": "append",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1782945974247
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "d77daa23-6acf-4daa-bf4c-33da4d05a54c",
"timestamp": 1782945974247
}
]