Microsoft connectors

Overview

Zoho Creator provides built-in connectors for various popular Microsoft services, enabling seamless integration between your Creator applications and Microsoft’s tools. These connectors help you automate workflows, sync data, and perform various actions from within Zoho Creator.

The different connectors supported for Microsoft services are:

Microsoft Excel
Microsoft OneDrive
Microsoft OneNote
Microsoft To Do
Microsoft Outlook

These connectors operate in a bring your own credentials (BYOC) mode, meaning you'll need to provide your own credentials (client ID and client secret) to authorize and establish the connection.

Meta information

Connector	Microsoft Excel, Microsoft OneDrive, Microsoft OneNote, Microsoft To Do, and Microsoft Outlook
Authentication type	OAuth 2.0
Data centers	US, IN, EU, AU, CN, CA, SA, JP, and UAE
Applicable for	C5, C6
Website	https://www.microsoft.com/
Privacy policy	https://www.microsoft.com/en-us/privacy
API documentation	https://learn.microsoft.com/en-us/graph/overview

Setting up Microsoft connectors

To use any of the built-in Microsoft connectors in Zoho Creator, you need to configure OAuth 2.0 credentials via the Microsoft Azure portal. This allows secure communication between your Microsoft account and Zoho Creator. Follow these steps to generate your client ID and client secret:

Go to the Microsoft Azure portal and sign in with your Microsoft account.
Next, you need to register a new application by navigating to Azure services > App registrations.
Click New registration, then provide a name for your app. Under Supported account types, choose Accounts in any organizational directory and personal Microsoft accounts, which is the recommended option for most use cases. Under the Redirect URL section, select Web as the platform, and then add the Zoho Creator redirect URL: https://creator.zoho.com/integration/oauth/callback.
Note: The redirect URI will vary based on your data center (DC). For example, users in the EU DC should use creator.zoho.eu. Learn more about Creator URL patterns here.

Click Register.
Once the app is registered, copy the Application ID. This will be used as your client ID in Zoho Creator.
To generate the client secret, navigate to the Certificates and secrets section within your app registration page. Under Client secrets, click New client secret, then provide a description and select an expiry period.
Click Add to create it, and make sure to copy the Value immediately, as this is your client secret and will not be visible again.
To configure API permissions, go to the API permissions section and click Add a permission.

Select the relevant Microsoft service, such as Microsoft Graph, and add the necessary delegated permissions based on the connector you're using (for example, Mail.Read or Files.ReadWrite).
Once the permissions are added, click Grant admin consent to ensure they take effect.

Creating a Microsoft connector in Zoho Creator

Navigate to Microservices in the left pane and click + Create New. Then click Pick & Create next to Connections.
The list of built-in connectors will be displayed. Select the connector of the required Microsoft service to create a connection.
Make the required customizations in the Add connection pane and click Create And Authorize.
Next, the Link Account popup will be displayed requesting the Client ID and Client Secret. Paste the values copied from steps 4 & 6 in the previous section.
Click Authorize and you'll be redirected to Microsoft's authorization page.
Enter your authorization credentials and accept the access permissions. After successful authorization, the connection is ready to be used in your applications.

Where this connector can be used

Deluge

All actions supported through this connector can be performed using Deluge workflows: