Google アナリティクスのインサイト

中級

これはMarket Research, Multimodal AI分野の自動化ワークフローで、15個のノードを含みます。主にGmail, Telegram, Aggregate, Agent, GoogleAnalyticsなどのノードを使用。 Gemini AIを使用してGoogle Analyticsのデータを自動解析し、Gmail/Telegramへスマートにルーティング

前提条件
  • Googleアカウント + Gmail API認証情報
  • Telegram Bot Token
  • Google Gemini API Key
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
  "id": "zFO2MKhe5TtfOLB9",
  "meta": {
    "instanceId": "d02289ff41436fdfe97f97a509483d64007d2a482e6a216298112e027bb59fbf",
    "templateCredsSetupCompleted": true
  },
  "name": "Google Analytics Insight",
  "tags": [],
  "nodes": [
    {
      "id": "f6917f16-25d4-4118-bc0d-1d53e4ca2da4",
      "name": "スケジュールトリガー",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "daysInterval": 7
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "6cd64c8e-48d4-4853-a47e-504c43d8cb88",
      "name": "集計",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        416,
        0
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "6925c157-aa0b-4838-a067-3c5eb6c45a76",
      "name": "Google Gemini チャットモデル",
      "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エージェント",
      "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": "シンプルメモリ",
      "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": "週次レポート取得",
      "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": "グループへメッセージ送信",
      "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": "インサイト感情分析",
      "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": "関係者へ通知",
      "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": "付箋",
      "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": "付箋1",
      "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": "付箋2",
      "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": "付箋3",
      "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": "付箋4",
      "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": "付箋5",
      "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
          }
        ]
      ]
    }
  }
}
よくある質問

このワークフローの使い方は?

上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。

このワークフローはどんな場面に適していますか?

中級 - 市場調査, マルチモーダルAI

有料ですか?

このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス(OpenAI APIなど)は別途料金が発生する場合があります。

ワークフロー情報
難易度
中級
ノード数15
カテゴリー2
ノードタイプ10
難易度説明

経験者向け、6-15ノードの中程度の複雑さのワークフロー

作成者
Rully Saputra

Rully Saputra

@rullysaputra15

Specializing in software engineering with over 5 years of hands-on experience. In addition to my expertise in web development, I also have experience in creating Hybrid mobile apps.

外部リンク
n8n.ioで表示

このワークフローを共有

カテゴリー

カテゴリー: 34