Connect your OneDrive account to Goodweek to manage files, folders, sharing links, workbooks, and document content directly from your AI workspace.
ℹ️ Governance note
Goodweek will never exceed the access levels granted to the user within OneDrive, guaranteeing alignment with your organization's governance policies. Outcomes and available features may vary depending on each user's specific permissions and authenticated access.
📋 Prerequisites
Before any user can see and connect the OneDrive integration, your organization admin must first enable it from the Goodweek Admin Panel under the Integrations tab.
Admin Setup
The OneDrive integration uses Microsoft OAuth 2.0 via Microsoft Entra ID. To allow users to connect, a Microsoft Entra tenant admin must grant admin consent for the application. Without this step, users may see a permission error during the connection flow.
There are three typical scenarios depending on your Entra ID configuration:
Admin consent has already been granted. Users can connect directly without any additional steps.
User consent is disabled in your tenant. An Entra admin must grant consent on behalf of the organization before users can connect. Go to Microsoft Entra admin center → Enterprise Applications → Composio → Permissions → Grant admin consent for [your organization].
Access to OneDrive or SharePoint data is restricted at the resource level. Depending on your organization's settings, additional permissions may need to be configured before the integration can access file content.
⚠️ Important: Microsoft admin session edge case
If a Microsoft Entra tenant admin completes the OAuth connection flow themselves, Microsoft may apply admin consent automatically and link the integration to the admin's account rather than to their individual user account. This is a Microsoft behavior and cannot be changed at the OAuth level.
Recommended approach: The admin should pre-approve the app in Entra ID (Enterprise Applications → Composio → Permissions → Grant admin consent for your organization) before any user — including the admin — goes through the Goodweek connection flow. Once pre-approved, any user including the admin can complete the flow and the integration will be linked to their individual account.
Alternatively, a non-admin user can complete the connection flow first to avoid this issue.
User Connection
In Goodweek, go to Integrations.
Find OneDrive and click Connect.
You will be redirected to Microsoft, where you will be asked to sign in with your Microsoft account and authorize access.
Click Accept to grant access and return to Goodweek.
Important Notes
Each user must connect their own account individually.
Goodweek can only access the files and folders that belong to the account you authorize, plus any files shared with you.
You can revoke Goodweek's access at any time from Microsoft account → My Account → Privacy → Apps and services → Composio → Remove access.
Available Tools
Tool | Description | Type |
List OneDrive Items | Retrieves files and folders from the root of the user's OneDrive. | Read |
List Folder Children | Lists the direct files and folders inside a OneDrive folder by DriveItem ID or path. | Read |
List All Drive Items | Lists a complete OneDrive or SharePoint drive safely using delta pagination. | Read |
Find Item | Finds a file or folder by name within a specified OneDrive folder. | Read |
Find Folder | Finds folders by name within an accessible parent folder in OneDrive. | Read |
Search Drive Items | Searches OneDrive and accessible SharePoint files by keyword across filenames, metadata, and content. | Read |
Search Items | Searches OneDrive for files and folders by keyword including file content. | Read |
Get Item Metadata | Retrieves metadata of a DriveItem by its unique ID including name, size, and timestamps. | Read |
Get Drive Root Folder | Retrieves metadata for the root folder of the signed-in user's OneDrive. | Read |
Get Drive Special Folder | Retrieves a special folder in OneDrive by name (Documents, Desktop, Photos, etc.). | Read |
Get DriveItem by Sharing URL | Resolves a OneDrive or SharePoint sharing URL to a DriveItem with full metadata. | Read |
List OneDrive Shared Items | Lists files shared from other people's OneDrive accounts that are accessible to the user. | Read |
Download a File | Downloads a file from OneDrive using its item ID. | Read |
Download File by Path | Downloads the contents of a file from OneDrive by its path. | Read |
Download Item as Format | Downloads a DriveItem converted to a specified format such as PDF or HTML. | Read |
Upload File | Uploads a file to a specified OneDrive folder, creating the destination folder if needed. | Write |
Update File Content | Updates an existing file's content in OneDrive. | Write |
Create Folder | Creates a new folder in the user's OneDrive with configurable conflict behavior. | Write |
Create a New Text File | Creates a new plain-text file with specified content in OneDrive. | Write |
Move Item | Moves a file or folder to a new parent folder in OneDrive for reorganization. | Read |
Copy Item | Copies a DriveItem (file or folder) to a new location asynchronously. | Read |
Update Drive Item Metadata | Updates metadata of a OneDrive item including name, description, and parent folder. | Write |
Create Sharing Link | Creates a sharing link for a DriveItem with configurable access type and permissions. | Write |
Invite User to Drive Item | Invites users and grants permissions to a specific item in OneDrive. | Write |
Get Item Permissions | Retrieves the permissions of a DriveItem within a specific drive. | Read |
Update Drive Item Permissions | Updates the roles of an existing permission on a OneDrive item. | Write |
Get Item Versions | Retrieves the version history of a DriveItem by its unique ID. | Read |
Restore Item Version | Restores a previous version of a file by creating a new version from the specified historical version. | Read |
Check Out Drive Item | Checks out a DriveItem to prevent others from editing it until changes are complete. | Read |
Check In Drive Item | Checks in a checked-out DriveItem to make the new version visible to others. | Read |
Discard Checkout | Discards the checkout of a DriveItem, releasing it and discarding any changes. | Read |
List Drive Activities | Retrieves recent activities on the authenticated user's OneDrive. | Read |
List Root Drive Changes | Lists changes in the root of the user's primary drive using a delta token for incremental sync. | Read |
Preview Drive Item | Generates a short-lived embeddable preview URL for a specific DriveItem. | Read |
Get Document Comments | Extracts comments from a Word .docx file stored in OneDrive. | Read |
List Drives | Lists all Drive resources available to the authenticated user, including personal and shared drives. | Read |
Get SharePoint List Items (via OneDrive) | Retrieves items from a SharePoint list via the OneDrive connection. | Read |
List Site Lists | Lists all lists under a specific SharePoint site via the OneDrive connection. | Read |
List Site Subsites | Lists all subsites of a SharePoint site via the OneDrive connection. | Read |
Get Workbook Used Range | Retrieves the active data region of a worksheet in an Excel workbook stored in OneDrive. | Read |
Read Workbook Range | Reads a specific range of cells from an Excel workbook worksheet stored in OneDrive. | Read |
Update Workbook Range | Updates a range in an Excel workbook worksheet stored in OneDrive. | Write |
Write Workbook Cell | Updates the value, formula, or format of a specific cell in an Excel workbook stored in OneDrive. | Write |
Restore Deleted Item | Restores a deleted DriveItem (file or folder) from the recycle bin. | Read |
Delete Item | Deletes a DriveItem (file or folder) by its unique ID, moving it to the recycle bin. | ⚠️ Destructive |
Permanently Delete Drive Item | Permanently deletes a DriveItem without moving it to the recycle bin. This action is irreversible. | ⚠️ Destructive |
Delete Drive Item Permission | Revokes a sharing permission from a drive item. | ⚠️ Destructive |
Use Cases
Find and retrieve files on demand. Search OneDrive by keyword across file names and content from Goodweek to locate specific documents without browsing folder structures manually.
Upload and organize files. Upload new files to OneDrive folders, create folder structures, and move or copy existing files from Goodweek conversations to keep documents organized.
Share files with the right access level. Generate sharing links or invite specific users to a file or folder from Goodweek, with configurable view or edit permissions, when sharing content with colleagues or external parties.
Read and update Excel workbooks. Retrieve data from specific cell ranges in Excel workbooks stored in OneDrive and update cell values or ranges from Goodweek without opening the file directly.
Troubleshooting
Permission error during connection
Your Microsoft Entra tenant admin may need to grant consent for the application. Ask your admin to follow the Admin Setup steps above before attempting to reconnect.
Integration not visible in Goodweek
Make sure your organization admin has enabled the OneDrive integration from the Goodweek Admin Panel under the Integrations tab.