Skip to main content
Agent skill

SharePoint Automation

SharePoint Automation: manage sites, lists, documents, folders, pages, and search content across SharePoint and OneDrive

Get started

Get the complete skill folder, including its scripts and reference files.

·

When to use this skill

Use SharePoint Automation when an AI agent needs a reusable SKILL.md workflow for this job: SharePoint Automation: manage sites, lists, documents, folders, pages, and search content across SharePoint and OneDrive

When not to use it

Skip SharePoint Automation when the task is outside the productivity category, or when a more specific skill in this directory already covers the same workflow with clearer triggers.

How to install

Where will you use it?

Install scope
Claude Code folder setup
mkdir -p ~/.claude/skills/sharepoint-automation
# Save SKILL.md to ~/.claude/skills/sharepoint-automation/SKILL.md
  1. Claude Code personal install: place the skill and its bundled files at ~/.claude/skills/sharepoint-automation/SKILL.md. For a shared project, commit the folder at .claude/skills/sharepoint-automation/ instead.
  2. Current Claude Code detects SKILL.md changes in watched directories during the session. If you just created a top-level skills directory, run /reload-skills. Check that the skill is listed before testing its trigger.
  3. For Claude chat or Cowork in the Desktop app, manage uploaded skills in Customize > Skills; copying files into a local Claude Code folder is not a Desktop install. Other agents may use different install locations.

Full install guide for Claude, Cursor, and Codex →

Try a starter prompt

After installing the skill, paste this starter prompt into your agent to verify it triggers on a small task.

Starter prompt
Use the SharePoint Automation skill for this task: Use SharePoint Automation when this documented workflow matches the task. Confirm any required inputs or files before making changes.

What supports this recommendation?

70/100 provisional content score. This measures documentation, practical detail and source signals. It is not a measured task success rate or a security certification.

Documentation
72/100
Practical detail
68/100
Source evidence
63/100
Source signals
80/100
Model compatibility evidence
  • claudeinferred

    The skill text mentions Claude or a closely associated term. This is keyword-derived compatibility; no hands-on model test is recorded.

  • chatgptuntested

    No model-specific signal or recorded compatibility test was found.

  • geminiuntested

    No model-specific signal or recorded compatibility test was found.

  • copilotuntested

    No model-specific signal or recorded compatibility test was found.

  • llamauntested

    No model-specific signal or recorded compatibility test was found.

  • perplexityuntested

    No model-specific signal or recorded compatibility test was found.

  • mistraluntested

    No model-specific signal or recorded compatibility test was found.

  • grokuntested

    No model-specific signal or recorded compatibility test was found.

Inferred compatibility is based on content signals. Check the app, its available tools and setup requirements before running a skill.

What this skill does

# SharePoint Automation

Automate SharePoint operations including managing sites, lists, documents, folders, and pages. Integrates with both SharePoint REST API and Microsoft Graph via OneDrive.

