Système intelligent de gestion des avis Google Play avec intégration Bright Data et alertes Telegram
Ceci est unAIworkflow d'automatisation du domainecontenant 18 nœuds.Utilise principalement des nœuds comme If, Wait, Telegram, FormTrigger, HttpRequest, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Système d'analyse intelligente des avis Google Play avec Bright Data et notifications Telegram
- •Token Bot Telegram
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
Nœuds utilisés (18)
Catégorie
{
"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": "Note adhésive",
"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": "Note adhésive 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": "Note adhésive 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": "Note adhésive 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": "Note adhésive 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": "Note adhésive 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": "Note adhésive 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": "Note adhésive 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": "Note adhésive 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": "✅ Formulaire de déclenchement",
"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": "🚀 Lancer la requête de scraping",
"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": "🔄 Vérifier l'état du scraping",
"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": "⏱️ Attendre la réponse 45 sec",
"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": "🧩 Vérifier l'achèvement",
"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": "📥 Récupérer les données scrapées",
"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": "📊 Enregistrer dans Google Sheet",
"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": "⚠️ Vérifier les notes basses",
"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": "📣 Envoyer une alerte à 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
}
]
]
}
}
}Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Avancé - Intelligence Artificielle
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Incrementors
@incrementorsPartager ce workflow