Multi-Platform Review Aggregator and AI Alert System - n8n Workflow

A Markdown-formatted string describing the ideal user persona.

Marketing Managers: Need a consolidated view of online reputation across multiple platforms without manual checking.
Operations Teams: Require immediate alerts for negative feedback to facilitate fast resolution.
Business Owners: Seeking automated, data-driven executive summaries of customer sentiment.
Automation Specialists: Looking for robust n8n templates demonstrating complex data aggregation, AI processing, and conditional branching.

Managing online reputation across multiple platforms like Google, Yelp, and social media can be time-consuming. This powerful n8n workflow solves this by centralizing all data. Every day, the n8n trigger initiates the collection of fresh reviews from four major sources. The collected data is then fed into an advanced AI model (GPT-4) for detailed sentiment analysis, categorization, and summary generation.

This specific n8n workflow ensures crucial feedback is never missed, providing instant Slack alerts for any negative reviews flagged by the AI. Furthermore, it creates a robust reporting infrastructure by logging all data to Google Sheets. On a weekly schedule, the n8n workflow utilizes the stored data and AI again to generate a comprehensive executive summary, delivered directly via a Gmail email report, offering actionable insights for management.

This comprehensive n8n workflow operates in two main phases: a daily aggregation/alert cycle and a weekly reporting cycle, both initiated by the n8n trigger.

1. Daily Trigger and Configuration: The automation starts daily at 9:00 AM using the 'Daily Schedule' n8n trigger. Initial settings (API keys, channel IDs) are loaded via the 'Workflow Configuration' n8n node.


2. Data Fetching & Merging: Four parallel HTTP Request n8n nodes pull new reviews from Google, Facebook, Trustpilot, and Yelp. These are combined using the 'Merge All Reviews' n8n node.


3. Normalization: The 'Normalize All Reviews' n8n node uses custom code to ensure every review, regardless of its source platform, adheres to a uniform data structure.


4. AI Processing: Each normalized review is sent to the 'Sentiment Analysis (GPT-4)' n8n node, where the AI extracts sentiment, assigns a score, lists issues/highlights, and writes a summary. This is a critical step in this n8n workflow.


5. Alerting & Logging: The workflow uses a Code n8n node to parse the AI output and then checks the sentiment using an If n8n node ('Check If Negative'). If negative, a real-time alert is sent via the Slack n8n node. All reviews and AI-generated insights are simultaneously logged to Google Sheets using the 'Log Review to Sheet' n8n node.


6. Weekly Report (Monday): The flow splits. The 'Check If Monday' If n8n node determines if it's the right day for the weekly report. If true, the 'Get Last 7 Days Reviews' Google Sheets n8n node retrieves the previous week's data.


7. Metric Calculation: The 'Aggregate Weekly Stats' and 'Calculate Weekly Metrics' Code n8n node process the raw data to calculate platform volumes, sentiment percentages, and the frequency of top issues.


8. Final AI Summary: The processed metrics are sent back to the 'Generate Weekly Summary (GPT-4)' n8n node, which produces a professional executive report.


9. Email Delivery: The 'Send Weekly Email Report' Gmail n8n node compiles the AI summary and key metrics into an HTML-formatted email and sends it to the designated manager.

To deploy this powerful n8n workflow template, follow these steps:

1. Import the JSON: Copy the provided n8n workflow JSON and paste it into your n8n instance via the 'New Workflow' -> 'Import from JSON' option.


2. Configure Credentials: This n8n workflow requires several credentials. Set up connections for:

1. Update Workflow Configuration: Select the 'Workflow Configuration' n8n node (Set node) and replace all placeholder values (<PLACEHOLDERVALUE..._>) with your actual business details, including API endpoints, your target Slack Channel ID, the Manager Email for reports, and your Google Sheets Document ID and Sheet Name.


2. Set Environment Variables: Ensure sensitive tokens (like Google API Key, Facebook Access Token) referenced in the HTTP Request n8n nodes are stored as secure environment variables in your n8n installation.


3. Activate: Save the n8n workflow and click 'Activate' to enable the daily n8n trigger.

This complex n8n workflow leverages various specialized n8n node types:

Daily Schedule - 09:00 (Schedule Trigger n8n trigger):
Function: The primary n8n trigger, responsible for running the entire aggregation sequence daily at 9:00 AM.
Key Configuration: Runs on a fixed interval (daily) at the specified hour.
HTTP Request n8n node (x4 - Google, Facebook, Trustpilot, Yelp):
Function: Fetches the raw review data from each platform's API using dynamic query parameters (e.g., updatedafter, since) to only pull reviews from the last day.
Key Configuration: Uses expressions to dynamically retrieve API URLs from the 'Workflow Configuration' n8n node and passes authorization tokens via headers or query parameters.
Normalize All Reviews (Code n8n node):
Function: Essential for merging disparate data. This custom JavaScript n8n node identifies the source platform and maps the review fields (e.g., starRating, reviewtext, stars) to a unified set of output fields (platform, rating, text, reviewername).
Sentiment Analysis (GPT-4) (OpenAI n8n node):
Function: The core intelligence of the n8n workflow. It performs detailed sentiment analysis and structuring of the review data.
Key Configuration: Uses the gpt-4 model with detailed instructions specifying the required JSON output format (sentiment, sentiment score, mainissues, suggestedresponsetone).
Categorize & Parse AI Output (Code n8n node):
Function: Parses the JSON output from the AI and automatically assigns a business-relevant category (e.g., 'service', 'product', 'price') based on keyword analysis of the review text.
Check If Negative (If n8n node):
Function: Controls the flow path based on the AI output. If the sentiment field is 'negative', it triggers the immediate alert path.
Alert - Negative Review (Slack n8n node):
Function: Sends a formatted, urgent alert to a specific Slack channel, containing the summary, main issues, and suggested response tone, ensuring rapid team response.
Log Review to Sheet (Google Sheets n8n node):
Function: Appends the full normalized review data, alongside all AI-generated fields (sentiment score, category, summary), to the defined Google Sheets document for historical tracking and reporting.
Generate Weekly Summary (GPT-4) (OpenAI n8n node):
* Function: On Mondays, this second AI n8n node receives aggregated metrics and writes a high-level, actionable executive summary for management consumption.