Get the FREE Ultimate OpenClaw Setup Guide →

outlook-automation

npx machina-cli add skill davepoon/buildwithclaude/outlook-automation --openclaw
Files (1)
SKILL.md
7.4 KB

Outlook Automation via Rube MCP

Automate Microsoft Outlook operations through Composio's Outlook toolkit via Rube MCP.

Toolkit docs: composio.dev/toolkits/outlook

Prerequisites

  • Rube MCP must be connected (RUBE_SEARCH_TOOLS available)
  • Active Outlook connection via RUBE_MANAGE_CONNECTIONS with toolkit outlook
  • Always call RUBE_SEARCH_TOOLS first to get current tool schemas

Setup

Get Rube MCP: Add https://rube.app/mcp as an MCP server in your client configuration. No API keys needed — just add the endpoint and it works.

  1. Verify Rube MCP is available by confirming RUBE_SEARCH_TOOLS responds
  2. Call RUBE_MANAGE_CONNECTIONS with toolkit outlook
  3. If connection is not ACTIVE, follow the returned auth link to complete Microsoft OAuth
  4. Confirm connection status shows ACTIVE before running any workflows

Core Workflows

1. Search and Filter Emails

When to use: User wants to find specific emails across their mailbox

Tool sequence:

  1. OUTLOOK_SEARCH_MESSAGES - Search with KQL syntax across all folders [Required]
  2. OUTLOOK_GET_MESSAGE - Get full message details [Optional]
  3. OUTLOOK_LIST_OUTLOOK_ATTACHMENTS - List message attachments [Optional]
  4. OUTLOOK_DOWNLOAD_OUTLOOK_ATTACHMENT - Download attachment [Optional]

Key parameters:

  • query: KQL search string (from:, to:, subject:, received:, hasattachment:)
  • from_index: Pagination start (0-based)
  • size: Results per page (max 25)
  • message_id: Message ID (use hitId from search results)

Pitfalls:

  • Only works with Microsoft 365/Enterprise accounts (not @hotmail.com/@outlook.com)
  • Pagination relies on hitsContainers[0].moreResultsAvailable; stop only when false
  • Use hitId from search results as message_id for downstream calls, not resource.id
  • Index latency: very recent emails may not appear immediately
  • Inline images appear as attachments; filter by mimetype for real documents

2. Query Emails in a Folder

When to use: User wants to list emails in a specific folder with OData filters

Tool sequence:

  1. OUTLOOK_LIST_MAIL_FOLDERS - List mail folders to get folder IDs [Prerequisite]
  2. OUTLOOK_QUERY_EMAILS - Query emails with structured filters [Required]

Key parameters:

  • folder: Folder name ('inbox', 'sentitems', 'drafts') or folder ID
  • filter: OData filter (e.g., isRead eq false and importance eq 'high')
  • top: Max results (1-1000)
  • orderby: Sort field and direction
  • select: Array of fields to return

Pitfalls:

  • QUERY_EMAILS searches a SINGLE folder only; use SEARCH_MESSAGES for cross-folder search
  • Custom folders require folder IDs, not display names; use LIST_MAIL_FOLDERS
  • Always check response['@odata.nextLink'] for pagination
  • Cannot filter by recipient or body content; use SEARCH_MESSAGES for that

3. Manage Calendar Events

When to use: User wants to list, search, or inspect calendar events

Tool sequence:

  1. OUTLOOK_LIST_EVENTS - List events with filters [Optional]
  2. OUTLOOK_GET_CALENDAR_VIEW - Get events in a time window [Optional]
  3. OUTLOOK_GET_EVENT - Get specific event details [Optional]
  4. OUTLOOK_LIST_CALENDARS - List available calendars [Optional]
  5. OUTLOOK_GET_SCHEDULE - Get free/busy info [Optional]

Key parameters:

  • filter: OData filter (use start/dateTime, NOT receivedDateTime)
  • start_datetime/end_datetime: ISO 8601 for calendar view
  • timezone: IANA timezone (e.g., 'America/New_York')
  • calendar_id: Optional non-primary calendar ID
  • select: Fields to return

