Google Play Review Intelligence with Bright Data & Telegram Alerts Overview This n8n workflow automates the process of scraping Google Play Store reviews, analyzing app performance, and sending alerts for low-rated applications. It integrates with Bright Data for web scraping, Google Sheets for data storage, and Telegram for notifications. Workflow Components 1. ✅ Trigger Input Form - Type: Form Trigger - Purpose: Initiates the workflow with user input - Input Fields: - URL (Google Play Store app URL) - Number of reviews to fetch - Function: Captures user requirements to start the scraping process 2. 🚀 Start Scraping Request - Type: HTTP Request (POST) - Purpose: Sends scraping request to Bright Data API - Endpoint: - Parameters: - Dataset ID: gdm6zagkt024uwvvwuyu - Include errors: true - Limit multiple results: 5 - Custom Output Fields: - url, reviewid, reviewername, reviewdate - reviewrating, review, appurl, apptitle - appdeveloper, appimages, apprating - appnumberofreviews, appwhatnew - appcontentrating, appcountry, numofreviews 3. 🔄 Check Scrape Status - Type: HTTP Request (GET) - Purpose: Monitors the progress of the scraping job - Endpoint: - Function: Checks if the dataset scraping is complete 4. ⏱️ Wait for Response 45 sec - Type: Wait Node - Purpose: Implements polling mechanism - Duration: 45 seconds - Function: Pauses workflow before checking status again 5. 🧩 Verify Completion - Type: IF Condition - Purpose: Evaluates scraping completion status - Condition: status === "ready" - Logic: - True: Proceeds to fetch data - False: Loops back to status check 6. 📥 Fetch Scraped Data - Type: HTTP Request (GET) - Purpose: Retrieves the final scraped data - Endpoint: - Format: JSON - Function: Downloads completed review and app data 7. 📊 Save to Google Sheet - Type: Google Sheets Node - Purpose: Stores scraped data for analysis - Operation: Append rows - Target: Specified Google Sheet document - Data Mapping: - URL, Review ID, Reviewer Name, Review Date - Review Rating, Review Text, App Rating - App Number of Reviews, App What's New, App Country 8. ⚠️ Check Low Ratings - Type: IF Condition - Purpose: Identifies poor-performing apps - Condition: reviewrating < 4 - Logic: - True: Triggers alert notification - False: No action taken 9. 📣 Send Alert to Telegram - Type: Telegram Node - Purpose: Sends performance alerts - Message Format: Workflow Flow Configuration Requirements API Keys & Credentials - Bright Data API Key: Required for web scraping - Google Sheets OAuth2: For data storage access - Telegram Bot Token: For alert notifications Setup Parameters - Google Sheet ID: Target spreadsheet identifier - Telegram Chat ID: Destination for alerts - N8N Instance ID: Workflow instance identifier Key Features Data Collection - Comprehensive app metadata extraction - Review content and rating analysis - Developer and country information - App store performance metrics Quality Monitoring - Automated low-rating detection - Real-time performance alerts - Continuous data archiving Integration Capabilities - Bright Data web scraping service - Google Sheets data persistence - Telegram instant notifications - Polling-based status monitoring Use Cases 1. App Performance Monitoring - Track rating trends over time - Identify user sentiment patterns - Monitor competitor performance 2. Quality Assurance - Early warning for rating drops - Customer feedback analysis - Market reputation management 3. Business Intelligence - Review sentiment analysis - Performance benchmarking - Strategic decision support Technical Notes - Polling Interval: 45-second status checks - Rating Threshold: Alerts triggered for ratings < 4 - Data Format: JSON with structured field mapping - Error Handling: Includes error tracking in dataset requests - Result Limiting: Maximum 5 multiple results per request For any questions or support, please contact: info@incrementors.com or fill out this form
