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]
