# OneDrive Integration

Give your AI agent the ability to search, read, and upload files in Microsoft OneDrive.

---

Connect Microsoft OneDrive to your Chipp AI so it can search, browse, read, and upload files in the connected user's personal OneDrive storage, and edit Excel spreadsheets at the cell level.

## What the AI Can Do

Once connected, your agent gains ten tools:

| Tool | Description |
|------|-------------|
| **onedrive_search_files** | Search for files by name or content |
| **onedrive_list_files** | List files and folders in a directory |
| **onedrive_read_file** | Read the contents of a file |
| **onedrive_get_metadata** | Get detailed file or folder metadata |
| **onedrive_upload_file** | Upload a text file to a specified path |
| **onedrive_excel_get_worksheets** | List worksheets (tabs) in an Excel file |
| **onedrive_excel_read_range** | Read a specific cell range (e.g. `A1:D10`) |
| **onedrive_excel_write_range** | Write values to a specific cell range, in place |
| **onedrive_excel_append_row** | Append a row to the bottom of a worksheet |
| **onedrive_excel_get_used_range** | Read all populated data in a worksheet |

### Supported File Types

- **PDFs, Word (.docx), Excel (.xlsx), PowerPoint (.pptx)** -- extracted via document parsing
- **Text files** (JSON, CSV, XML, Markdown, JavaScript, code) -- read directly
- **Binary files** are identified but cannot be displayed as text

## Connecting OneDrive


  **1.** 
    <strong>Open the Integrations tab</strong>

    In your app's builder, navigate to the **Build** section and select the **Integrations** tab. Find **Microsoft OneDrive** in the list of available integrations.
  


  **2.** 
    <strong>Click Connect</strong>

    Click the **Connect** button next to OneDrive. A Microsoft OAuth popup will appear.
  


  **3.** 
    <strong>Authorize access</strong>

    Sign in with your Microsoft account and grant the requested permissions. The integration requests file read/write access and site read access.
  


  **4.** 
    <strong>Test it out</strong>

    Once connected, open the chat preview and try:
    - "Search my OneDrive for the project proposal"
    - "List the files in my Documents folder"
    - "Read the contents of the budget spreadsheet"
  


## Folder Restrictions

You can optionally restrict the integration to specific folders. When configured:

- **List** shows only the allowed folders at the root level
- **Search** results are filtered to files within the allowed folders
- Files outside the configured folders are not accessible

## How It Works

The integration uses the Microsoft Graph API to interact with OneDrive. Files can be referenced by either their item ID or their file path (e.g., `/Documents/report.docx`).

When the agent reads a file:
1. It checks the file's MIME type and size
2. For document formats (PDF, DOCX, XLSX, PPTX), it uses document parsing to extract text
3. For text-based formats, it reads the content directly
4. Binary files are identified with their type but cannot be displayed

## Editing Excel Files

The Excel workbook tools let the agent edit spreadsheets **in place** without replacing the whole file. This is powered by the Microsoft Graph workbook API and reuses the same OAuth connection -- no separate Azure AD setup is needed.

Typical workflow:

1. **Discover structure** -- "List the worksheets in my budget on OneDrive"
2. **Read existing data** -- "Show me cells A1:D20 of the Revenue sheet"
3. **Write or append** -- "Set cell B5 to 1234.56" or "Append a new row with today's totals"

Example prompts:

- "Add a row to my expenses sheet: today, 'Office supplies', 123.45"
- "Read the data in `/Documents/inventory.xlsx` and tell me which items are low stock"
- "Update cell C3 of the Summary sheet to 'Reviewed'"

The agent automatically figures out worksheet names, used ranges, and column letters.

## Example Use Cases

- **Document retrieval** -- "Find and read the latest sales report"
- **File organization** -- "What files are in the shared project folder?"
- **Content creation** -- "Create a summary document from our meeting notes and upload it to OneDrive"
- **File search** -- "Search for any files related to the Q1 budget"
- **Spreadsheet updates** -- "Append today's shipment data to the tracking sheet"

## Billing

OneDrive tool calls use your standard LLM token billing. There is no separate per-call fee.