Google Analytics-Einblicke

• •Google-Konto + Gmail API-Anmeldedaten
• •Telegram Bot Token
• •Google Gemini API Key

{
  "id": "zFO2MKhe5TtfOLB9",
  "meta": {
    "instanceId": "d02289ff41436fdfe97f97a509483d64007d2a482e6a216298112e027bb59fbf",
    "templateCredsSetupCompleted": true
  },
  "name": "Google Analytics Insight",
  "tags": [],
  "nodes": [
    {
      "id": "f6917f16-25d4-4118-bc0d-1d53e4ca2da4",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "daysInterval": 7
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "6cd64c8e-48d4-4853-a47e-504c43d8cb88",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        416,
        0
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "6925c157-aa0b-4838-a067-3c5eb6c45a76",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        816,
        432
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "googlePalmApi": {
          "id": "LqsDVdm5OmSBk8zP",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "3ebc007d-f125-47b8-9b78-efe15bbed229",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        624,
        0
      ],
      "parameters": {
        "text": "={{ $json.data }}",
        "options": {
          "systemMessage": "Acting as a experience data analyst who mainly working with the analytics data. Please analyze the those google analytics report with the past history. Give the insightful and important summary. Make it concise maximum 1000 chars. The important information must give `` so user can notice easily. The result must follow the telegram messenger format. Compare with your memory as well.\n\nThink step by step."
        },
        "promptType": "define"
      },
      "typeVersion": 2.1
    },
    {
      "id": "3867152b-24bc-4755-9098-8adc0b290c17",
      "name": "Simple Memory",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        752,
        160
      ],
      "parameters": {
        "sessionKey": "={{ $json.data }}",
        "sessionIdType": "customKey"
      },
      "typeVersion": 1.3
    },
    {
      "id": "0b839f21-b96c-47c7-ac2c-4797432704ad",
      "name": "Wöchentlichen Bericht abrufen",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        0
      ],
      "parameters": {
        "metricsGA4": {
          "metricValues": [
            {
              "listName": "eventCount"
            },
            {
              "listName": "userEngagementDuration"
            },
            {},
            {
              "listName": "active7DayUsers"
            },
            {
              "listName": "active28DayUsers"
            },
            {
              "listName": "sessions"
            }
          ]
        },
        "propertyId": {
          "__rl": true,
          "mode": "list",
          "value": "483751327",
          "cachedResultUrl": "",
          "cachedResultName": ""
        },
        "dimensionsGA4": {
          "dimensionValues": [
            {}
          ]
        },
        "additionalFields": {}
      },
      "credentials": {
        "googleAnalyticsOAuth2": {
          "id": "bIarKstIyNxZFNce",
          "name": "Google Analytics account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "3fb80b30-c2ff-4d1c-a810-de96348d7b41",
      "name": "Nachricht an Gruppe senden",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1328,
        176
      ],
      "webhookId": "c7abeda5-d1dd-4b61-b303-62dc3184cb56",
      "parameters": {
        "text": "=Weekly Analytics Report by Gemini \n`{{ $today.minus(7,'days').format('yyyy-MM-dd') }}` to `{{ $today.format('yyyy-MM-dd') }}`\n\n{{ $json.output }}",
        "chatId": "",
        "additionalFields": {}
      },
      "credentials": {
        "telegramApi": {
          "id": "BDQbUISqJJFVGPsF",
          "name": "Telegram account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "fa35b2b5-1ea3-42f5-a1ff-b10716e22e13",
      "name": "Insight Sentiment Analysis",
      "type": "@n8n/n8n-nodes-langchain.sentimentAnalysis",
      "position": [
        976,
        0
      ],
      "parameters": {
        "options": {
          "categories": "Positive, Negative"
        },
        "inputText": "={{ $json.output }}"
      },
      "typeVersion": 1.1
    },
    {
      "id": "605ceecc-27fe-4bf2-9315-290a82c7d6ff",
      "name": "Stakeholders benachrichtigen",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1344,
        -96
      ],
      "webhookId": "d7ff25c2-3291-4320-8f99-1e7bfc6829ef",
      "parameters": {
        "sendTo": "",
        "message": "={{ $('AI Agent').item.json.output }}",
        "options": {},
        "subject": "=GA Weekly Report - Positive Trends - {{ $today.minus(7,'days').format('yyyy-MM-dd') }} - {{ $today.format('yyyy-MM-dd') }}"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "jnWB2PPVjndum47v",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "dd9a5860-f6df-4e7e-a72d-699a772a804f",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -208,
        -320
      ],
      "parameters": {
        "width": 480,
        "height": 240,
        "content": "## AI-Powered Google Analytics Insights + Sentiment Routing\nThis n8n automation runs weekly to fetch the latest Google Analytics data, generate AI-powered insights, and classify the sentiment of the report.\n\n💡 Goal: Deliver actionable analytics updates automatically, ensuring positive trends are celebrated and negative trends are addressed quickly."
      },
      "typeVersion": 1
    },
    {
      "id": "edde901a-8909-4c5d-a9b2-a9fa32026123",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        624,
        -224
      ],
      "parameters": {
        "color": 7,
        "width": 272,
        "height": 176,
        "content": "## AI Agent\n\nConsume the aggregated JSON. Processing the JSON with custom prompt that should return the insightful and concise summary"
      },
      "typeVersion": 1
    },
    {
      "id": "5d0523ed-85e4-4e43-a452-6dae0954b919",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        144
      ],
      "parameters": {
        "color": 7,
        "width": 176,
        "height": 128,
        "content": "## Aggregate\n\nNormalize GA rows into a single JSON"
      },
      "typeVersion": 1
    },
    {
      "id": "80607b8d-60fc-4ece-9f7c-5d09bd826a18",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1248,
        -304
      ],
      "parameters": {
        "color": 7,
        "width": 272,
        "height": 176,
        "content": "## Notify Stakeholders\n\nSend a message with following range date of the weekly report"
      },
      "typeVersion": 1
    },
    {
      "id": "32449586-884b-45b1-855c-8a6796c2de85",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1248,
        384
      ],
      "parameters": {
        "color": 7,
        "width": 272,
        "height": 176,
        "content": "## Send Message\n\nBuild concise alert message for ops/marketing channel"
      },
      "typeVersion": 1
    },
    {
      "id": "e55512cb-9cea-455d-a3c1-1ae31593b1c0",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        496,
        320
      ],
      "parameters": {
        "color": 7,
        "width": 272,
        "height": 176,
        "content": "## Simple Memory\n\nSave each week's report and key metrics. Use for trend detection. You can replace with your preferred memory/database."
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "2e96d5f2-7cb1-405f-8c51-631bb8e7b8d6",
  "connections": {
    "3ebc007d-f125-47b8-9b78-efe15bbed229": {
      "main": [
        [
          {
            "node": "fa35b2b5-1ea3-42f5-a1ff-b10716e22e13",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6cd64c8e-48d4-4853-a47e-504c43d8cb88": {
      "main": [
        [
          {
            "node": "3ebc007d-f125-47b8-9b78-efe15bbed229",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3867152b-24bc-4755-9098-8adc0b290c17": {
      "ai_memory": [
        [
          {
            "node": "3ebc007d-f125-47b8-9b78-efe15bbed229",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "f6917f16-25d4-4118-bc0d-1d53e4ca2da4": {
      "main": [
        [
          {
            "node": "0b839f21-b96c-47c7-ac2c-4797432704ad",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0b839f21-b96c-47c7-ac2c-4797432704ad": {
      "main": [
        [
          {
            "node": "6cd64c8e-48d4-4853-a47e-504c43d8cb88",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6925c157-aa0b-4838-a067-3c5eb6c45a76": {
      "ai_languageModel": [
        [
          {
            "node": "3ebc007d-f125-47b8-9b78-efe15bbed229",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "fa35b2b5-1ea3-42f5-a1ff-b10716e22e13",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "fa35b2b5-1ea3-42f5-a1ff-b10716e22e13": {
      "main": [
        [
          {
            "node": "605ceecc-27fe-4bf2-9315-290a82c7d6ff",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "3fb80b30-c2ff-4d1c-a810-de96348d7b41",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}