We are going to see today how we can get data from Excel in Microsoft 360 using n8n.
The first thing we will do is create an app and credentials from https://portal.azure.com/.
Login with your Microsoft account.
Search: “App registrations” > click on “New registration”
We add the app name and select:
Accounts in any organizational directory (any Microsoft Entra multi-tenant tenant) and personal Microsoft accounts (e.g. Skype, Xbox)
We added the block of Microsoft Excel 360
We open it and click on add new credential, which will open a credential of type Microsoft 360.
The redirect URI is the OAuth Redirect URL
https://n8n.dominio.com/rest/oauth2-credential/callback
*Replace n8n.dominio.com with your actual credentials.
We copied it to add it to the app we’re creating in Microsoft 360 and now select web.
And click on register.
NOW we need to copy the app ID
And paste it into the n8n credentials we’re creating.
And now we’re going to create the client ID
We click on Credentials of Client > Add Certificate or Secret
We click on new Client Secret, fill in the data and copy the VALUE.
It is pasted inside of Secret Client in our credentials configuration of n8n.
Now we click on Connect My Account and a connection window will appear.
We will be asked if we allow n8n to access our One Drive information. Clicking on it and we will have the connection ready.
Now clicking on the API Calls Permissions View, we can select the permissions we need for our API.
We choose Microsoft Graph
We chose Delegated Permissions and if we want to choose Excel, we will add the following permissions:
Files.ReadWrite.Alloffline_accessUser.Read
