Get Started
Back to Templates

Monitor Google Maps Reviews with GPT-4o Sentiment Analysis & Telegram RAG Agent using Pinecone

Created by

Created by: Gtaras || tarasidis

Gtaras

Last update

Last update 10 hours ago

Categories

Share

Analyze and Sync Google Maps Reviews to Pinecone

Note: This template requires an Apify account, an OpenAI account, and a Pinecone database.

Overview

This workflow automates your reputation management by scraping Google Maps reviews, analyzing their sentiment using AI, and storing them in a Vector Database (Pinecone). It also includes a RAG (Retrieval-Augmented Generation) agent that allows you to chat with your review data via Telegram to ask specific questions about customer feedback.

How it works

  • Scrape: At a scheduled time (or manually), the workflow triggers an Apify actor to scrape the latest reviews from a specific Google Maps URL.
  • Analyze: It uses GPT-4o to analyze the sentiment of the reviews and generates a summary of complaints and praises.
  • Notify: A Telegram message is sent with the sentiment score and a summary of the latest reviews.
  • Store: The review data is embedded and upserted into a Pinecone Vector Store.
  • Chat (RAG): You can send messages to a Telegram bot to query the database (e.g., "What are people saying about our coffee?"). The AI retrieves relevant reviews from Pinecone to answer your question.
  • Cleanup: A weekly schedule cleans up the namespace to ensure data freshness (optional).

How to set up

  1. Apify: Create an account and subscribe to the Google Maps Reviews Scraper actor. Set up your Apify credentials in n8n.
  2. OpenAI: Set up your OpenAI credentials in n8n.
  3. Pinecone: Create an Index in Pinecone. Set up your Pinecone credentials in n8n.
  4. Telegram: Create a new bot via BotFather to get your Token and Chat ID. Set up your Telegram credentials in n8n.

Configure the Workflow

  1. Open the ⚠️ CONFIGURATION nodes.
  2. Paste your telegram_chat_id.
  3. Paste the Maps_url of the business you want to monitor.
  4. Define your pinecone_namespace.

HTTP Node Configuration

In the "Empty Namespace" node, update the URL to match your Pinecone Index Host and add your Pinecone API Key in the header or use credentials.

🙋 Support

If you encounter any issues during setup or have questions about customization, please reach out to our dedicated support email: [email protected]