Provides integration with Google services, particularly Google Sheets and Apps Script, for updating KPI reports, managing spreadsheets, and supporting reporting workflows.
Allows reading CSV files from Google Drive, including downloading and parsing large Shopee report files from a specified Drive folder.
Provides tools for finding and parsing Shopee commission and click CSV reports, filtering by date and Sub ID, and refreshing daily KPI reports in Google Sheets.
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., "@Apps Script + Sheets + Shopee CSV MCP อ่านไฟล์ Shopee Commission ล่าสุด แล้วอัปเดต Daily Report ในชีต"
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.
Adds a mobile-friendly Web Tool / Chat console on top of v4.4 Full Apps Script Control.
https://YOUR-RENDER-SERVICE.onrender.com/tool
Features:
Beautiful responsive chat-style UI for mobile/desktop
Apps Script project browser
Read/edit/create .gs, .html, and appsscript.json
Automatic backup version before code writes
Create Apps Script projects
Create versions and inspect deployments
Optional Gemini-powered natural-language commands directly from the web page
Existing MCP, Google OAuth, Sheets, Drive and Shopee tools remain available
Related MCP server: MCP Google Drive Server
WEB_ADMIN_TOKEN=<generate a long random secret>Use that token to sign in to /tool.
For free-text AI chat also add:
GEMINI_API_KEY=<your Google AI Gemini API key>
GEMINI_MODEL=gemini-2.5-flashIf you want the Web Tool to manage any Apps Script project accessible to the connected Google account:
SCRIPT_ACCESS_MODE=allKeep all existing OAuth/MCP/Sheets/Shopee environment variables from v4.4.
Never expose WEB_ADMIN_TOKEN, GEMINI_API_KEY, Google refresh token, or Spark OAuth secrets.
The web UI stores WEB_ADMIN_TOKEN in browser localStorage on the device used to sign in.
Code writes create a backup Apps Script version first.
SCRIPT_ACCESS_MODE=all is powerful: the server can modify any Apps Script project available to the authorized Google account.
Upload all files in this package over the existing GitHub repository.
Commit and let Render auto-deploy.
Add WEB_ADMIN_TOKEN in Render Environment.
Optional: add GEMINI_API_KEY.
Confirm / returns version 4.5.0.
Open /tool.
This server cannot be deployed
SEO & marketing toolkit for AI agents: GA4, Search Console, AdSense, GTM, PageSpeed, Trends.
Connect AI assistants to Google Sheets through controlled tools for reading and updating rows.
Connect Google Analytics to ChatGPT. Query GA4 data in plain English and get instant insights.
AI marketing agent for Google Ads, Meta, GA4, TikTok, LinkedIn, Shopify, HubSpot and more.
