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
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
Click the Connect button next to OneDrive. A Microsoft OAuth popup will appear.
3
Sign in with your Microsoft account and grant the requested permissions. The integration requests file read/write access and site read access.
4
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:
- It checks the file’s MIME type and size
- For document formats (PDF, DOCX, XLSX, PPTX), it uses document parsing to extract text
- For text-based formats, it reads the content directly
- 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:
- Discover structure — “List the worksheets in my budget on OneDrive”
- Read existing data — “Show me cells A1:D20 of the Revenue sheet”
- 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.xlsxand 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.