Analyze Google Analytics Data with AI and Baserow

344c6684-3a3f-44dd-81ad-c76a7cd4cdc6
Latency
444ms
Cost
$0.0000
Tokens
Status
partial
gemini-3-flash-preview
7 nodes ran as pass-throughs
n8n-nodes-base.googleAnalytics, n8n-nodes-base.googleAnalytics, n8n-nodes-base.googleAnalytics, n8n-nodes-base.googleAnalytics, n8n-nodes-base.googleAnalytics, n8n-nodes-base.googleAnalytics, n8n-nodes-base.baserow
Workflow Graph

Schedule Trigger
0ms
When clicking ‘Test workflow’
0ms
Get Page Engagement Stats for this week
googleanalytics
0ms
Get Page Engagement Stats for prior week
googleanalytics
0ms
Parse data from Google Analytics
4ms
Parse GA data
3ms
Get Google Search Results for this week
googleanalytics
0ms
Get Google Search Results for last week
googleanalytics
0ms
Parse Google Analytics Data
2ms
Parse Google Analytics Data1
3ms
Get Country views data for this week
googleanalytics
0ms
Get Country views data for last week
googleanalytics
0ms
Parse Google analytics data
3ms
Parse Google analytics data1
2ms
Send page data to A.I.
openrouter.ai
240ms
Send page Search data to A.I.
openrouter.ai
95ms
Send country view data to A.I.
openrouter.ai
63ms
Save A.I. output to Baserow
baserow
0ms
Trace

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "6a9fc442-d0a3-48be-8dff-94f8d9cd5cf1",
    "timestamp": 1780780958527
  },
  {
    "data": {
      "kind": "n8n-nodes-base.scheduleTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780780958527
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "6a9fc442-d0a3-48be-8dff-94f8d9cd5cf1",
    "timestamp": 1780780958527
  },
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "484cbc41-f57d-4c3d-a458-e439d480d290",
    "timestamp": 1780780958531
  },
  {
    "data": {
      "initialData": {
        "urlString": "https://www.example-store.com/products/outdoor-gear"
      }
    },
    "event": "triggered",
    "nodeId": "manualTrigger",
    "timestamp": 1780780958531
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "484cbc41-f57d-4c3d-a458-e439d480d290",
    "timestamp": 1780780958531
  },
  {
    "data": {
      "nodeType": "unsupported"
    },
    "event": "node_start",
    "nodeId": "f2fb8535-e81e-4ca1-80df-ee68edba6386",
    "timestamp": 1780780958534
  },
  {
    "data": {
      "type": "n8n-nodes-base.googleAnalytics"
    },
    "event": "unsupported_node",
    "nodeId": "unsupported",
    "timestamp": 1780780958534
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "unsupported"
    },
    "event": "node_end",
    "nodeId": "f2fb8535-e81e-4ca1-80df-ee68edba6386",
    "timestamp": 1780780958534
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "f8dac36b-9e8a-407f-b923-b4cea368f1bc",
    "timestamp": 1780780958534
  },
  {
    "event": "console.log: Input items: [\n  {\n    \"json\": {\n      \"urlString\": \"https://www.example-store.com/products/outdoor-gear\"\n    }\n  }\n]",
    "nodeId": "code",
    "timestamp": 1780780958537
  },
  {
    "event": "console.log: Analytics data is missing or has no rows array",
    "nodeId": "code",
    "timestamp": 1780780958537
  },
  {
    "event": "execution error: Invalid data structure",
    "nodeId": "code",
    "timestamp": 1780780958537
  },
  {
    "data": {
      "error": "Code node execution failed: Invalid data structure",
      "status": "error",
      "degraded": true,
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "f8dac36b-9e8a-407f-b923-b4cea368f1bc",
    "timestamp": 1780780958538
  },
  {
    "data": {
      "nodeType": "unsupported"
    },
    "event": "node_start",
    "nodeId": "1d761425-cebf-4787-b286-b723a0851485",
    "timestamp": 1780780958540
  },
  {
    "data": {
      "type": "n8n-nodes-base.googleAnalytics"
    },
    "event": "unsupported_node",
    "nodeId": "unsupported",
    "timestamp": 1780780958540
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "unsupported"
    },
    "event": "node_end",
    "nodeId": "1d761425-cebf-4787-b286-b723a0851485",
    "timestamp": 1780780958540
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "ed880442-c92e-4347-b277-e8794aea6fbc",
    "timestamp": 1780780958540
  },
  {
    "event": "console.log: Input items: [\n  {\n    \"json\": {\n      \"urlString\": \"https://www.example-store.com/products/outdoor-gear\"\n    }\n  }\n]",
    "nodeId": "code",
    "timestamp": 1780780958543
  },
  {
    "event": "console.log: Analytics data is missing or has no rows array",
    "nodeId": "code",
    "timestamp": 1780780958543
  },
  {
    "event": "execution error: Invalid data structure",
    "nodeId": "code",
    "timestamp": 1780780958543
  },
  {
    "data": {
      "error": "Code node execution failed: Invalid data structure",
      "status": "error",
      "degraded": true,
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "ed880442-c92e-4347-b277-e8794aea6fbc",
    "timestamp": 1780780958543
  },
  {
    "data": {
      "nodeType": "unsupported"
    },
    "event": "node_start",
    "nodeId": "46e092cc-af94-4e64-aa92-931c56345eff",
    "timestamp": 1780780958546
  },
  {
    "data": {
      "type": "n8n-nodes-base.googleAnalytics"
    },
    "event": "unsupported_node",
    "nodeId": "unsupported",
    "timestamp": 1780780958546
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "unsupported"
    },
    "event": "node_end",
    "nodeId": "46e092cc-af94-4e64-aa92-931c56345eff",
    "timestamp": 1780780958546
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "7d3835d6-d1f5-4159-8e34-871871e63989",
    "timestamp": 1780780958546
  },
  {
    "event": "console.log: No valid data found",
    "nodeId": "code",
    "timestamp": 1780780958548
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "7d3835d6-d1f5-4159-8e34-871871e63989",
    "timestamp": 1780780958548
  },
  {
    "data": {
      "nodeType": "unsupported"
    },
    "event": "node_start",
    "nodeId": "709d0aaf-bd3d-4d83-9e66-b7df495855bd",
    "timestamp": 1780780958551
  },
  {
    "data": {
      "type": "n8n-nodes-base.googleAnalytics"
    },
    "event": "unsupported_node",
    "nodeId": "unsupported",
    "timestamp": 1780780958551
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "unsupported"
    },
    "event": "node_end",
    "nodeId": "709d0aaf-bd3d-4d83-9e66-b7df495855bd",
    "timestamp": 1780780958551
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "c018fda4-a2e6-48f4-aabb-039c66374dc7",
    "timestamp": 1780780958551
  },
  {
    "event": "console.log: No valid data found",
    "nodeId": "code",
    "timestamp": 1780780958553
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "c018fda4-a2e6-48f4-aabb-039c66374dc7",
    "timestamp": 1780780958554
  },
  {
    "data": {
      "nodeType": "unsupported"
    },
    "event": "node_start",
    "nodeId": "d8f775cd-daf9-42de-a527-d932be46d945",
    "timestamp": 1780780958555
  },
  {
    "data": {
      "type": "n8n-nodes-base.googleAnalytics"
    },
    "event": "unsupported_node",
    "nodeId": "unsupported",
    "timestamp": 1780780958555
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "unsupported"
    },
    "event": "node_end",
    "nodeId": "d8f775cd-daf9-42de-a527-d932be46d945",
    "timestamp": 1780780958555
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "546d6cd2-6db6-4276-be35-abbe5a7e9b6a",
    "timestamp": 1780780958555
  },
  {
    "event": "console.log: No valid data found",
    "nodeId": "code",
    "timestamp": 1780780958557
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "546d6cd2-6db6-4276-be35-abbe5a7e9b6a",
    "timestamp": 1780780958558
  },
  {
    "data": {
      "nodeType": "unsupported"
    },
    "event": "node_start",
    "nodeId": "7119e57c-cbf4-49a9-b0c9-1f3da1fd2af3",
    "timestamp": 1780780958560
  },
  {
    "data": {
      "type": "n8n-nodes-base.googleAnalytics"
    },
    "event": "unsupported_node",
    "nodeId": "unsupported",
    "timestamp": 1780780958560
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "unsupported"
    },
    "event": "node_end",
    "nodeId": "7119e57c-cbf4-49a9-b0c9-1f3da1fd2af3",
    "timestamp": 1780780958560
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "87cb137c-686d-49a5-8657-06ed0c5f5c27",
    "timestamp": 1780780958560
  },
  {
    "event": "console.log: No valid data found",
    "nodeId": "code",
    "timestamp": 1780780958562
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "87cb137c-686d-49a5-8657-06ed0c5f5c27",
    "timestamp": 1780780958562
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "06c4478d-a13a-4587-9f1f-451a68798a9f",
    "timestamp": 1780780958564
  },
  {
    "event": "fetching POST https://openrouter.ai/api/v1/chat/completions",
    "nodeId": "http",
    "timestamp": 1780780958564
  },
  {
    "data": {
      "url": "https://openrouter.ai/api/v1/chat/completions",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780780958564
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "06c4478d-a13a-4587-9f1f-451a68798a9f",
    "timestamp": 1780780958804
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "4ad522b0-afe4-4eff-aa16-b86cc892ead8",
    "timestamp": 1780780958808
  },
  {
    "event": "fetching POST https://openrouter.ai/api/v1/chat/completions",
    "nodeId": "http",
    "timestamp": 1780780958808
  },
  {
    "data": {
      "url": "https://openrouter.ai/api/v1/chat/completions",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780780958808
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "4ad522b0-afe4-4eff-aa16-b86cc892ead8",
    "timestamp": 1780780958903
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "07e1eebf-f16a-44c0-83b5-76bf65a3d3fc",
    "timestamp": 1780780958905
  },
  {
    "event": "fetching POST https://openrouter.ai/api/v1/chat/completions",
    "nodeId": "http",
    "timestamp": 1780780958905
  },
  {
    "data": {
      "url": "https://openrouter.ai/api/v1/chat/completions",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780780958905
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "07e1eebf-f16a-44c0-83b5-76bf65a3d3fc",
    "timestamp": 1780780958968
  },
  {
    "data": {
      "nodeType": "unsupported"
    },
    "event": "node_start",
    "nodeId": "c4648ad8-2377-42a0-a431-931b53631c9d",
    "timestamp": 1780780958971
  },
  {
    "data": {
      "type": "n8n-nodes-base.baserow"
    },
    "event": "unsupported_node",
    "nodeId": "unsupported",
    "timestamp": 1780780958971
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "unsupported"
    },
    "event": "node_end",
    "nodeId": "c4648ad8-2377-42a0-a431-931b53631c9d",
    "timestamp": 1780780958971
  }
]