Connect your SharePoint account to Goodweek to manage documents, lists, folders, files, and site content directly from your AI workspace.
ℹ️ Governance note
Goodweek will never exceed the access levels granted to the user within SharePoint, 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 SharePoint integration, your organization admin must first enable it from the Goodweek Admin Panel under the Integrations tab.
Admin Setup
The SharePoint 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].
SharePoint access is restricted at the resource level. Depending on your organization's SharePoint settings, additional permissions may need to be configured at the site or tenant level before the integration can access 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 SharePoint 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 sites, lists, and documents that your individual account has permission to access within SharePoint.
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 SharePoint Sites | Lists all SharePoint sites accessible to the user for discovery. | Read |
Get SharePoint Site by Hostname | Retrieves site metadata by hostname or URL, including site ID and display name. | Read |
Get SharePoint Root Site | Retrieves metadata about the root web of a SharePoint site collection. | Read |
Get SharePoint Web Info | Retrieves information about the current SharePoint web including title and URL. | Read |
List SharePoint Lists | Lists all lists and document libraries in the current SharePoint site. | Read |
Get SharePoint List by GUID | Retrieves a specific SharePoint list by its unique identifier. | Read |
Get SharePoint List by Title | Retrieves a SharePoint list by its display title. | Read |
List SharePoint List Columns | Lists all column definitions in a SharePoint list including field metadata. | Read |
Create SharePoint List | Creates a new list in SharePoint using the REST API. | Write |
Update SharePoint List | Updates properties of an existing SharePoint list such as title or description. | Write |
Get SharePoint List Items | Retrieves items from a SharePoint list with optional OData filtering and pagination. | Read |
Get List Item by ID | Retrieves a specific SharePoint list item by its numeric ID. | Read |
Create SharePoint List Item | Creates a new item in a SharePoint list. | Write |
Update SharePoint List Item | Updates fields on an existing SharePoint list item. | Write |
List Drive Children | Lists files and folders in a SharePoint document library or folder. | Read |
List Files in Folder | Lists files within a specific SharePoint folder (non-recursive). | Read |
List Subfolders in Folder | Lists immediate child folders within a SharePoint folder. | Read |
Get All SharePoint Folders | Retrieves all folders in the SharePoint web for discovery. | Read |
Create SharePoint Folder | Creates a new folder in a SharePoint document library. | Write |
Rename SharePoint Folder | Renames a SharePoint folder by updating its list item metadata. | Read |
Upload File to Folder | Uploads a file to a SharePoint document library or folder. | Write |
Upload File from URL to SharePoint | Fetches a file from a URL and uploads it directly to SharePoint. | Write |
Download File by Server-relative URL | Downloads a file from SharePoint using its server-relative URL. | Read |
Get Site Drive Item by Path | Retrieves metadata for a file or folder by its server-relative path. | Read |
Update Drive Item | Updates properties of a drive item (file or folder) in SharePoint. | Write |
Update File Item Metadata | Updates metadata fields on a SharePoint file item. | Write |
Search SharePoint Site | Searches SharePoint content using Keyword Query Language for documents, items, and folders. | Read |
Search Files Across All Sites | Searches for files across all SharePoint sites and OneDrive using Keyword Query Language. | Read |
Check Out SharePoint File | Checks out a file to lock it before making changes. | Read |
Check In SharePoint File | Checks in a file to finalize changes and make the new version available. | Read |
Recycle SharePoint File | Moves a file to the SharePoint Recycle Bin (soft delete, recoverable). | Read |
Restore Recycle Bin Item | Restores a deleted SharePoint item from the Recycle Bin by its GUID. | Read |
Create Drive Item Sharing Link | Creates a sharing link for a SharePoint drive item with configurable access type. | Write |
Add Attachment to List Item | Uploads a binary file as an attachment to a SharePoint list item. | Write |
List Item Attachments | Lists all attachments for a SharePoint list item. | Read |
Download List Item Attachment | Downloads the binary content of an attachment from a SharePoint list item. | Read |
Get Content Types for List | Retrieves all content types for a specific SharePoint list. | Read |
Create Content Type | Creates a new content type in SharePoint with specified field definitions. | Write |
List Site Groups | Lists all SharePoint site groups for a site collection. | Read |
Get Group Users | Retrieves all users who are members of a specified SharePoint group. | Read |
List Site Users | Lists users in the site collection including person users and groups. | Read |
Find SharePoint User | Searches for a user in the SharePoint site by email address. | Read |
Get Drive Item Analytics | Retrieves access analytics (view count) for a SharePoint drive item. | Read |
List Recently Modified Drive Items | Lists recently modified items in a SharePoint drive. | Read |
Restore Drive Item Version | Restores a previous version of a SharePoint drive item. | Read |
Delete SharePoint File | Permanently deletes a file from a SharePoint document library. | ⚠️ Destructive |
Delete SharePoint Folder | Permanently deletes a folder from a SharePoint document library. | ⚠️ Destructive |
Delete SharePoint List Item | Permanently deletes a SharePoint list item by its ID. | ⚠️ Destructive |
Delete SharePoint List | Permanently deletes a SharePoint list by its GUID. | ⚠️ Destructive |
Use Cases
Find and retrieve documents across sites. Search SharePoint sites using keywords or browse folder structures from Goodweek to locate specific files and retrieve their content or download links without navigating the SharePoint interface.
Create and update list items. Add or modify items in SharePoint lists from Goodweek conversations — useful for updating project trackers, issue logs, or any structured data stored in SharePoint lists.
Upload and organize files. Upload files to document libraries, create folders, and manage file organization in SharePoint directly from Goodweek, keeping documents up to date without manual browser navigation.
Share documents with specific access levels. Generate sharing links for files or folders with the appropriate permission level from Goodweek when sharing resources with internal or external stakeholders.
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 connected but some sites or files are not accessible
SharePoint respects site-level and item-level permissions. If you cannot access a specific site or document library, your SharePoint admin will need to grant you access directly within SharePoint.
Integration not visible in Goodweek
Make sure your organization admin has enabled the SharePoint integration from the Goodweek Admin Panel under the Integrations tab.