Système intelligent de gestion des avis Google Play avec intégration Bright Data et alertes Telegram

Avancé

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

Prérequis
  • Token Bot Telegram
  • Peut nécessiter les informations d'identification d'authentification de l'API cible
  • Informations d'identification Google Sheets API
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "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
          }
        ]
      ]
    }
  }
}
Foire aux questions

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.

Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds18
Catégorie1
Types de nœuds7
Description de la difficulté

Adapté aux utilisateurs avancés, avec des workflows complexes contenant 16+ nœuds

Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34