Interactive reference for the complete MCP tool inventory — data sources, use cases, blockers, and connections.
"What meetings do I have this week?"
Calendar"Show me the open tasks for [client name] in ClickUp"
ClickUp"What are the most recent chat messages on [client name] list in ClickUp?"
ClickUp"Find the most recent document in Drive about [client name]"
DriveHow to read this
Task & project management
List all workspaces with member roster
workspace ID, 117 members, roles, emails
Seat allocation info
List spaces in workspace
16 spaces, statuses, features
Single space detail
Space config, features, statuses
Lists from folder or space
125 client lists, task counts, assignees, dates
Lists not inside folders
Same as get_lists (redundant here)
Single list with statuses and inbound email
List detail, statuses, inbound_address
Tasks from a list with custom fields
Tasks, custom fields (*Brand Manager, *Package, *Marketplaces), assignees, status, dates
Full task with attachments
Everything in get_tasks + attachments array
Comments on a task
Rich text, @mentions, reply counts
Comments on a list (usually empty)
List-level comments
Chat messages per client list — richest team comms source
Chat messages, timestamps, authors
Replies to a comment
List workspace documents
Doc list with parent types, cursor pagination
Full document as markdown
Markdown content
Individual document pages with metadata
Page content (markdown), name, authors, dates, order_index
Search documents by query
Delete a checklist (write — unused)
Delete a comment (write — unused)
Delete a folder (write — unused)
Delete a list (write — unused)
CRM — contacts, companies, deals
Token info, portal, account details
userId, portalId, scopes, timezone, currency (GBP)
Advanced filtered search across CRM objects
Companies, contacts, deals — filtered results with properties
Paginated list by object type
Companies (skeleton), contacts (mixed sample+real), deals (real £ amounts), tickets (empty)
Bulk property reads by ID
Specified properties per object (most null for companies)
Relationship types between objects
Association types (e.g. company→contact)
List associations for an object
List all properties for an object type
Single property definition
Generate HubSpot UI URLs
Custom object schemas
Automation workflows
Single workflow detail
Engagement records (calls, emails, meetings)
Shared inbox — client email threads
Full-text search with inbox:/from:/quoted operators
Conversations: id, subject, status, assignee, tags, last_message_at
List inbox conversations with flattened messages
Conversations + message previews per inbox
Full message thread for a conversation
Messages: author, recipients, text, timestamps
Google Calendar — meetings & Gemini Notes
Calendars visible to ai@sitruna.com
2 calendars (primary + holidays)
Events with attendees, times, location; attachments via fields param
Summary, start/end, attendees, location, htmlLink + optional attachments/conferenceData
Free-text search across event fields
Matching events across all team calendars
Single event detail
Current time in timezone
Free/busy information
Calendar colour definitions
Account management
Create a calendar event (write)
Bulk event creation (write)
Update an event (write)
Delete an event (write)
Accept/decline/tentative (write)
Google Drive — Gemini Notes & docs
Search Drive files (MCP broken; Connector works for Stephen)
Amazon performance — sales, ads, P&L
List all connected stores and retrieve their IDs
Channel ID, Merchant ID, store name, marketplace, country
Cross-channel sales summary
Sales, orders, units, AOV, conversion rate, out-of-stock % — vs prior
Sales trend over time for one store
Time-series: sales, orders, units, AOV, conversion — vs prior
Amazon Vendor PO revenue over time (Vendor only)
Ordered revenue, shipped revenue, COGS, ad spend per time bucket
Advertising performance scorecard across all channels
Impressions, clicks, spend, ad sales, ROAS, ACOS, CTR, CPC — vs prior
Quick P&L for one store — no polling needed
P&L summary: gross sales, fees, shipping, ad spend, net profit
P&L broken down to individual SKU
Revenue, fees, costs, net margin per SKU — paginated
Convert dates to the format reports require
Numeric timestamps + human-readable date confirmations
Check if an async report is ready
Status (processing/done/errored) + download URL when done
AI plain-English narrative of any completed report (lossy)
Key trends, anomalies, and recommended actions (AI narrative)
360° product scorecard (async)
Sales, units, price, ad spend, ACOS, TACOS, inventory, buy box, BSR — vs prior
Ad spend and results by product (async)
Ad sales, spend, ACOS, impressions, clicks, CTR, CPC per ASIN
Shipped revenue and margins (Vendor only, async)
Shipped revenue, COGS, units, margin %, net PPM per ASIN — vs prior
Enterprise SKU deep dive (async)
Detailed product data for selected SKUs (Enterprise plan only)
Full channel P&L with comparison (async)
Gross sales → fees → shipping → ad spend → net profit — vs prior
Campaign-by-campaign ad performance (async)
Campaign name, type, status, spend, ROAS, ACOS, impressions, clicks
Amazon Buy Box win/loss status (Seller only, async)
Products by Buy Box status (winning/losing/losing to Amazon)
Customer cohort lifetime value (async)
LTV, CAC, LTV:CAC ratio, repeat rate, purchase frequency per cohort
Repeat vs new buyer split by product (async)
Repeat rate %, new vs repeat count, sales split, avg spend per ASIN
Returns, refunds, cancellations (async)
Cancellation and refund breakdown by product — vs prior
Stock health check with over/understock flags (async)
Inventory levels, days of cover, health classification per product — vs prior
FBA restock forecast (Seller only, async)
Available/inbound/reserved units, demand, days cover, restock qty, storage costs
Listings hidden by the marketplace (async)
Suppressed products with suppression reason
Page views and listing conversion rates (async)
Page views, sessions, units, conversion rate, buy box % — vs prior
Amazon Subscribe & Save metrics (Seller only, async)
S&S enrollment, recurring revenue, subscription metrics — vs prior
Amazon Vendor consumer demand by product (Vendor only, async)
Glance views, ordered units, revenue, avg price, conversion per ASIN — vs prior
MCP version of Drive search doesn't work; only Desktop Connector works. Blocks: Client Goal Briefing, Missing Action Audit, Negative Sentiment detection.
*Brand Manager, *Package, *Marketplaces fields not filled consistently across all clients. Blocks: Client Profitability Check, precise connection matching.
Company records are skeleton-filled; only name present. Blocks: Sales Handover detail, KYC Audit validation.
Calendar create/update/delete events only defined; not working. Blocks: Phase 4 automation (alerts, scheduled tasks).
These are the linkages between data sources — how identifiers in one system can be used to query another.
ClickUp list name ↔ HubSpot company name (casing inconsistent)
ClickUp list name → Front inbox-scoped search query
ClickUp *Brand Manager field → Calendar event attendee email
ClickUp *Marketplaces custom field → Merchant Spring channel name
Calendar attachment fileId → Drive document (Workaround: Stephen's Drive Connector can read Gemini Notes directly)
ClickUp *Package field ↔ HubSpot deal amount
Front conversation assignee → ClickUp task assignee