Overview

The Microsoft 365 connector for Gemini Enterprise lets you search and act on data across Microsoft 365 from a single connector: SharePoint sites, OneDrive files, Outlook mail, Outlook calendars, contacts, and Microsoft Teams. The connector reaches all of these surfaces through the Microsoft Graph API.

Because one connector covers every Microsoft 365 surface, you don't need to create a separate data store for SharePoint, OneDrive, Outlook, and Teams.

The connector supports two OAuth 2.0 authentication methods:

  • Google-managed OAuth (default): The connector uses an Microsoft Entra application that Google manages. You don't register your own application or provide a client ID and client secret.
  • Bring your own app: Register your own Microsoft Entra application, and provide its tenant ID, client ID, and client secret when you set up the data store.

For more information, see Microsoft 365 configuration.

Supported actions

When the Microsoft 365 connector is enabled, end users can use natural language commands in Gemini Enterprise to perform the following actions. The actions are grouped by the Microsoft 365 product they act on, which matches how they are grouped when you select actions in the Google Cloud console. For each action, the tables show whether it only reads data or also makes changes, and the delegated Microsoft Graph permissions it needs. For how permissions are requested and granted, see Permissions.

Users and groups

Action Type Description Required permissions
Add group member Write Adds a user as a member of a group. GroupMember.ReadWrite.All
Add group owner Write Adds a user as an owner of a group. Group.ReadWrite.All
Create group Write Creates a new Microsoft 365 group. Group.ReadWrite.All
Get my profile Read-only Retrieves the profile of the signed-in user, including the email address their Microsoft account is keyed on. User.Read
Get user profile Read-only Retrieves the profile of a user in the directory. User.ReadBasic.All
Get user work profile Read-only Retrieves a user's job title, department, office, phone numbers, manager and direct reports. User.Read.All
List group members Read-only Lists the direct members of a group in the directory. Group.ReadBasic.All
User.ReadBasic.All
List group owners Read-only Lists the owners of a group in the directory. GroupMember.Read.All
User.ReadBasic.All
List groups Read-only Finds groups in the directory by name and returns each group's id. Group.ReadBasic.All
Find people in the directory Read-only Finds people in the organization's directory by name or email address. User.ReadBasic.All
Update group Write Updates a group's name, description, or visibility. Group.ReadWrite.All

SharePoint and OneDrive

Action Type Description Required permissions
Get Excel range Read-only Reads the cell values in a block of cells on a worksheet, including cells outside a table. Files.Read.All
Get Excel table row Read-only Reads one row of a table in an Excel workbook, with the table's column headers. Files.Read.All
Get Excel table rows Read-only Reads the data rows of a table in an Excel workbook, with the table's column headers. Files.Read.All
List Excel tables Read-only Lists the formatted tables in an Excel workbook and the worksheet each one sits on. Files.Read.All
Get Excel workbook properties Read-only Reads an Excel workbook's file properties: name, size, URL, and who last changed it. Files.Read.All
Get Excel worksheet Read-only Reads one worksheet of an Excel workbook and the extent of the data on it. Files.Read.All
List Excel worksheets Read-only Lists the worksheets in an Excel workbook, in tab order. Files.Read.All
List Excel workbooks Read-only Finds Excel workbooks in OneDrive and SharePoint sites the user can access. Sites.Read.All
Files.Read.All
Check in document Write Checks in a document, releasing its edit lock and making it available to others. Files.ReadWrite.All
Check out document Write Checks out a document, locking it for exclusive editing. Files.ReadWrite.All
Copy file Write Copies a file to a new location. Files.ReadWrite.All
Copy folder Write Copies a folder to a new location. Files.ReadWrite.All
Create file Write Creates a new file with a given name inside a folder. Never overwrites an existing file; use Replace file content for that. Files.ReadWrite.All
Create folder Write Creates a new folder inside an existing folder. Files.ReadWrite.All
Create share link Write Creates a shareable link to a file or folder. Files.ReadWrite.All
Discard checkout Write Cancels a document check-out and discards any pending changes. Files.ReadWrite.All
Get file or folder by URL Read-only Finds the file or folder a SharePoint or OneDrive link points at, so it can be read or acted on. Files.Read.All
Download file content Read-only Downloads the raw contents of a file stored in a drive. Files.Read.All
Get my OneDrive Read-only Gets the signed-in user's own OneDrive, so files can be saved to or listed at its top level, and reports its storage quota. Files.Read.All
List folder contents Read-only Lists the files and folders inside a folder in a drive. Files.Read.All
List file permissions Read-only Lists the sharing permissions set on a file or folder. Files.Read.All
Move file Write Moves a file to a different folder. Files.ReadWrite.All
Move folder Write Moves a folder to a different parent folder. Files.ReadWrite.All
Rename file Write Renames a file. Files.ReadWrite.All
Rename folder Write Renames a folder. Files.ReadWrite.All
Replace file content Write Replaces the entire content of a file that already exists. To create a new file, use Create file. Files.ReadWrite.All
Send sharing invitation Write Sends a sharing invitation for a file or folder. Files.ReadWrite.All
Update file or folder properties Write Updates properties of a file or folder (name, description, parent folder). Files.ReadWrite.All
Create SharePoint list Write Creates a new list on a SharePoint site. Sites.Manage.All
Create list item Write Creates a new item in a SharePoint list. Sites.ReadWrite.All
Create SharePoint page Write Creates a new page on a SharePoint site. Sites.ReadWrite.All
Get list item Read-only Retrieves a single row of a SharePoint list, with its column values. Sites.Read.All
Get SharePoint page content Read-only Retrieves the HTML body of a SharePoint page. Sites.Read.All
List list items Read-only Reads the rows of a SharePoint list, with each row's column values. Sites.Read.All
List SharePoint lists Read-only Lists the SharePoint lists on a site, including each list's id and template. Sites.Read.All
List SharePoint pages Read-only Lists the pages on a SharePoint site, with each page's title, URL and publishing state. Sites.Read.All
Search SharePoint and OneDrive Read-only Searches SharePoint sites, pages, list items, and OneDrive files the user can access. Sites.Read.All
Files.Read.All
Update SharePoint list Write Updates properties of a SharePoint list (name, description). Sites.Manage.All
Update list item Write Updates fields on an existing SharePoint list item. Sites.ReadWrite.All
Update SharePoint page Write Updates a SharePoint page's title or filename. Sites.ReadWrite.All

Outlook

Action Type Description Required permissions
Add attachment Write Adds a file attachment to an existing email message or calendar event. Mail.ReadWrite
Calendars.ReadWrite
Create calendar Write Creates a new calendar in the user's mailbox. Calendars.ReadWrite
Calendars.ReadWrite.Shared
Create contact Write Creates a new contact in the user's Contacts folder. Contacts.ReadWrite
Create draft message Write Creates a draft email message in the user's mailbox. Mail.ReadWrite
Mail.ReadWrite.Shared
Create calendar event Write Creates a new event on the user's calendar. Calendars.ReadWrite
Create reply draft Write Creates a draft reply to the sender of an existing email message. Mail.ReadWrite
Mail.ReadWrite.Shared
Find meeting times Read-only Suggests meeting times based on attendee availability. Calendars.Read.Shared
Forward message Write Forwards an existing email message to specified recipients. Mail.Send
Get email message attachment Read-only Retrieves the bytes of one file attachment from a message in the user's mailbox. Mail.Read
Get automatic replies Read-only Retrieves the user's Outlook automatic-reply (out-of-office) setting. MailboxSettings.Read
Get calendar event Read-only Retrieves one event from the user's Outlook calendar, including attendee responses and attachment ids. Calendars.Read
Get calendar event attachment Read-only Retrieves the bytes of one file attachment from an event in the user's calendar. Calendars.Read
Get email message Read-only Retrieves a single message from the user's mailbox. Mail.Read
Get schedule availability Read-only Retrieves free/busy availability for users, rooms, or equipment over a time range. Calendars.Read
List calendar events Read-only Lists the events in the user's calendar over a time range. Calendars.Read
List calendars Read-only Lists the calendars in the user's mailbox. Calendars.Read
List Outlook categories Read-only Lists the categories (labels) in the user's Outlook category list. MailboxSettings.Read
List contacts Read-only Lists or searches the contacts in the user's Outlook address book. Contacts.Read
List inbox rules Read-only Lists the user's Outlook inbox rules. MailboxSettings.Read
List mail folders Read-only Lists the mail folders in the user's mailbox. Mail.ReadBasic
List messages in a folder Read-only Lists the messages in one of the user's own mail folders, such as the inbox or sent items. Mail.Read
List or search a shared mailbox Read-only Lists or searches the messages in a shared or delegated mailbox the user has access to. Mail.Read.Shared
Move message Write Moves an email message to a different mail folder. Mail.ReadWrite
Reply all to message Write Replies to an existing email message, to its sender and all other recipients, keeping the reply in the original conversation. Mail.Send
Reply to message Write Replies to an existing email message, to its sender, keeping the reply in the original conversation. Mail.Send
RSVP to event Write Responds to a meeting invitation (accept, tentatively accept, or decline). Calendars.ReadWrite
Search email Read-only Searches the user's Outlook mail by keyword. Mail.Read
Search email in a folder Read-only Searches the messages in one of the user's own mail folders, including subfolders such as Inbox/Invoices, by keyword, sender or subject. Mail.Read
Search calendar events Read-only Searches the user's Outlook calendar events by keyword. Calendars.Read
Send draft message Write Sends an existing draft email message. Mail.Send
Send mail Write Composes and sends a new email message. Mail.Send
Update calendar Write Updates properties of an existing calendar (name, color, or default status). Calendars.ReadWrite
Calendars.ReadWrite.Shared
Update contact Write Updates properties of an existing contact. Contacts.ReadWrite
Update event Write Updates properties of an existing calendar event. Calendars.ReadWrite
Update message Write Updates properties of an existing email message (e.g. mark as read, change flags or importance). Mail.ReadWrite
List task lists Read-only Lists the user's Microsoft To Do (Outlook Tasks) task lists. Tasks.Read
List tasks Read-only Lists the tasks in one of the user's Microsoft To Do (Outlook Tasks) lists. Tasks.Read

Teams

Action Type Description Required permissions
Add member to channel Write Adds a user to a private or shared Teams channel. ChannelMember.ReadWrite.All
Create channel Write Creates a new channel within a Teams team. Channel.Create
Create chat Write Creates a new Teams chat (one-on-one, group, or meeting chat). Chat.Create
Create meeting Write Creates a new Teams online meeting. OnlineMeetings.ReadWrite
Create scheduling group Write Creates a scheduling group within a Teams schedule. Schedule.ReadWrite.All
Create time-off entry Write Creates a time-off entry for a user in a Teams schedule. Schedule.ReadWrite.All
Create time-off reason Write Creates a new time-off reason (e.g. Vacation, Sick Leave) for a Teams schedule. Schedule.ReadWrite.All
Get schedule Read-only Reads a team's Shifts schedule settings and provisioning state. Schedule.Read.All
List channel members Read-only Lists the members of a Teams channel and their roles. ChannelMember.Read.All
List channel messages Read-only Lists the messages in a Teams channel. ChannelMessage.Read.All
Group.ReadBasic.All
List channels Read-only Lists the channels in a Microsoft Team. Channel.ReadBasic.All
Group.ReadBasic.All
List chat messages Read-only Lists the messages in a Teams chat. Chat.Read
List chats Read-only Lists the Teams chats the user is part of. Chat.ReadBasic
List joined teams Read-only Lists the Microsoft Teams the user is a member of. Team.ReadBasic.All
List channel message replies Read-only Reads a Teams channel thread: its first post and the replies under it. Chat.Read
ChannelMessage.Read.All
Group.ReadBasic.All
List scheduling groups Read-only Lists the scheduling groups in a team's Shifts schedule. Schedule.Read.All
List time-off entries Read-only Lists booked time off on a team's Shifts schedule. Schedule.Read.All
List time-off reasons Read-only Lists the selectable time-off reasons on a team's Shifts schedule. Schedule.Read.All
Reply to channel message Write Replies to a message in a Teams channel. ChannelMessage.Send
Search chat messages Read-only Searches Teams chat and channel messages the user can access. Chat.Read
ChannelMessage.Read.All
Group.ReadBasic.All
Send channel message Write Posts a message in a Teams channel. ChannelMessage.Send
Send chat message Write Sends a message in a Teams chat. ChatMessage.Send
Update channel Write Updates a Teams channel's name or description. ChannelSettings.ReadWrite.All
Update channel message Write Edits a previously posted channel message. ChannelMessage.ReadWrite
Update chat Write Updates the topic of a Teams group chat. Chat.ReadWrite
Update chat message Write Edits a previously sent chat message. Chat.ReadWrite
Update scheduling group Write Updates a scheduling group's name, active status, or members. Schedule.ReadWrite.All
Update team Write Updates a Teams team's name, description, or visibility. TeamSettings.ReadWrite.All
Update time-off entry Write Updates an existing time-off entry. Schedule.ReadWrite.All

Permissions

The Required permissions column in the preceding tables lists the delegated Microsoft Graph permissions each action needs. Gemini Enterprise requests only the permissions for the actions you enable, plus the following, which every connection requests:

  • User.Read: reads the signed-in user's own profile, which identifies the account the connector acts as.
  • offline_access: lets the connector refresh its access token without asking the user to sign in again.

All permissions are delegated: the connector acts as the signed-in user and can only reach data that user can already reach.

With Google-managed OAuth, users consent to these permissions when they authorize the connector; some permissions require an Microsoft Entra administrator to consent for the organization. With your own app, you grant these permissions on the app registration. For details, see Configure Microsoft API permissions.

Limitations

This section outlines known issues and limitations that may affect your use of the Microsoft 365 data store.

  • When creating a new app or adding a data store to an existing one, it's recommended to associate only one data store with actions belonging to a single connector type.
  • Enforcing a VPC Service Controls perimeter on existing Microsoft 365 data stores is not supported. To enforce VPC Service Controls, you must delete and recreate the data stores. For more information on VPC Service Controls and how to use actions after enabling VPC Service Controls, see Secure your app with VPC Service Controls.
  • The Microsoft 365 data store is supported only in the global, us, and eu locations.

  • The Microsoft 365 data store maps one-to-one with a single Microsoft 365 tenant. It can't span multiple, isolated tenants within a Multi-Tenant Organization (MTO). You must create a dedicated data store for each distinct tenant.

  • Google-managed OAuth supports only tenants in the commercial Microsoft cloud (including GCC), and doesn't support static IP egress. For GCC High or DoD tenants, or to use static IP egress, use your own Microsoft Entra app.

  • Mailboxes must be fully migrated to Exchange Online. Mailboxes hosted on-premises in a hybrid Exchange environment aren't accessible through the Microsoft Graph API, and queries against them can return a MailboxNotEnabledForRESTAPI error.

What's next