Google Workspace MCP connector
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| GOOGLE_CLIENT_ID | No | Google OAuth client ID, usable together with GOOGLE_CLIENT_SECRET instead of a credentials JSON file. | |
| GOOGLE_CLIENT_SECRET | No | Google OAuth client secret, usable together with GOOGLE_CLIENT_ID instead of a credentials JSON file. | |
| GOOGLE_ADS_API_VERSION | No | Overrides the Google Ads API version used by the server. | v26 |
| GOOGLE_OAUTH_CREDENTIALS | No | Path to a Google OAuth credentials file, as an alternative to placing credentials.json in the default directory. | |
| GOOGLE_WORKSPACE_MCP_DIR | No | Directory where Google Workspace MCP stores credentials.json and token.json. Defaults to C:\Users\<you>\.google-workspace-mcp. | |
| GOOGLE_ADS_DEVELOPER_TOKEN | No | Google Ads API developer token, required only for Google Ads tools. Can also be provided in ads.json via google_setup. | |
| GOOGLE_ADS_LOGIN_CUSTOMER_ID | No | Google Ads manager (MCC) account ID used for Google Ads API access. Can also be provided in ads.json via google_setup. |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
Google connector: Gmail (search/read/send/reply/drafts/attachments/labels), Drive (search/organize/upload/download/share), Docs, Sheets and Slides (create/read/edit/analyze), Google Analytics 4 (ga_*: list properties, overview, custom reports, realtime, metadata) and Google Ads (ads_*: accounts, campaign/ad group/keyword/ad/search-term performance, GAQL queries, pause/enable, budgets). If a tool says the user is not signed in or is missing permissions, use google_setup (status, import_credentials, sign_in, configure_ads). Tools accept file IDs or full Google URLs. Confirm recipients and content with the user before sending email or sharing files, and confirm before any ads_set_status or ads_set_campaign_budget call because it changes ad spend.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| gmail_searchA | Search Gmail using Gmail query syntax (e.g. 'from:alice is:unread newer_than:7d', 'has:attachment subject:invoice'). Returns message headers and snippets. |
| gmail_read_messageB | Read a full email: headers, plain-text body, and attachment list (with attachmentIds). |
| gmail_read_threadB | Read every message in an email thread/conversation in order. |
| gmail_sendB | Send a new email. Supports cc/bcc, HTML bodies, and attachments from local files or Google Drive. |
| gmail_replyA | Reply (or reply-all) to an existing email, keeping it in the same thread. Supports attachments. |
| gmail_create_draftB | Create an email draft (not sent). Supports attachments. |
| gmail_list_draftsC | List email drafts. |
| gmail_send_draftC | Send an existing draft. |
| gmail_download_attachmentA | Download an email attachment to a local path, or save it straight into Google Drive. |
| gmail_modifyB | Organize messages: mark read/unread, star, archive, move to trash, or add/remove labels. Label names or IDs accepted. |
| gmail_list_labelsA | List Gmail labels (system and user). |
| gmail_create_labelC | Create a new Gmail label. |
| drive_searchB | Search Google Drive files by name/full text, type, or folder. Optionally pass a raw Drive 'q' query. |
| drive_list_folderB | List the contents of a Drive folder ('root' = My Drive). |
| drive_get_fileB | Get metadata for a Drive file (ID or URL). |
| drive_read_file_textA | Read a file's content as text: Google Docs (markdown), Sheets (CSV of first tab), Slides (text), or plain text/CSV/JSON files. |
| drive_create_folderC | Create a folder in Drive. |
| drive_upload_fileA | Upload a local file to Drive. Set convert=true to turn .docx/.xlsx/.csv/.pptx/.txt into native Google Docs/Sheets/Slides. |
| drive_download_fileA | Download a Drive file to a local folder. Google Docs/Sheets/Slides are exported (format: pdf, docx, xlsx, csv, pptx, txt, md, html). |
| drive_moveC | Move a file or folder into another folder. |
| drive_update_metadataB | Rename a file, change its description, or star/unstar it. |
| drive_copyB | Make a copy of a file (e.g. duplicate a template doc/sheet/deck). |
| drive_trashA | Move a file/folder to the Drive trash (recoverable for 30 days), or restore it. |
| drive_shareB | Share a file/folder (Doc, Sheet, Slides, anything) with a person, group, domain, or anyone with the link. |
| drive_list_permissionsC | List who a file is shared with. |
| drive_update_permissionB | Change a collaborator's role, or remove their access (role 'remove'). |
| drive_aboutA | Show the signed-in Google account and Drive storage usage. |
| docs_createB | Create a Google Doc, optionally with Markdown content (headings, bold/italic, links, bullet & numbered lists, code) and in a given Drive folder. |
| docs_readA | Read a Google Doc. format 'markdown' returns readable text; 'structured' returns each paragraph/table with its start/end index (needed for precise edits). |
| docs_insert_markdownB | Append Markdown content to the end of a Doc, or insert it at a specific index (from docs_read structured). |
| docs_replace_textB | Find and replace text throughout a Doc (e.g. fill {{placeholders}} in a template). |
| docs_delete_rangeB | Delete content between two indices (get indices from docs_read structured). |
| docs_insert_tableB | Insert a table filled with data (first row = header, bolded) at the end of a Doc or at an index. |
| docs_insert_imageC | Insert an image from a public URL into a Doc. |
| docs_batch_updateB | Advanced: send raw Google Docs API batchUpdate requests (for styling, page breaks, headers, etc.). |
| sheets_createC | Create a Google Sheet with optional tab names and initial data for the first tab. |
| sheets_get_infoA | List a spreadsheet's tabs with their sizes, plus title and URL. |
| sheets_readC | Read values from a range in A1 notation, e.g. 'Sheet1!A1:D50' or just 'Sheet1' for the whole tab. |
| sheets_writeB | Write values to a range (starting cell like 'Sheet1!B2' is enough). Formulas like '=SUM(A1:A9)' are evaluated. |
| sheets_append_rowsB | Append rows after the last row of data in a tab. |
| sheets_clearB | Clear the values in a range (formatting is kept). |
| sheets_manage_tabC | Add, rename, duplicate or delete a tab. |
| sheets_formatC | Format a range on one tab: bold, colors, number format (e.g. '$#,##0.00', '0.0%', 'yyyy-mm-dd'), alignment, borders. |
| sheets_add_chartC | Add a chart (column, bar, line, area, pie, scatter) built from a data range on a tab. |
| sheets_analyzeA | Analyze a table in a range (first row = headers): per-column type, count, blanks, distinct values, and for numeric columns sum/mean/median/min/max/stdev; top values for text columns. Optional group-by summary. |
| sheets_batch_updateB | Advanced: send raw Sheets API batchUpdate requests (conditional formatting, filters, pivot tables, etc.). |
| slides_createB | Create a Google Slides presentation, optionally with slides (layout, title, bullets, two columns, speaker notes, images). |
| slides_readA | Read a presentation: every slide's text (by placeholder), tables, image count, and speaker notes. |
| slides_add_slidesB | Add one or more slides to an existing presentation (at the end or at a 0-based position). |
| slides_replace_textB | Find and replace text across all slides (or only some), e.g. fill {{placeholders}} in a template deck. |
| slides_set_textA | Replace all text inside one shape/text box (objectId from slides_read). |
| slides_set_notesC | Set the speaker notes of a slide. |
| slides_add_imageB | Place an image (public URL) on a slide. Position/size in points (deck is usually 720×405 pt). |
| slides_add_text_boxC | Add a text box to a slide. Position/size in points. |
| slides_manage_slideC | Delete, duplicate, or move a slide. |
| slides_get_thumbnailA | Get a PNG thumbnail URL of a slide (to visually check it). |
| slides_batch_updateB | Advanced: send raw Google Slides API batchUpdate requests (shapes, tables, styling, etc.). |
| ga_list_propertiesA | List the Google Analytics 4 accounts and properties this Google account can access (with property IDs). |
| ga_overviewB | Quick GA4 performance summary: users, new users, sessions, engagement rate, avg session duration, views, key events (conversions) and revenue, broken down by a chosen dimension. |
| ga_run_reportB | Run a custom GA4 report with any dimensions/metrics (see ga_get_metadata for names). Supports filters, ordering, comparison of two date ranges. |
| ga_realtimeB | GA4 realtime report (last 30 minutes): active users by a dimension such as country, unifiedScreenName, deviceCategory. |
| ga_get_metadataA | List the dimensions and metrics available for a GA4 property (including custom ones). Optional search text filters the list. |
| ads_list_accountsA | List Google Ads accounts this Google login can access (IDs, names, currency, whether each is a manager), including client accounts under managers. |
| ads_queryA | Run any read-only GAQL query against a Google Ads account (e.g. SELECT campaign.name, metrics.clicks FROM campaign WHERE segments.date DURING LAST_7_DAYS). Money fields ending in _micros are returned in currency units. |
| ads_campaign_performanceB | Campaign performance for a date range: status, type, daily budget, impressions, clicks, CTR, avg CPC, cost, conversions, conversion value, cost/conversion and ROAS. |
| ads_ad_group_performanceC | Ad group performance for a date range, optionally within one campaign. |
| ads_keyword_performanceB | Search keyword performance with match type and quality score. |
| ads_search_termsB | Search terms report: the actual queries that triggered ads, with cost and conversions (find wasted spend and new keywords). |
| ads_ad_performanceC | Ad-level performance including responsive search ad headlines/descriptions. |
| ads_set_statusA | Pause or enable campaigns, ad groups, ads or keywords. ENABLED resumes spending. Use validateOnly=true to dry-run. Always confirm with the user first. |
| ads_set_campaign_budgetA | Change a campaign's daily budget (in account currency). Shared budgets affect every campaign using them. Use validateOnly=true to dry-run. Always confirm the amount with the user first. |
| google_setupA | Set up or check the Google connection. Actions: 'status' (what's configured), 'import_credentials' (copy a downloaded Desktop-app OAuth client JSON into place; omit path to use the newest client_secret_*.json in Downloads), 'sign_in' (opens the browser for Google consent and waits up to 5 minutes), 'sign_out' (deletes the saved token), 'configure_ads' (save a Google Ads developer token and optional manager account ID). |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 72 tools
Product-prefixed namespaces (gmail_, drive_, docs_, sheets_, slides_, ga_, ads_) plus action-specific suffixes make almost every tool clearly distinguishable, e.g. gmail_send vs gmail_send_draft vs gmail_reply. The only soft overlaps are the generic drive_read_file_text versus the per-product readers (sheets_read, docs_read, slides_read), and the three *_batch_update raw-API escape hatches which sit near their specific counterparts, but the descriptions explicitly frame these as advanced/generic alternatives.
The set follows a very predictable <product>_<verb>_<object> snake_case convention (drive_get_file, sheets_append_rows, slides_set_notes, ads_set_status). A few tools deviate by using noun-only or adjectival forms (ga_overview, drive_about, google_setup, ads_query), which breaks the pattern slightly without hurting readability.
72 tools is far beyond what an agent can hold in working context, and the surface is heavy even though it is justified by bundling seven distinct Google products. Each individual domain is reasonably scoped (5-17 tools), but the aggregate volume forces selection errors and bloats every prompt.
Per-product lifecycle coverage is strong: Gmail spans search/read/thread/send/reply/drafts/attachments/labels/modify, Drive covers the full file and sharing lifecycle, and Docs/Sheets/Slides each offer create, read, edit, formatting, and raw batchUpdate escape hatches. Gaps remain at the edges — no Google Calendar/Contacts/Tasks surface despite 'Workspace' branding, no label deletion, and Ads is read-plus-status/budget only with no campaign creation.