Get Started
Back to Templates

Review Aggregator and AI Alerts for Google, Facebook, Trustpilot, and Yelp

Created by

Created by: Țugui Dragoș || tuguidragos

Țugui Dragoș

Last update

Last update 2 hours ago

Categories

Share

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

  1. 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.

  2. Set Up Environment Variables:

    • Add all API keys, tokens, and configuration values in the Workflow Configuration node or as n8n credentials.

  3. Google Sheet Setup:

    • Create a Google Sheet with columns for review data and share it with your service account email.

  4. Slack Channel:

    • Set up a Slack channel for alerts and add the webhook URL in the configuration.

  5. 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.