Pitfalls:

  • Use calendar event properties only (start/dateTime, end/dateTime), NOT email properties (receivedDateTime)
  • Calendar view requires start_datetime and end_datetime
  • Recurring events need expand_recurring_events=true to see individual occurrences
  • Decline status is per-attendee via attendees[].status.response

4. Manage Contacts

When to use: User wants to list, create, or organize contacts

Tool sequence:

  1. OUTLOOK_LIST_CONTACTS - List contacts [Optional]
  2. OUTLOOK_CREATE_CONTACT - Create a new contact [Optional]
  3. OUTLOOK_GET_CONTACT_FOLDERS - List contact folders [Optional]
  4. OUTLOOK_CREATE_CONTACT_FOLDER - Create contact folder [Optional]

Key parameters:

  • givenName/surname: Contact name
  • emailAddresses: Array of email objects
  • displayName: Full display name
  • contact_folder_id: Optional folder for contacts

Pitfalls:

  • Contact creation supports many fields but only givenName or surname is needed

5. Manage Mail Folders

When to use: User wants to organize mail folders

Tool sequence:

  1. OUTLOOK_LIST_MAIL_FOLDERS - List top-level folders [Required]
  2. OUTLOOK_LIST_CHILD_MAIL_FOLDERS - List subfolders [Optional]
  3. OUTLOOK_CREATE_MAIL_FOLDER - Create a new folder [Optional]

Key parameters:

  • parent_folder_id: Well-known name or folder ID
  • displayName: New folder name
  • include_hidden_folders: Show hidden folders

Pitfalls:

  • Well-known folder names: 'inbox', 'sentitems', 'drafts', 'deleteditems', 'junkemail', 'archive'
  • Custom folder operations require the folder ID, not display name

Common Patterns

KQL Search Syntax

Property filters:

  • from:user@example.com - From sender
  • to:recipient@example.com - To recipient
  • subject:invoice - Subject contains
  • received>=2025-01-01 - Date filter
  • hasattachment:yes - Has attachments

Combinators:

  • AND - Both conditions
  • OR - Either condition
  • Parentheses for grouping

OData Filter Syntax

Email filters:

  • isRead eq false - Unread emails
  • importance eq 'high' - High importance
  • hasAttachments eq true - Has attachments
  • receivedDateTime ge 2025-01-01T00:00:00Z - Date filter

Calendar filters:

  • start/dateTime ge '2025-01-01T00:00:00Z' - Events after date
  • contains(subject, 'Meeting') - Subject contains text

Known Pitfalls

Account Types:

  • SEARCH_MESSAGES requires Microsoft 365/Enterprise accounts
  • Personal accounts (@hotmail.com, @outlook.com) have limited API access

Field Confusion:

  • Email properties (receivedDateTime) differ from calendar properties (start/dateTime)
  • Do NOT use email fields in calendar queries or vice versa

Quick Reference

TaskTool SlugKey Params
Search emailsOUTLOOK_SEARCH_MESSAGESquery, from_index, size
Query folderOUTLOOK_QUERY_EMAILSfolder, filter, top
Get messageOUTLOOK_GET_MESSAGEmessage_id
List attachmentsOUTLOOK_LIST_OUTLOOK_ATTACHMENTSmessage_id
Download attachmentOUTLOOK_DOWNLOAD_OUTLOOK_ATTACHMENTmessage_id, attachment_id
List foldersOUTLOOK_LIST_MAIL_FOLDERS(none)
Child foldersOUTLOOK_LIST_CHILD_MAIL_FOLDERSparent_folder_id
List eventsOUTLOOK_LIST_EVENTSfilter, timezone
Calendar viewOUTLOOK_GET_CALENDAR_VIEWstart_datetime, end_datetime
Get eventOUTLOOK_GET_EVENTevent_id
List calendarsOUTLOOK_LIST_CALENDARS(none)
Free/busyOUTLOOK_GET_SCHEDULEschedules, times
List contactsOUTLOOK_LIST_CONTACTStop, filter
Create contactOUTLOOK_CREATE_CONTACTgivenName, emailAddresses
Contact foldersOUTLOOK_GET_CONTACT_FOLDERS(none)

Powered by Composio

Source

git clone https://github.com/davepoon/buildwithclaude/blob/main/plugins/all-skills/skills/outlook-automation/SKILL.mdView on GitHub

Overview

