1. General Information
Microsoft Excel for Office 365 is a cloud-based spreadsheet application that is part of the Microsoft 365 suite. It enables individuals and teams to create, edit, and collaborate on spreadsheets stored in OneDrive or SharePoint. Through the Microsoft Graph API, Excel Online workbooks, worksheets, tables, and cell data can be accessed and managed programmatically.
The OneTeg Office 365 Excel Connector integrates with the Microsoft Graph API and enables users to build automated workflows for reading and writing Excel workbook data, managing worksheets and tables, and interacting with cell ranges directly from the OneTeg flow builder.
The Office 365 Excel Connector uses the Microsoft Graph API — the same unified endpoint used by the Microsoft Teams, SharePoint, and OneDrive connectors. If you have already registered an Azure AD app for another Microsoft connector, you can reuse it by adding the appropriate Excel permissions.
2. Connect Office 365 Excel to OneTeg
The Office 365 Excel Connector authenticates via OAuth 2.0 Authorization Code flow using Azure Active Directory (Azure AD). The app registration process is identical to other Microsoft connectors.
For the full step-by-step Azure AD setup guide, refer to: Microsoft Teams Connector v1.0 → Section 2: Connect Microsoft Teams to OneTeg
When registering your app, use the name "OneTeg Office 365 Excel Connector" to keep it distinct. The only difference from the Teams setup is in Step 4 — API Permissions, where you need to add the following Microsoft Graph permissions:
Files.Read.All — Read access to files in OneDrive and SharePoint (required to access Excel workbooks)
Files.ReadWrite.All — Read and write access to files (required for updating Excel workbook data)
Sites.Read.All — Read access to SharePoint site collections (required for SharePoint-hosted workbooks)
offline_access — Maintain access without repeated sign-in (required for token refresh)
3. Connection Settings and Configuration for OneTeg
In OneTeg, navigate to Connections and create a new connection using the Office 365 Excel Connector. Fill in the settings below using the credentials obtained from your Azure AD app registration.
|
Settings Parameters |
Value / Sample Value |
Description |
Required (Y/N) |
|
Connection Name |
Office 365 Excel Connection |
Choose a name for your Connection |
Y |
|
Connector |
excel-office365Connector-v1.1 |
Auto-populated once the Office 365 Excel Connector is selected |
Y |
|
Endpoint URL |
Base URL of the Microsoft Graph API. This value is fixed and does not change |
Y |
|
|
Authentication |
OAuth |
Select OAuth from the dropdown |
Y |
|
Flows |
Authorization Code |
Select Authorization Code as the OAuth grant type |
Y |
|
Client ID |
Application (Client) ID |
Obtained from Azure Portal: Azure Active Directory → App Registrations → your app → Overview → Application (Client) ID |
Y |
|
Client Secret |
Client Secret Value |
Obtained from Azure Portal: Azure Active Directory → App Registrations → your app → Certificates & Secrets → Value. Copy immediately after creation |
Y |
|
Token URL |
Standard Microsoft identity token endpoint using the /common/ path — works across all Microsoft 365 tenants without requiring a specific Tenant ID |
Y |
|
|
Authorization URL |
Standard Microsoft identity authorization endpoint using the /common/ path |
Y |
|
|
Scopes |
Microsoft Graph default scope combined with offline_access for token refresh. The .default scope grants all permissions configured in the Azure AD app registration |
Y |
4. Supported Office 365 Excel Actions and Options
For the full list of supported endpoints, parameters, and options, see the page below: