I’m using n8n Cloud and I’m trying to build a workflow that:
reads data from emails via the Microsoft Outlook node, and
appends/updates rows in an existing Excel (.xlsx) file stored on my OneDrive, using the Microsoft Excel 365 node (operation: “Append or update a sheet”).
The Outlook node works correctly with the built‑in Microsoft 365 / Microsoft Excel credentials, but the Excel 365 node cannot see any of my workbooks:
In the Microsoft Excel 365 node, when I select
Resource: Workbook → Operation: Get Many → From list,
I get an empty list of workbooks, even though I am logged in with the same Microsoft account and I can see my .xlsx file in My files on OneDrive.
I also created a new test .xlsx file directly in Excel Online (excel.cloud.microsoft) on the same account and it is stored in OneDrive → My files, but the Excel 365 node still doesn’t show it in the workbook list.
My goal is simply to:
use the Microsoft Excel 365 node in n8n Cloud to select my existing .xlsx file from OneDrive as a workbook (in “Append or update a sheet”) and write rows into it.
Could you please help me understand why my OneDrive Excel file is not visible in the Excel 365 node workbook list on n8n Cloud, and what I need to change so that this workbook appears and can be used?
A couple things to check here,
Check if you are the owner of the sheet, becuase sometimes if the sheets are shared it would be sitting in someone else’s onedrive but it appears in your onedrive as well because it is shared.
and one better solution that you can try is by using the ID of the workbook.
Here’s how:
Open your Excel file in OneDrive or Excel Online
Copy the URL from your browser
Find the part after id= in the URL
Then in your Excel node, switch the workbook picker to “By ID” and paste that value in after that, everything works normally append rows, update sheets, whatever you need.
From your description your workflow looks fine just try the ownership of the file and try by using the ID as well.
And if both of them doesnt work i would suggest to check the scopes that youve provided to your OAuth web app in Azure.
Let me know if this helps you in anyway, or if you encounter any further problems with it.
Hi guys, thank for prompt response. @mohamed3nan unfortunately it says that it is not a valid workbook ID. Btw. I am using Append data to sheet node (Ms Excel 365)
@Deepankar yes, I am the owner of hte sheet.
As for OAuth web app in Azure, I have not provided anything in Azure, I thought that in n8n cloud it is done by default, as in case of Google Sheets for example.
Hi @Kamil_Jedrasik, welcome to the n8n community !
using personal OneDrive is bad, the ideal is to leave it in a SharePoint / Teams-backed folder (even a private one), then selecting it from there, once it was in a SharePoint document library, the Excel 365 node picked it up immediately. Might be worth trying if the dropdown stays empty.
This is a common issue. Even though your Outlook node works fine with the same Microsoft credentials, the Excel 365 node requires different OAuth scopes to access your OneDrive files. Outlook uses Mail.Read / Mail.ReadWrite, while the Excel node needs Files.ReadWrite to list and interact with your workbooks.
Here’s how to fix it:
1. If you’re using n8n Cloud’s built-in credentials:
Go to Credentials → find your Microsoft Excel 365 credential
Delete it and re-create it from scratch
When the Microsoft consent screen pops up, make sure you accept all the permissions requested (especially file access)
Sometimes the initial authorization doesn’t request the file scopes properly, and re-creating forces a clean consent
2. If you’re using custom OAuth credentials:
Go to your Azure App Registration → API Permissions
Make sure these delegated permissions are added:
Files.ReadWrite
Files.ReadWrite.All
Sites.ReadWrite.All (if using SharePoint)
Click “Grant admin consent” after adding them
Then go back to n8n, disconnect and reconnect the credential so it picks up the new scopes
3. Important: Personal vs Work account
If you’re using a personal Microsoft account (outlook.com, hotmail.com), some Graph API Excel endpoints have limitations. The Excel 365 node works best with a Microsoft 365 Business/Work account.
If you only have a personal account, consider using the OneDrive node instead to upload/download the file, or use the HTTP Request node with the Graph API directly.
4. Quick test to confirm it’s a scope issue:
Add an HTTP Request node with your Microsoft credentials
Set it to GET https://graph.microsoft.com/v1.0/me/drive/root/children
If this returns an error (403 Forbidden or empty), it confirms the credentials don’t have file access permissions
Hi, thank you so much for all the responses and all the help.
Today, for a moment, the issue seemed to be resolved — which is really strange, honestly — because for just a few minutes I was able to work with the file. It appeared normally in the list (not manually entered as an ID). Then suddenly it disappeared again and now it’s no longer there.
So I honestly have no idea what’s going on. It’s hard for me to say what could be causing this. Do you have any ideas? The Excel file I have on OneDrive showed up briefly, but now it’s gone again.
Just to add: I’m using n8n Cloud with a work account, and when I test the HTTP Request node, it does not return a 403 Forbidden error.
!