Bright DataとTelegram通知を統合したGoogle Playレビューインテリジェントシステム

上級

これはAI分野の自動化ワークフローで、18個のノードを含みます。主にIf, Wait, Telegram, FormTrigger, HttpRequestなどのノードを使用、AI技術を活用したスマート自動化を実現。 Bright DataとTelegram通知を利用したGoogle Playレビューのスマート分析システム

前提条件
  • Telegram Bot Token
  • ターゲットAPIの認証情報が必要な場合あり
  • Google Sheets API認証情報

カテゴリー

ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
  "id": "0Om9VswvKOf2cyjY",
  "meta": {
    "instanceId": "YOUR_N8N_INSTANCE_ID",
    "templateCredsSetupCompleted": true
  },
  "name": "Comprehensive Google Play Review Intelligence System with Bright Data Integration & Telegram Alerts",
  "tags": [],
  "nodes": [
    {
      "id": "81566f57-58b6-4876-ad16-3b585bbf75d4",
      "name": "付箋",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -580,
        60
      ],
      "parameters": {
        "color": 6,
        "width": 360,
        "height": 260,
        "content": "Evaluates if the dataset scraping process is complete (status: \"ready\"). Loops if not."
      },
      "typeVersion": 1
    },
    {
      "id": "5c6189f3-3e89-4dc0-84f6-6641c213bc8c",
      "name": "付箋1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -940,
        20
      ],
      "parameters": {
        "color": 5,
        "width": 300,
        "height": 300,
        "content": "Pauses the workflow for 45 seconds before checking the status again — used for polling Bright Data API.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "82192678-1180-4491-a629-926a566f0c47",
      "name": "付箋2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1260,
        20
      ],
      "parameters": {
        "color": 4,
        "width": 280,
        "height": 280,
        "content": "Checks the current processing status of the dataset request using the snapshot ID."
      },
      "typeVersion": 1
    },
    {
      "id": "a39574eb-692e-45f9-ba8a-b18ca5b8bd6c",
      "name": "付箋3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1580,
        20
      ],
      "parameters": {
        "width": 280,
        "height": 280,
        "content": "Sends a POST request to Bright Data API to start scraping reviews and app details based on user input.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "9d64ea9a-bd63-4231-b459-90376f8b4eb6",
      "name": "付箋4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1900,
        20
      ],
      "parameters": {
        "color": 3,
        "width": 280,
        "height": 280,
        "content": "Triggers the workflow with user input — takes Google Play Store URL and number of reviews to fetch.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "656204ee-b437-4e61-8a73-745365ec45c2",
      "name": "付箋5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -140,
        40
      ],
      "parameters": {
        "color": 2,
        "width": 320,
        "height": 280,
        "content": "Retrieves the final scraped data (reviews and app info) once the dataset is ready.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "8489a0c1-ff08-4293-b9a1-9d60840b2a5d",
      "name": "付箋6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        300,
        -220
      ],
      "parameters": {
        "color": 6,
        "width": 300,
        "height": 280,
        "content": "Appends selected app and review data into a connected Google Sheet for storage.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "c1cc4ad6-fd24-4198-ad99-e6cb15f038d8",
      "name": "付箋7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        280,
        120
      ],
      "parameters": {
        "color": 4,
        "width": 280,
        "height": 320,
        "content": "Filters out reviews with rating below 4 to flag low-performing apps."
      },
      "typeVersion": 1
    },
    {
      "id": "1f8ee417-cef0-4496-aa6c-d89fd798dbb6",
      "name": "付箋8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        600,
        120
      ],
      "parameters": {
        "color": 3,
        "width": 300,
        "height": 320,
        "content": "Sends a Telegram alert if the app has low ratings, indicating poor performance."
      },
      "typeVersion": 1
    },
    {
      "id": "b275d814-2941-455e-b256-710e14569221",
      "name": "✅ トリガー入力フォーム",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -1800,
        120
      ],
      "webhookId": "b32a8f46-3345-40a0-b500-7bec7aa1be49",
      "parameters": {
        "options": {},
        "formTitle": "Google Play Store",
        "formFields": {
          "values": [
            {
              "fieldLabel": "URL"
            },
            {
              "fieldType": "number",
              "fieldLabel": "No of review"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "afcfa8b5-c5bb-4636-88dc-7c8ada2b7aa4",
      "name": "🚀 スクレイピング開始リクエスト",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1500,
        120
      ],
      "parameters": {
        "url": "https://api.brightdata.com/datasets/v3/trigger",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n  \"input\": [\n    {\n      \"url\": \"{{ $json.URL }}\",\n      \"num_of_reviews\": {{ $json[\"No of review\"] }},\n      \"country\": \"US\"\n    }\n  ],\n  \"custom_output_fields\": [\n    \"url\",\n    \"review_id\",\n    \"reviewer_name\",\n    \"review_date\",\n    \"review_rating\",\n    \"review\",\n    \"app_url\",\n    \"app_title\",\n    \"app_developer\",\n    \"app_images\",\n    \"app_rating\",\n    \"app_number_of_reviews\",\n    \"app_what_new\",\n    \"app_content_rating\",\n    \"app_country\",\n    \"num_of_reviews\"\n  ]\n}\n",
        "sendBody": true,
        "sendQuery": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "queryParameters": {
          "parameters": [
            {
              "name": "dataset_id",
              "value": "gd_m6zagkt024uwvvwuyu"
            },
            {
              "name": "include_errors",
              "value": "true"
            },
            {
              "name": "limit_multiple_results",
              "value": "5"
            }
          ]
        },
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer BRIGHT_DATA_API_KEY"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "31fe5e15-7520-42a1-a818-0391b156ea16",
      "name": "🔄 スクレイピング状態確認",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1160,
        120
      ],
      "parameters": {
        "url": "=https://api.brightdata.com/datasets/v3/progress/{{ $json.snapshot_id }}",
        "options": {},
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer BRIGHT_DATA_API_KEY"
            }
          ]
        }
      },
      "typeVersion": 4.2,
      "alwaysOutputData": true
    },
    {
      "id": "de081ff7-c9a0-43e1-8748-976e7eff0490",
      "name": "⏱️ 45秒待機",
      "type": "n8n-nodes-base.wait",
      "position": [
        -840,
        120
      ],
      "webhookId": "10b45556-5e91-4387-abd0-f9078b220286",
      "parameters": {
        "amount": 45
      },
      "typeVersion": 1.1
    },
    {
      "id": "68fcadf3-b117-4dd3-baf5-bc1c904c168a",
      "name": "🧩 完了確認",
      "type": "n8n-nodes-base.if",
      "position": [
        -460,
        120
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "or",
          "conditions": [
            {
              "id": "35ed620d-b5d5-4e97-bcc5-52b283d85616",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.status }}",
              "rightValue": "ready"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "4adb27d2-b056-4a72-aefe-b7482f55d6ee",
      "name": "📥 スクレイピングデータ取得",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -40,
        120
      ],
      "parameters": {
        "url": "=https://api.brightdata.com/datasets/v3/snapshot/{{ $json.snapshot_id }}",
        "options": {},
        "sendQuery": true,
        "sendHeaders": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "format",
              "value": "json"
            }
          ]
        },
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer BRIGHT_DATA_API_KEY"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "b81d03b8-6d18-4539-be74-3beb853bdf35",
      "name": "📊 Google シートに保存",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        380,
        -120
      ],
      "parameters": {
        "columns": {
          "value": {
            "url": "={{ $json.url }}",
            "review": "={{ $json.review }}",
            "review_id": "={{ $json.review_id }}",
            "app_rating": "={{ $json.app_rating }}",
            "app_country": "={{ $json.app_country }}",
            "review_date": "={{ $json.review_date }}",
            "app_what_new": "={{ $json.app_what_new }}",
            "review_rating": "={{ $json.review_rating }}",
            "reviewer_name": "={{ $json.reviewer_name }}",
            "app_number_of_reviews": "={{ $json.app_number_of_reviews }}"
          },
          "schema": [
            {
              "id": "url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "review_id",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "review_id",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "reviewer_name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "reviewer_name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "review_date",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "review_date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "review_rating",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "review_rating",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "review",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "review",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "app_url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "app_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "app_title",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "app_title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "app_developer",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "app_developer",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "app_images",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "app_images",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "app_rating",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "app_rating",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "app_number_of_reviews",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "app_number_of_reviews",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "app_what_new",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "app_what_new",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "app_content_rating",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "app_content_rating",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "app_country",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "app_country",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "num_of_reviews",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "num_of_reviews",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_GOOGLE_SHEET_ID",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit",
          "cachedResultName": "Google Play Review Scraper"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "YOUR_GOOGLE_SHEETS_CREDENTIAL_ID",
          "name": "Google Sheets OAuth2"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "0a0c0cbb-694d-47b8-80ee-235df0a9a426",
      "name": "⚠️ 低評価チェック",
      "type": "n8n-nodes-base.if",
      "position": [
        360,
        240
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "90bfec56-9510-4bc5-a4c6-aa155bfaf15a",
              "operator": {
                "type": "number",
                "operation": "lt"
              },
              "leftValue": "={{ $json.review_rating }}",
              "rightValue": 4
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "9508b6fa-f1d5-4ca9-8ca7-8e4a0a18f638",
      "name": "📣 Telegram へアラート送信",
      "type": "n8n-nodes-base.telegram",
      "position": [
        680,
        260
      ],
      "webhookId": "3f2bb749-4267-49fa-8d69-7906504504e3",
      "parameters": {
        "text": "=⚠️ *Low App Performance Alert*  📱 *App:* {{ $json.app_title }} 🧑‍💻 *Developer:* {{ $json.app_developer }} ⭐ *Rating:* {{ $json.app_rating }} 📝 *Reviews:* {{ $json.app_number_of_reviews }}  🔗 [View on Play Store]({{ $json.url }})",
        "chatId": "YOUR_TELEGRAM_CHAT_ID",
        "additionalFields": {}
      },
      "credentials": {
        "telegramApi": {
          "id": "YOUR_TELEGRAM_CREDENTIAL_ID",
          "name": "Telegram Bot"
        }
      },
      "typeVersion": 1.2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "bea43585-0122-4277-8298-80674d93c326",
  "connections": {
    "b275d814-2941-455e-b256-710e14569221": {
      "main": [
        [
          {
            "node": "afcfa8b5-c5bb-4636-88dc-7c8ada2b7aa4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "68fcadf3-b117-4dd3-baf5-bc1c904c168a": {
      "main": [
        [
          {
            "node": "4adb27d2-b056-4a72-aefe-b7482f55d6ee",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "31fe5e15-7520-42a1-a818-0391b156ea16",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4adb27d2-b056-4a72-aefe-b7482f55d6ee": {
      "main": [
        [
          {
            "node": "b81d03b8-6d18-4539-be74-3beb853bdf35",
            "type": "main",
            "index": 0
          },
          {
            "node": "0a0c0cbb-694d-47b8-80ee-235df0a9a426",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0a0c0cbb-694d-47b8-80ee-235df0a9a426": {
      "main": [
        [],
        [
          {
            "node": "9508b6fa-f1d5-4ca9-8ca7-8e4a0a18f638",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "31fe5e15-7520-42a1-a818-0391b156ea16": {
      "main": [
        [
          {
            "node": "de081ff7-c9a0-43e1-8748-976e7eff0490",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "afcfa8b5-c5bb-4636-88dc-7c8ada2b7aa4": {
      "main": [
        [
          {
            "node": "31fe5e15-7520-42a1-a818-0391b156ea16",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "de081ff7-c9a0-43e1-8748-976e7eff0490": {
      "main": [
        [
          {
            "node": "68fcadf3-b117-4dd3-baf5-bc1c904c168a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
よくある質問

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

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

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

上級 - 人工知能

有料ですか?

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

関連ワークフロー

リード generationワークフロー:YelpおよびTrustpilotのクローリングにBrightDataを使用し、OpenAIで分析を実施
Yelp と Trustpilot からスクレイビング + AI 駆動のメールアウトレーチでリードを生成します
If
Code
Wait
+
If
Code
Wait
32 ノードIncrementors
営業
財務インサイトの自動化:市值を Bright Data 経由で Telegram に送信
Bright Dataを使ってYahoo Financeから時価総額データを取得し、Telegramで可視化する
If
Code
Wait
+
If
Code
Wait
14 ノードIncrementors
仮想通貨取引
Bright Data APIとGoogle Sheets連携のGoogle Mapsビジネス電話番号スクレイパー
Bright Data APIを利用したGoogle Maps電話番号スクレイピングとGoogle Sheetsとの同期
If
Wait
Form Trigger
+
If
Wait
Form Trigger
16 ノードIncrementors
営業
LinkedInとIndeed求人スクレイパー(Bright Data経由)とGoogleエクスポート
LinkedIn、Indeed、Bright Data、Googleスプレッドシートを使用した求人情報スクレイピング
If
Code
Wait
+
If
Code
Wait
33 ノードIncrementors
人事
スマート资金管理器
基于Telegram、Google SheetsとOpenAIのAI驱动收据と支出追踪器
If
Set
Code
+
If
Set
Code
50 ノードKhairul Muhtadin
財務
Bright Data、Gemini AI、Google Sheetsを使用したキーワード別Crunchbaseスタートアップ分析
Bright Data、Gemini AI、Google Sheetsを使ってキーワード別にCrunchbaseのスタートアップ企業を分析
If
Code
Wait
+
If
Code
Wait
13 ノードGleb D
人工知能
ワークフロー情報
難易度
上級
ノード数18
カテゴリー1
ノードタイプ7
難易度説明

上級者向け、16ノード以上の複雑なワークフロー

外部リンク
n8n.ioで表示

このワークフローを共有

カテゴリー

カテゴリー: 34