**Toolkit docs:** [composio.dev/toolkits/share_point](https://composio.dev/toolkits/share_point)

---

## Setup

This skill requires the **Rube MCP server** connected at `https://rube.app/mcp`.

Before executing any tools, ensure active connections exist for the `share_point` and `one_drive` toolkits. If no connection is active, initiate one via `RUBE_MANAGE_CONNECTIONS`.

> **Note:** Many OneDrive/SharePoint tools only work with organizational Microsoft 365 accounts (Azure AD/Entra ID). Personal Microsoft accounts are NOT supported.

---

## Core Workflows

### 1. List and Browse Sites

Retrieve site details and enumerate subsites to discover the SharePoint topology.

**Tools:** - `ONE_DRIVE_GET_SITE_DETAILS` -- Get metadata for a specific site by ID - `ONE_DRIVE_LIST_SITE_SUBSITES` -- List all subsites of a parent site

**Key Parameters:** - `site_id` (required) -- Composite format: `hostname,site-collection-guid,web-guid` (e.g., `"contoso.sharepoint.com,da60e844-...,712a596e-..."`)

**Example:** ``` Tool: ONE_DRIVE_GET_SITE_DETAILS Arguments: site_id: "contoso.sharepoint.com,2C712604-1370-44E7-A1F5-426573FDA80A,2D2244C3-251A-49EA-93A8-39E1C3A060FE" ```

---

### 2. Manage Lists

Create lists, enumerate existing lists, and retrieve list items.

**Tools:** - `SHARE_POINT_LIST_ALL_LISTS` -- Retrieve all lists on a site (supports OData filter, select, orderby, top) - `SHARE_POINT_SHAREPOINT_CREATE_LIST` -- Create a new list with a specified template - `ONE_DRIVE_LIST_SITE_LISTS` -- List all lists under a site via Microsoft Graph - `ONE_DRIVE_GET_SHAREPOINT_LIST_ITEMS` -- Retrieve items from a specific list

**Key Parameters for `SHARE_POINT_SHAREPOINT_CREATE_LIST`:** - `name` (required) -- List name - `template` (required) -- Template type: `"genericList"`, `"documentLibrary"`, `"tasks"`, etc. - `description` -- Optional description

**Key Parameters for `SHARE_POINT_LIST_ALL_LISTS`:** - `filter` -- OData filter, e.g., `"Hidden eq false"` - `select` -- Properties to return, e.g., `"Title,Id"` - `orderby` -- Sort expression, e.g., `"Title desc"` - `top` -- Limit results count

**Example:** ``` Tool: SHARE_POINT_SHAREPOINT_CREATE_LIST Arguments: name: "Project Tasks" template: "tasks" description: "Task tracking for Q1 deliverables" ```

---

### 3. Manage Folders and Files

Create folders, list files within folders, and navigate the document library.

**Tools:** - `SHARE_POINT_SHAREPOINT_CREATE_FOLDER` -- Create a new folder in a document library - `SHARE_POINT_LIST_FILES_IN_FOLDER` -- List files within a folder by server-relative URL - `SHARE_POINT_GET_FOLDER_BY_SERVER_RELATIVE_URL` -- Get folder metadata by path

**Key Parameters for `SHARE_POINT_SHAREPOINT_CREATE_FOLDER`:** - `folder_name` (required) -- Name of the folder to create - `document_library` -- Target library (default: `"Shared Documents"`) - `relative_path` -- Additional path within the library

**Key Parameters for `SHARE_POINT_LIST_FILES_IN_FOLDER`:** - `folder_name` (required) -- Server-relative URL, e.g., `"/Shared Documents"` - `select` -- Comma-separated properties, e.g., `"Name,ServerRelativeUrl,Length"` - `top` -- Limit results count - `orderby` -- Sort expression, e.g., `"Name desc"`

**Example:** ``` Tool: SHARE_POINT_LIST_FILES_IN_FOLDER Arguments: folder_name: "/Shared Documents/Reports" select: "Name,ServerRelativeUrl,Length" top: 50 ```

---

### 4. Search SharePoint Content

Use Keyword Query Language (KQL) to search documents, list items, and other content across the site.

**Tool:** `SHARE_POINT_SEARCH_QUERY`

**Key Parameters:** - `querytext` (required) -- KQL query, e.g., `"project report"`, `"FileType:docx"`, `"Author:\"John Doe\""` - `rowlimit` -- Max results per request (default ~50, max 500) - `startrow` -- Zero-based offset for pagination - `selectproperties` -- Properties to return, e.g., `"Title,Author,Path"` - `refinementfilters` -- Narrow results, e.g., `"FileType:equals(\"docx\")"`

**Example:** ``` Tool: SHARE_POINT_SEARCH_QUERY Arguments: querytext: "IsDocument:1 FileType:pdf" rowlimit: 25 selectproperties: "Title,Author,Path,LastModifiedTime" ```

---

### 5. Track List Changes (Delta Query)

Use delta queries to get incremental changes (created, updated, deleted items) without reading the entire list.

**Tool:** `ONE_DRIVE_LIST_SHAREPOINT_LIST_ITEMS_DELTA`

**Key Parameters:** - `site_id` (required) -- Composite site ID - `list_id` (required) -- List GUID - `token` -- Omit for initial sync; pass `"latest"` for empty response with token; pass previous token for changes since - `expand` -- e.g., `"fields($select=ColumnA,ColumnB)"` - `top` -- Max items per response

---

### 6. Retrieve Site Page Content

Read modern SharePoint Site Pages content including canvas web parts.

**Tool:** `SHARE_POINT_GET_SITE_PAGE_CONTENT`

**Key Parameters:** - `page_file_name` -- File name with `.aspx` extension, e.g., `"Home.aspx"` - `item_id` -- Alternative: list item ID of the page - `render_as` -- `"raw"` (default), `"text"`, or `"html"` - `site` -- Optional site name scope

---

## Known Pitfalls

| Pitfall | Detail | |---------|--------| | **Site ID format** | Must be composite: `hostname,site-collection-guid,web-guid`. Incorrect format causes 400 errors. | | **Personal accounts unsupported** | `ONE_DRIVE_LIST_SITE_LISTS` and Graph-based tools only work with organizational M365 accounts, not personal MSA/Outlook.com accounts. | | **OData filter syntax** | SharePoint OData filters use specific syntax. Test filters incrementally; unsupported expressions may silently return empty results. | | **Pagination** | Use `skiptoken` for server-side paging in list operations. Incomplete pagination settings can miss results. | | **Folder paths** | Must use server-relative URLs (e.g., `/Shared Documents`) not absolute URLs. |

---

## Quick Reference

| Tool Slug | Description | |-----------|-------------| | `ONE_DRIVE_GET_SITE_DETAILS` | Get metadata for a SharePoint site | | `ONE_DRIVE_LIST_SITE_SUBSITES` | List subsites of a parent site | | `ONE_DRIVE_LIST_SITE_LISTS` | List all lists under a site (Graph API) | | `ONE_DRIVE_LIST_SHAREPOINT_LIST_ITEMS_DELTA` | Track incremental list changes | | `ONE_DRIVE_GET_SHAREPOINT_LIST_ITEMS` | Retrieve items from a list | | `ONE_DRIVE_LIST_DRIVES` | List available drives for a user/site/group | | `ONE_DRIVE_LIST_SITE_COLUMNS` | List column definitions for a site | | `SHARE_POINT_LIST_ALL_LISTS` | Retrieve all lists on a site (REST API) | | `SHARE_POINT_SHAREPOINT_CREATE_LIST` | Create a new SharePoint list | | `SHARE_POINT_SHAREPOINT_CREATE_FOLDER` | Create a folder in a document library | | `SHARE_POINT_LIST_FILES_IN_FOLDER` | List files in a folder | | `SHARE_POINT_SEARCH_QUERY` | Search content using KQL | | `SHARE_POINT_GET_SITE_PAGE_CONTENT` | Retrieve Site Page content | | `SHARE_POINT_GET_FOLDER_BY_SERVER_RELATIVE_URL` | Get folder metadata by path |

---

*Powered by [Composio](https://composio.dev)*

Intended uses

  • Use SharePoint Automation when this documented workflow matches the task.

Implementation notes

  • Review the source instructions and adapt inputs before running the workflow.

Try it, then tell us how it went

A copied prompt does not tell us whether the task worked. Report your result after checking the output. We collect your tool and outcome, never your files or prompt.