Block 1 - Daily Schedule - 09:00
- Type / Role
- n8n-nodes-base.scheduleTrigger - scheduleTrigger
- Config choices
- Version 1.3
Review aggregator and AI alerts for Google, Facebook, Trustpilot, and Yelp
Workflow preview
100%
$20/month : Unlimited workflows
2500 executions/month
THE #1 IN WEB SCRAPING
Scrape any website without limits
HOSTINGER 
Early Deal
DISCOUNT 20% Try free
Early DealDISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Important notice
This workflow is provided as-is. Please review and test before using in production.
1. Workflow Overview
This workflow automatically collects customer reviews from Google, Facebook, Trustpilot, and Yelp, analyzes their sentiment using AI, sends real time alerts for negative feedback, and generates a w...
Best for
- Market Research automation workflows
- AI Summarization automation workflows
- advanced n8n builders looking for reusable templates
Tools used
n8n-nodes-base.scheduletrigger, n8n-nodes-base.set, n8n-nodes-base.httprequest, n8n-nodes-base.merge, @n8n/n8n-nodes-langchain.openai, n8n-nodes-base.code, n8n-nodes-base.if, n8n-nodes-base.slack
Source and attribution
This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Țugui Dragoș.
Original n8n.io source1.1 Workflow description
- Title
- Review aggregator and AI alerts for Google, Facebook, Trustpilot, and Yelp
- Workflow name
- Review aggregator and AI alerts for Google, Facebook, Trustpilot, and Yelp
This workflow automatically collects customer reviews from Google, Facebook, Trustpilot, and Yelp, analyzes their sentiment using AI, sends real-time alerts for negative feedback, and generates a weekly summary report. It is ideal for businesses that want to monitor their online reputation across multiple platforms and respond quickly to customer concerns.
How It Works
- Daily Schedule: Triggers the workflow every day at 09:00.
- Review Collection: Fetches new reviews from Google, Facebook, Trustpilot, and Yelp using their official APIs.
- Data Normalization: Merges and standardizes all reviews into a unified format.
- AI Sentiment Analysis: Uses GPT-4 to analyze the sentiment and extract key insights from each review.
- Negative Review Alerts: Sends a Slack notification to managers if a negative review is detected.
- Logging: Saves all reviews and their analysis to a Google Sheet for record-keeping.
- Weekly Reporting: Every Monday, aggregates the past week’s reviews, generates an AI-powered summary, and emails it to management.
Configuration
API Credentials:
- Google My Business API: Create a project in Google Cloud, enable the My Business API, and generate OAuth credentials.
- Facebook Graph API: Create a Facebook App, request the necessary permissions, and obtain a Page Access Token.
- Trustpilot API: Register for a Trustpilot Business account and generate an API key.
- Yelp Fusion API: Sign up for Yelp Fusion, create an app, and get your API key.
- OpenAI API: Create an account at OpenAI, generate an API key for GPT-4 access.
- Slack API: Create a Slack App, enable Incoming Webhooks, and get the webhook URL.
- Google Sheets API: Enable the Google Sheets API in Google Cloud and create OAuth credentials.
Set Up Environment Variables:
- Add all API keys, tokens, and configuration values in the
Workflow Configurationnode or as n8n credentials.
- Add all API keys, tokens, and configuration values in the
Google Sheet Setup:
- Create a Google Sheet with columns for review data and share it with your service account email.
Slack Channel:
- Set up a Slack channel for alerts and add the webhook URL in the configuration.
Email Settings:
- Configure the recipient email address for weekly reports in the workflow.
Usage
- Activate the workflow after configuration.
- Reviews will be collected and analyzed daily.
- Negative reviews trigger instant Slack alerts.
- Every Monday, a summary report is sent via email.
Use Case:
Monitor and respond to customer feedback across Google, Facebook, Trustpilot, and Yelp, automate sentiment analysis, and keep management informed with actionable weekly insights.
1.2 Logical Blocks
This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.
2. Block-by-Block Analysis
Block 2 - Workflow Configuration
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Block 3 - Get Google Reviews
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.3
Block 4 - Get Facebook Reviews
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.3
Block 5 - Get Trustpilot Reviews
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.3
Block 6 - Get Yelp Reviews
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.3
Block 7 - Merge All Reviews
- Type / Role
- n8n-nodes-base.merge - merge
- Config choices
- Version 3.2
Block 8 - Prepare AI Input
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Block 9 - Sentiment Analysis (GPT-4)
- Type / Role
- @n8n/n8n-nodes-langchain.openAi - openAi
- Config choices
- Version 2
Block 10 - Categorize & Parse AI Output
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 11 - Check If Negative
- Type / Role
- n8n-nodes-base.if - if
- Config choices
- Version 2.2
Block 12 - Alert - Negative Review
- Type / Role
- n8n-nodes-base.slack - slack
- Config choices
- Version 2.3
Block 13 - Log Review to Sheet
- Type / Role
- n8n-nodes-base.googleSheets - googleSheets
- Config choices
- Version 4.7
Block 14 - Check If Monday (Weekly Report)
- Type / Role
- n8n-nodes-base.if - if
- Config choices
- Version 2.2
Block 15 - Get Last 7 Days Reviews
- Type / Role
- n8n-nodes-base.googleSheets - googleSheets
- Config choices
- Version 4.7
Block 16 - Aggregate Weekly Stats
- Type / Role
- n8n-nodes-base.aggregate - aggregate
- Config choices
- Version 1
Block 17 - Calculate Weekly Metrics
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 18 - Generate Weekly Summary (GPT-4)
- Type / Role
- @n8n/n8n-nodes-langchain.openAi - openAi
- Config choices
- Version 2
Block 19 - Send Weekly Email Report
- Type / Role
- n8n-nodes-base.gmail - gmail
- Config choices
- Version 2.1
Block 20 - Normalize All Reviews
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 21 - Sticky Note
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 22 - Sticky Note1
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 23 - Sticky Note2
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 24 - Sticky Note3
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Showing the first 24 of 27 workflow blocks. Download the JSON for the full node graph.
3. Summary Table
| Workflow | Review aggregator and AI alerts for Google, Facebook, Trustpilot, and Yelp |
|---|---|
| Complexity | advanced |
| Nodes | 27 |
| Categories | Market Research, AI Summarization |
| Author | Țugui Dragoș |
| Published | 01 Dec 2025 |
4. Reproducing the Workflow from Scratch
-
1. Download the workflow JSON
Use the JSON export at /data/workflows/11410/11410.json as the source template for this automation.
-
2. Import the template into n8n
Open n8n, import the downloaded JSON, and review each node before activating the workflow.
-
3. Configure credentials and variables
Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
-
4. Test with sample data
Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.
-
5. Activate and monitor
Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.
5. General Notes & Resources
Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.
Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.
Frequently asked questions
What does Review aggregator and AI alerts for Google, Facebook, Trustpilot, and Yelp do?
This workflow automatically collects customer reviews from Google, Facebook, Trustpilot, and Yelp, analyzes their sentiment using AI, sends real time alerts for negative feedback, and generates a w...
What do I need before importing this workflow?
Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.
Can I customize this workflow?
Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Market Research, AI Summarization use case.