Skip to main content
Glama
Google Workspace MCP connector

Google Workspace MCP connector

by animesh-ex

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
GOOGLE_CLIENT_IDNoGoogle OAuth client ID, usable together with GOOGLE_CLIENT_SECRET instead of a credentials JSON file.
GOOGLE_CLIENT_SECRETNoGoogle OAuth client secret, usable together with GOOGLE_CLIENT_ID instead of a credentials JSON file.
GOOGLE_ADS_API_VERSIONNoOverrides the Google Ads API version used by the server.v26
GOOGLE_OAUTH_CREDENTIALSNoPath to a Google OAuth credentials file, as an alternative to placing credentials.json in the default directory.
GOOGLE_WORKSPACE_MCP_DIRNoDirectory where Google Workspace MCP stores credentials.json and token.json. Defaults to C:\Users\<you>\.google-workspace-mcp.
GOOGLE_ADS_DEVELOPER_TOKENNoGoogle Ads API developer token, required only for Google Ads tools. Can also be provided in ads.json via google_setup.
GOOGLE_ADS_LOGIN_CUSTOMER_IDNoGoogle 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

CapabilityDetails
tools
{
  "listChanged": true
}

Tools

Functions exposed to the LLM to take actions

NameDescription
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

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

TDQS

B3.1/5.0

Scored across 72 tools

Disambiguation4/5

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.

Naming Consistency4/5

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.

Tool Count2/5

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.

Completeness4/5

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.

Maintenance

ActivityMaintained
ResponsivenessNo recent community issues