Weekly App Review Pulse via MCP
Sends the generated weekly pulse note via Gmail for email delivery.
Creates and manages weekly pulse documents in Google Docs, delivering generated one-page pulse notes as structured documents.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Weekly App Review Pulse via MCPGenerate and send this week's app review pulse"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Weekly App Review Pulse via MCP
Automated system that ingests Google Play Store reviews for Groww, clusters them into themes and extracts verbatim quotes & action ideas using a LangChain AI Agent, generates a structured one-page weekly pulse note, and delivers it via Google Docs and Gmail using MCP (Model Context Protocol) servers.
Architecture Overview
Google Play Store
│
▼
[Layer 1: Scraper & Normalizer] ──► Cache: data/reviews/latest.json
│
▼
[Layer 2: LangChain AI Agent] ──► ThemeClustererTool, QuoteSelectorTool, ActionGeneratorTool
│
▼
[Layer 3: Pulse Generator] ──► Jinja2 Markdown & HTML rendering
│
▼
[Layer 4: MCP Delivery] ──► Google Docs MCP & Gmail MCPRelated MCP server: MCP Google Play Store Server
Project Structure
MCP-server/
├── doc/ # System documentation & specifications
├── src/
│ ├── __init__.py
│ ├── config.py # Environment & configuration loader
│ ├── scraper/ # Layer 1 — Play Store ingestion & normalization
│ ├── agent/ # Layer 2 — LangChain AI Agent & custom tools
│ │ └── tools/
│ ├── pulse/ # Layer 3 — Markdown/HTML template rendering
│ │ └── templates/
│ └── delivery/ # Layer 4 — MCP delivery (Docs & Gmail)
├── data/
│ └── reviews/ # Local review cache (gitignored)
├── config/
│ └── mcp_config.json # MCP server configurations
├── tests/ # Unit & integration test suite
├── .env.example # Environment template
├── .gitignore # Ignored secrets, cache, and virtualenvs
├── requirements.txt # Python dependencies
└── README.mdGetting Started
1. Prerequisites
Python 3.11+
Node.js (for running MCP servers via
npx)
2. Environment Setup
# Create and activate virtual environment
python3 -m venv .venv
source .venv/bin/activate
# Install dependencies
pip install -r requirements.txt
# Configure environment variables
cp .env.example .env3. Verification Commands (Phase 1)
# Verify config loading
python3 -c "from src.config import TARGET_APP_ID; print(TARGET_APP_ID)"
# Verify subpackages importability
python3 -c "import src, src.scraper, src.agent, src.agent.tools, src.pulse, src.delivery, tests; print('All packages imported successfully')"This server cannot be deployed
Maintenance
Related MCP Connectors
Analyze customer feedback at scale — reviews, surveys, calls. AI-powered themes and sentiment.
Stop drowning in app reviews: auto-reply on App Store & Google Play, on-brand, 100+ languages.
ReviewOracle - 8 review intel tools: sentiment, themes, competitors, response drafts.
G2, Trustpilot, Yelp reviews with sentiment and theme extraction across sources.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to fetch, analyze, and respond to Google Business Profile reviews with AI-generated replies through secure OAuth integration with Google's My Business API.8MIT
- AlicenseNot gradedqualityDmaintenanceIntegrates Google Play Store management tools with AI assistants to handle app listings, releases, and user reviews. It enables users to manage Play Console tasks like updating store information and retrieving performance statistics through natural language.26 npm10MIT
- AlicenseNot gradedqualityNot gradedmaintenanceAn app intelligence query engine that enables analysis of over 1 billion reviews from Google Play and the Apple App Store. It provides tools for sentiment analysis, keyword rankings, competitive comparisons, and time-series forecasting across 250,000+ apps.16 npm2-
- FlicenseNot gradedqualityDmaintenanceEnables automated ingestion of App Store/Play Store reviews, synthesis of themes and actions, and publishing to Google Docs and Gmail drafts via Google Workspace MCP.-