Automate Outlook tasks across emails, calendar, contacts, folders, and attachments using Composio's Outlook toolkit via Rube MCP. This requires an active Outlook connection and that you always call RUBE_SEARCH_TOOLS first to fetch current tool schemas.

How This Skill Works

The skill orchestrates Outlook toolkit calls through Rube MCP. Start by verifying RUBE_SEARCH_TOOLS to fetch current schemas, then establish an Outlook connection with RUBE_MANAGE_CONNECTIONS (completing OAuth if prompted). You can run core workflows like searching emails, querying a folder, managing calendar events, and listing or downloading attachments.

When to Use It

  • Search and filter emails across the mailbox using KQL (Search and Filter Emails).
  • Query emails within a specific folder using OData filters (Query Emails in a Folder).
  • Manage calendar events: list, view, or inspect events (Manage Calendar Events).
  • List attachments from a message and download them (Attachment workflows).
  • Discover folders/calendars and fetch scheduling data such as free/busy info (Folder/Calendar navigation and Schedule).

Quick Start

  1. Step 1: Verify RUBE_SEARCH_TOOLS responds to confirm Rube MCP availability.
  2. Step 2: Call RUBE_MANAGE_CONNECTIONS with toolkit outlook and complete Microsoft OAuth if prompted.
  3. Step 3: Ensure the connection status shows ACTIVE before running any workflows.

Best Practices

  • Always call RUBE_SEARCH_TOOLS first to get current tool schemas.
  • Use the hitId from search results as message_id for downstream calls.
  • For cross-folder search, prefer SEARCH_MESSAGES rather than QUERY_EMAILS.
  • Be aware of Microsoft 365/Enterprise account limitations; consumer accounts may not work.
  • Handle pagination with @odata.nextLink and hitsContainers[0].moreResultsAvailable; limit per page to 25 results.

Example Use Cases

  • Find invoices with attachments in Inbox and download them.
  • List unread emails in a specific folder and sort by date.
  • Generate a calendar view for the next week across calendars for scheduling.
  • Download a receipt attachment from a purchase confirmation email.
  • Enumerate all folders to locate project emails, then run a cross-folder search.

Frequently Asked Questions

Add this skill to your agents

Related Skills

email-sequence

coreyhaines31/marketingskills

When the user wants to create or optimize an email sequence, drip campaign, automated email flow, or lifecycle email program. Also use when the user mentions "email sequence," "drip campaign," "nurture sequence," "onboarding emails," "welcome sequence," "re-engagement emails," "email automation," "lifecycle emails," "trigger-based emails," "email funnel," "email workflow," "what emails should I send," "welcome series," or "email cadence." Use this for any multi-email automated flow. For cold outreach emails, see cold-email. For in-app onboarding, see onboarding-cro.

cold-email

coreyhaines31/marketingskills

Write B2B cold emails and follow-up sequences that get replies. Use when the user wants to write cold outreach emails, prospecting emails, cold email campaigns, sales development emails, or SDR emails. Also use when the user mentions "cold outreach," "prospecting email," "outbound email," "email to leads," "reach out to prospects," "sales email," "follow-up email sequence," "nobody's replying to my emails," or "how do I write a cold email." Covers subject lines, opening lines, body copy, CTAs, personalization, and multi-touch follow-up sequences. For warm/lifecycle email sequences, see email-sequence. For sales collateral beyond emails, see sales-enablement.

activecampaign-automation

davepoon/buildwithclaude

Automate ActiveCampaign tasks via Rube MCP (Composio): manage contacts, tags, list subscriptions, automation enrollment, and tasks. Always search tools first for current schemas.

brevo-automation

davepoon/buildwithclaude

Automate Brevo (Sendinblue) tasks via Rube MCP (Composio): manage email campaigns, create/edit templates, track senders, and monitor campaign performance. Always search tools first for current schemas.

convertkit-automation

davepoon/buildwithclaude

Automate ConvertKit (Kit) tasks via Rube MCP (Composio): manage subscribers, tags, broadcasts, and broadcast stats. Always search tools first for current schemas.

gmail-automation

davepoon/buildwithclaude

Automate Gmail tasks via Rube MCP (Composio): send/reply, search, labels, drafts, attachments. Always search tools first for current schemas.

Sponsor this space

Reach thousands of developers