Google Workspace MCP Server

The Google Workspace MCP server provides tools for Google Sheets, Gmail, Calendar, and Drive.

There are two ways to connect:

• Option A - Quick connect (when available in your deployment): sign in with your Google account and you're done. No Google Cloud project needed, but a subset of tools is limited (see below).
• Option B - Your own OAuth app: bring your own Google Cloud project and OAuth credentials. Full access to all 14 tools.

Option A - Quick connect (when available in your deployment)

If your deployment offers Quick connect, this is the fastest path:

1. Go to Settings > MCP Servers > Add Server.
2. Select Google Workspace and choose the quick-connect option - no Client ID or Client Secret is required.
3. Click Connect Google Account, sign in, and approve the consent screen.
4. On success, the server shows a green Connected badge with the authorized email address.

Quick connect requests a lighter set of Google permissions, so a few tools behave differently:

• Not available: gmail_search, gmail_read, gmail_get_attachment (reading email requires your own OAuth app). Sending email with gmail_send works.
• Drive limited: drive_list_files and drive_download only see files created through FlowTrux (e.g., via drive_upload or sheets_create) - not your whole Drive.

Sheets and Calendar tools work in full. If you need Gmail reading or full Drive access, use Option B instead.

Option B - Your own OAuth app

1. Create a Google Cloud Project

1. Go to Google Cloud Console.
2. Create a new project (or use an existing one).
3. Enable the following APIs:

• Google Sheets API
• Gmail API
• Google Calendar API
• Google Drive API

2. Create OAuth Credentials

1. Go to APIs & Services > Credentials.
2. Click Create Credentials > OAuth 2.0 Client ID.
3. Select Web application as the application type.
4. Add an authorized redirect URI:

   https://<your-domain>/api/auth/google-workspace/callback
   

5. Copy the Client ID and Client Secret.

3. Configure in FlowTrux

1. Go to Settings > MCP Servers > Add Server.
2. Select Google Workspace.
3. Enter the Client ID and Client Secret.
4. Click Save.

4. Connect Your Google Account

After saving the credentials:

1. A Connect Google Account button appears on the server configuration.
2. Click it to open Google's consent screen.
3. Authorize FlowTrux to access Sheets, Gmail, Calendar, and Drive.
4. On success, you are redirected back to FlowTrux and the server shows a green Connected badge with the authorized email address.

The refresh token is stored encrypted in the database. Google's OAuth library handles automatic token refresh.

Assign to a Workspace

Whichever option you used, assign the server to a workspace so workflows can use it:

1. Go to Settings > Workspaces > Edit.
2. Enable google-workspace under MCP Servers.
3. Click Save.

Reconnecting

If the connection expires or you need to switch Google accounts, click the Reconnect button on the server configuration in Settings.

Tools

Google Sheets

sheets_read

Read data from a spreadsheet range.

sheets_write

Write or overwrite data in a range.

sheets_append

Append rows to the end of a range.

sheets_create

Create a new spreadsheet.

Gmail

gmail_send

Send an email with optional file attachments.

Attachment object:

Example with attachment:

{
  "to": "candidate@example.com",
  "subject": "Your Offer Letter",
  "body": "Please find attached your offer letter.",
  "attachments": [
    {
      "filename": "offer-letter.pdf",
      "mimeType": "application/pdf",
      "content": "JVBERi0xLjQK..."
    }
  ]
}

gmail_search

Search emails using Gmail search syntax. Own OAuth app only - not available with Quick connect.

gmail_read

Read a specific email by ID. Returns body text and attachment metadata. Own OAuth app only - not available with Quick connect.

Response includes an attachments array with metadata for each attached file:

gmail_get_attachment

Download a specific attachment from an email as base64-encoded content. Own OAuth app only - not available with Quick connect.

Google Calendar

calendar_list_events

List upcoming events.

calendar_create_event

Create a calendar event.

calendar_delete_event

Delete a calendar event.

Google Drive

With Quick connect, Drive tools only see files created through FlowTrux; full-Drive access requires your own OAuth app.

drive_list_files

List files in Drive.

drive_upload

Upload a text file to Drive.

drive_download

Download file content.

Example Workflow

A reporting workflow that writes results to a Google Sheet:

1. Trigger - Cron schedule (weekly on Monday)
2. Action - HTTP request to fetch analytics data
3. Agent - Analyze data and format as rows, tools: google-workspace:sheets_append
4. The agent appends the weekly metrics to an existing spreadsheet.