SharePoint Automation via Rube MCP

Automate SharePoint operations through Composio's SharePoint toolkit via Rube MCP.

Toolkit docs: composio.dev/toolkits/share_point

Prerequisites

• Rube MCP must be connected (RUBE_SEARCH_TOOLS available)
• Active SharePoint connection via RUBE_MANAGE_CONNECTIONS with toolkit share_point
• 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 share_point
3. If connection is not ACTIVE, follow the returned auth link to complete setup
4. Confirm connection status shows ACTIVE before running any workflows

Tool Discovery

Always discover available tools before executing workflows:

RUBE_SEARCH_TOOLS: queries=[{"use_case": "document libraries, sites, lists, and content management", "known_fields": ""}]

This returns:

• Available tool slugs for SharePoint
• Recommended execution plan steps
• Known pitfalls and edge cases
• Input schemas for each tool

Core Workflows

1. Discover Available SharePoint Tools

RUBE_SEARCH_TOOLS:
  queries:
    - use_case: "list all available SharePoint tools and capabilities"

Review the returned tools, their descriptions, and input schemas before proceeding.

2. Execute SharePoint Operations

After discovering tools, execute them via:

RUBE_MULTI_EXECUTE_TOOL:
  tools:
    - tool_slug: "<discovered_tool_slug>"
      arguments: {<schema-compliant arguments>}
  memory: {}
  sync_response_to_workbench: false

3. Multi-Step Workflows

For complex workflows involving multiple SharePoint operations:

1. Search for all relevant tools: RUBE_SEARCH_TOOLS with specific use case
2. Execute prerequisite steps first (e.g., fetch before update)
3. Pass data between steps using tool responses
4. Use RUBE_REMOTE_WORKBENCH for bulk operations or data processing

Common Patterns

Search Before Action

Always search for existing resources before creating new ones to avoid duplicates.

Pagination

Many list operations support pagination. Check responses for next_cursor or page_token and continue fetching until exhausted.

Error Handling

• Check tool responses for errors before proceeding
• If a tool fails, verify the connection is still ACTIVE
• Re-authenticate via RUBE_MANAGE_CONNECTIONS if connection expired

Batch Operations

For bulk operations, use RUBE_REMOTE_WORKBENCH with run_composio_tool() in a loop with ThreadPoolExecutor for parallel execution.

Known Pitfalls

• Always search tools first: Tool schemas and available operations may change. Never hardcode tool slugs without first discovering them via RUBE_SEARCH_TOOLS.
• Check connection status: Ensure the SharePoint connection is ACTIVE before executing any tools. Expired OAuth tokens require re-authentication.
• Respect rate limits: If you receive rate limit errors, reduce request frequency and implement backoff.
• Validate schemas: Always pass strictly schema-compliant arguments. Use RUBE_GET_TOOL_SCHEMAS to load full input schemas when schemaRef is returned instead of input_schema.

Quick Reference

Toolkit docs: composio.dev/toolkits/share_point