Monitor Google Maps reviews with sentiment analysis & RAG agent using Pinecone

Description

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
Apify: Create an account and subscribe to the Google Maps Reviews Scraper actor. Set up your Apify credentials in n8n.
OpenAI: Set up your OpenAI credentials in n8n.
Pinecone: Create an Index in Pinecone. Set up your Pinecone credentials in n8n.
Telegram: Create a new bot via BotFather to get your Token and Chat ID. Set up your Telegram credentials in n8n.

Configure the Workflow
Open the ⚠️ CONFIGURATION nodes.
Paste your telegram_chat_id.
Paste the Maps_url of the business you want to monitor.
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]