ziggy-mcp
Allows searching emails, automating outreach, and reading unread emails.
Enables calendar sync to track meetings and follow-ups using Google Calendar.
Provides tools for managing revenue tracking, lead pipeline, knowledge matrix, task management, and analytics through a Google Sheet backend.
Allows browser automation for job search, proposal submission, and account management on Upwork.
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., "@ziggy-mcp Show me my revenue dashboard"
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.
Ziggy MCP
A Model Context Protocol (MCP) server that connects Claude AI to Google Sheets for automated revenue tracking, lead management, and business operations.
Features
π Dashboard: Real-time revenue metrics and KPIs
π― Lead Pipeline: Track prospects from first contact to close
π§ Gmail Integration: Search emails and automate outreach
π Calendar Sync: Track meetings and follow-ups
π Knowledge Matrix: Development log with timestamp tracking
β Task Management: Prioritize and track project tasks
π Analytics: Daily metrics and performance tracking
Related MCP server: Revenue Engine MCP
Prerequisites
Node.js 18.0.0 or higher
Google Account with Sheets and Gmail access
Claude Desktop or compatible MCP client
Google Apps Script (for backend API)
Playwright (for browser automation)
Installation
1. Clone the Repository
git clone https://github.com/yourusername/ziggy-mcp.git
cd ziggy-mcp2. Install Dependencies
npm run setup
# This installs Node packages AND Playwright browsersManual alternative:
npm install
npx playwright install chromium3. Set Up Google Sheets Backend
Create a new Google Sheet
Go to Extensions > Apps Script
Delete any existing code
Copy all files from
/apps-scriptdirectory:Code.js- Sheet setup scriptAPI.js- Main API handlerscalendarSync.js- Calendar integrationappsscript.json- Manifest
Click Save (disk icon)
Click Run > setupRevenueEngine
Authorize the script when prompted
Wait 30-60 seconds for completion
Deploy as web app:
Click Deploy > New deployment
Type: Web app
Execute as: Me
Who has access: Anyone
Click Deploy
Copy the Web app URL
4. Configure the MCP Server
Edit index.js and update the API URL:
const API_URL = "YOUR_GOOGLE_APPS_SCRIPT_WEB_APP_URL";5. Connect to Claude Desktop
Add to your Claude Desktop config (~/Library/Application Support/Claude/claude_desktop_config.json on macOS):
{
"mcpServers": {
"ziggy": {
"command": "node",
"args": ["/absolute/path/to/ziggy-mcp/index.js"]
}
}
}Replace /absolute/path/to/ziggy-mcp/ with your actual installation path.
6. Restart Claude Desktop
Quit and reopen Claude Desktop to load the MCP server.
Browser Automation Setup
Setting Up Authenticated Sessions
For Upwork, LinkedIn, and other platforms:
Step 1: Open browser in visible mode
Open Upwork in browser with visible modeStep 2: I'll open a browser window - YOU log in manually
Step 3: Save the session
Save browser session as "upwork"Step 4: Test it
Browse upwork.com using saved sessionSupported Platforms
β Upwork - Job search, proposal submission
β LinkedIn - Profile research, connection requests
β Any website - Custom scraping and automation
Security Notes
Sessions stored locally in
sessions/folderNEVER commit session files to git
Sessions contain your auth tokens
Expire after ~30 days
Re-authenticate when needed
Usage
Basic Commands
Get Dashboard:
Show me my revenue dashboardView Pipeline:
What leads are in my pipeline?Add a Lead:
Add a new lead: Acme Corp, contact John Smith, email john@acme.comCheck Gmail:
Search my unread emailsLog Development Work:
Log to knowledge matrix: Fixed authentication bug in Gmail integration [45m]Knowledge Matrix
The Knowledge Matrix is a structured development log that tracks:
π Bugs & Fixes - Issues and resolutions
β¨ Features Added - New functionality
π§ͺ Testing Results - Test outcomes
π― Decisions & Direction - Strategic choices
π Documentation Updates - Doc changes
π Next Session Goals - Future work
Write Entry:
Write matrix entry for Bugs & Fixes: "3:45pm EST π[BUG-001] Fixed Gmail auth timeout [30m]"Query Matrix:
Search matrix for "authentication"Daily Summary:
Generate matrix summary for todayBrowser Automation
Take Screenshot:
Take a screenshot of competitor-site.comExtract Data:
Extract pricing from acme.com/pricingFill Form:
Fill the contact form at example.com with lead data for John DoeResearch:
Browse to linkedin.com/company/acme and extract company infoAutomated Outreach (after session setup):
Search Upwork for "web automation" jobs and show top 5Project Structure
ziggy-mcp/
βββ index.js # Main MCP server
βββ package.json # Node dependencies
βββ browser/ # Browser automation
β βββ playwright.js # Core browser functions
β βββ upwork.js # Upwork automation
β βββ linkedin.js # LinkedIn automation
βββ apps-script/ # Google Apps Script files
β βββ Code.js # Sheet setup
β βββ API.js # API endpoints
β βββ calendarSync.js # Calendar integration
β βββ appsscript.json # Manifest
βββ sessions/ # Saved browser sessions (gitignored)
βββ screenshots/ # Captured screenshots (gitignored)
βββ docs/ # Documentation
β βββ MATRIX.md # Knowledge Matrix guide
β βββ BUG-TRACKING.md # Bug tracking system
β βββ BROWSER-GUIDE.md # Browser automation guide
βββ README.md # This fileSecurity & Privacy
All data stored in your Google Sheets
API calls authenticated through Google Apps Script
No external databases or third-party services
File system access restricted to project directory
Gmail read-only access (send requires explicit approval)
Troubleshooting
MCP Server Not Connecting
Check Claude Desktop config path is correct
Verify Node.js version:
node --version(should be β₯18.0.0)Check console:
Cmd+Shift+Iin Claude DesktopVerify API_URL is set correctly in
index.js
Google Apps Script Issues
Ensure script is deployed as web app
Check execution permissions (should be "Anyone")
Re-authorize if needed: Run > setupRevenueEngine
Check Apps Script logs: View > Logs
Gmail Integration
Ensure Gmail API is enabled in Apps Script
Check OAuth scopes in
appsscript.jsonRe-authorize if permissions changed
Development
Running Locally
node index.jsManaging Apps Script
Install clasp for local Apps Script development:
npm install -g @google/clasp
clasp login
clasp pull # Download from Google
clasp push # Upload to GoogleDebugging
Enable debug logging in index.js:
const DEBUG = true;Logs written to debug.log in project directory.
Roadmap
Add Slack integration
Export reports to PDF
AI-powered lead scoring
Automated follow-up reminders
Invoice generation
Team collaboration features
Contributing
Fork the repository
Create a feature branch:
git checkout -b feature/amazing-featureCommit changes:
git commit -m 'Add amazing feature'Push to branch:
git push origin feature/amazing-featureOpen a Pull Request
License
MIT License - see LICENSE file for details
Support
π§ Email: support@example.com
π¬ Issues: GitHub Issues
π Docs: Wiki
Acknowledgments
Built with Model Context Protocol
Powered by Claude AI
Google Sheets integration via Apps Script
Made with β€οΈ for solopreneurs and small teams
Available Tools
13 toolsadd_leadC
Add a new lead to the pipeline
Inputs: companyName (required), notes, contactName, contactEmail, +1 more.
browse_pageB
Navigate to URL and return page content
Inputs: url (required), session.
get_dashboardB
Get current revenue dashboard with all key metrics
Inputs: no named parameters.
get_email_contentC
Get full content of an email thread
Inputs: threadId (required).
get_pipelineA
Get all leads in the pipeline
Inputs: no named parameters.
query_matrixC
Search Knowledge Matrix
Inputs: keyword (required).
read_fileB
Read file contents
Inputs: path (required).
save_browser_sessionD
Save browser session
Inputs: sessionName (required).
search_gmailC
Search Gmail inbox
Inputs: query, maxResults.
take_screenshotC
Capture screenshot of webpage
Inputs: url (required), filename.
update_leadC
Update an existing lead
Inputs: leadId (required), notes, status.
write_fileD
Write file contents
Inputs: path (required), content (required).
write_matrix_entryC
Write entry to Knowledge Matrix
Inputs: topic (required), content (required).
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelogβ¦
TDQS
Scored across 13 tools
Each tool targets a distinct resource and action: dashboard metrics vs. pipeline leads, Gmail search vs. email content, knowledge matrix write vs. query, and browser vs. file operations. No two tools appear to perform the same function, and their descriptions make the boundaries clear.
All tool names follow a consistent lower_snake_case verb_noun pattern, such as get_dashboard, add_lead, search_gmail, write_matrix_entry, and read_file. There are no mixed conventions, vague one-word names, or irregular verb styles.
With 13 tools, the count is well within a reasonable range for a multi-purpose assistant spanning CRM, email, knowledge, browser, and file domains. The set is broad but each tool earns its place, though the wide scope keeps it from feeling tightly focused.
Core workflows are covered for each domain, but there are notable gaps: no send/reply for Gmail, no delete/list for files or leads, and limited browser interaction beyond navigation and screenshots. Agents can complete basic tasks but may hit dead ends in fuller lifecycle workflows.
Maintenance
Related MCP Connectors
Create contacts, move deals, send proposals and invoices, read your inbox, from Claude or ChatGPT.
Connect an AI assistant to your Google Sheets, Drive, Docs, PDFs, BigQuery and Gmail.
GA4, Google Ads and Search Console in Claude. Read-only OAuth, multi-account for agencies.
Describe your business to Claude and it builds your cockpit: a custom work tool with its assistant.
Related MCP Servers
- -licenseNot gradedqualityNot gradedmaintenanceConnects Claude AI to GoHighLevel CRM, enabling comprehensive automation across 269+ tools including contact management, messaging, sales pipeline, appointments, marketing, and e-commerce operations.16 npm-
- AlicenseCqualityDmaintenanceConnects Claude AI to Google Sheets, Gmail, and Calendar for comprehensive revenue tracking and business management. Enables lead pipeline management, email handling, calendar scheduling, task tracking, and file operations through natural language.29MIT
- AlicenseNot gradedqualityDmaintenanceEnables Claude to manage Gmail, Google Calendar, and Google Drive, including sending emails, scheduling meetings, and organizing files, with integrated workflows.5MIT
- FlicenseCqualityDmaintenanceConnects Claude to ServiceTitan via API, providing 60 tools across CRM, Jobs, Accounting, and more for business management.601-