Back to Data

Google Sheet Analytics MCP

MCP server using FastMCP with modular architecture: core mcp_server.py exposes tools interfacing with 3 services - scrapecreators_service.py (Facebook Ad Library API), media_cache_service.py (SQLite caching), & gemini_service.py (AI video analysis). Features intelligent batch processing, ~88% token savings, graceful rate limiting, secure env config, & persistent caching for robust Facebook ad research.

Last updated: 1/27/2026

Installation

Add this MCP to your configuration:

{
  "mcpServers": {
    "google-sheet-analytics-mcp": {
      // See GitHub repository for configuration
    }
  }
}