Overview
We're excited to announce major updates to our Consolidated Microsoft 365 Integration. This unified integration now provides comprehensive access to Outlook, Calendar, Microsoft Teams, OneDrive, SharePoint, and Excel—all through a single connection.
🔧 Action Required
For Entra (Azure AD) Administrators
Your organization's Entra administrator must grant admin consent for the new permissions required by the Consolidated Microsoft 365 Integration. Without admin consent, users will not be able to access the new features.
Go to Enterprise Apps → Hatz AI Outlook MCP Server → Permissions
Then click Grant Admin Consent
Should show the prompt for the exhaustive list of permissions needed
After doing this you may notice the name of the App change to “Hatz AI M365 MCP Server”, to better describe what the Enterprise App is for.
For Users
Users who want to access the new tools must disconnect and reconnect the Microsoft 365 integration to obtain the updated permissions.
Steps:
Navigate to Workshop → Integrations
Disconnect the existing Microsoft 365/Outlook integration
Reconnect the Consolidated Microsoft 365 Integration
You can select between the toolkits for which ones you will want to include
If you are prompted about Admin Consent see the above section
You may have to reach out to your Entra admin to grant admin consent for the new permissions
👥 Who Is Affected?
User Type | Action Required |
MSPs with tenants connected to Outlook/Microsoft integrations | Coordinate with tenant Entra admins for consent; users need to reconnect |
Tenant users already connected to the Microsoft Outlook tool | Disconnect and reconnect to gain access to new tools |
New users | Simply connect the Consolidated Microsoft 365 Integration—no additional steps needed |
🛠️ Complete List of Supported Tools (71 Total)
📧 Outlook Email (4 tools)
Tool | Description |
list_emails | Fetch recent emails from inbox (up to 50) |
read_email | Read the full content of a specific email |
search_emails | Search emails by keywords, subject, body, or sender |
create_email | Create a draft email in the Drafts folder |
📅 Calendar (3 tools)
Tool | Description |
list_events | Fetch upcoming calendar events with full details |
create_meeting | Create a calendar meeting with Teams link |
decline_meeting | Decline a calendar meeting invitation |
💬 Microsoft Teams (18 tools)
Team Management
Tool | Description |
get_authed_user | Get authenticated user's profile |
list_teams | List all teams user is a member of |
create_team | Create a new team |
get_team | Get details of a specific team |
list_team_members | List members of a team |
add_member_to_team | Add a member to a team |
Channel Management
Tool | Description |
list_channels | List channels in a team |
get_channel | Get channel details |
create_channel | Create a new channel in a team |
Chat & Messaging
Tool | Description |
list_chats | List user's chats |
create_chat | Create new chat (1:1 or group) |
get_chat_messages | Get messages from a chat |
post_chat_message | Post a message to a chat |
post_channel_message | Post a message to a team channel |
reply_to_message | Reply to a channel message |
Meetings & Transcripts
Tool | Description |
list_meetings | List past Teams meetings |
get_meeting | Get online meeting details |
create_online_meeting | Create a Teams online meeting |
get_meeting_id_from_join_url | Resolve meeting ID from a join URL |
list_transcripts | List meeting transcripts |
get_transcript | Get transcript content |
Users
Tool | Description |
list_users | Search and list organization users |
📁 OneDrive & SharePoint (10 tools)
File Browsing
Tool | Description |
get_drive | Get user's default drive info and quota |
list_items | List items in a drive folder |
get_recent_items | List recently accessed files |
get_shared_items | List items shared with user |
get_sharepoint_list_items | Get SharePoint list items |
File Operations
Tool | Description |
download_file | Download file and get presigned URL |
download_shared_file | Download a shared file |
update_drive_item_metadata | Update file name/description |
create_link | Create a sharing link |
Search
Tool | Description |
graph_search | Search OneDrive/SharePoint using KQL |
📊 Excel (36 tools)
Session Management
Tool | Description |
create_excel_session | Create workbook session (required first) |
close_excel_session | Close workbook session (call when done) |
get_workbook_info | Get workbook information |
list_workbook_permissions | List file permissions |
Worksheet Management
Tool | Description |
list_worksheets | List all worksheets |
get_worksheet_info | Get worksheet info |
add_worksheet | Add new worksheet |
update_worksheet | Update worksheet properties |
delete_worksheet | Delete worksheet |
protect_worksheet | Protect worksheet from editing |
Range Operations
Tool | Description |
get_range | Get a range of cells |
get_used_range | Get used range of worksheet |
get_row_range | Get entire row |
get_column_range | Get entire column |
update_range | Update cell values |
get_sharepoint_range | Get range from SharePoint workbook |
update_sharepoint_range | Update SharePoint range |
clear_range | Clear range contents |
insert_range | Insert blank cells |
merge_cells | Merge cells in range |
sort_range | Sort range |
Table Management
Tool | Description |
list_tables | List worksheet tables |
add_table | Create new table from range |
update_table | Update table properties |
delete_table | Delete table (converts to range) |
list_table_columns | List table columns |
get_table_column | Get column details |
add_column_to_table | Add new column |
delete_column | Delete column |
list_table_rows | List table rows (with pagination) |
add_row_to_table | Add single row |
add_rows_to_table | Add multiple rows |
delete_row | Delete row |
Chart Management
Tool | Description |
list_charts | List worksheet charts |
get_chart | Get chart details |
add_chart | Create new chart |
update_chart | Update chart properties |
update_chart_legend | Update chart legend |
delete_chart | Delete chart |
📋 Tool Count Summary
Category | Tools |
4 | |
Calendar | 3 |
Microsoft Teams | 18 |
OneDrive & SharePoint | 10 |
Excel | 36 |
Total | 71 |
❓ Questions?
If you have any questions about this update or need assistance with the reconnection process, please contact our support team.