Excel365 not working with personal account

Hello,

I’ve got a problem with the Excel365 node. I’d appreciate any help :slight_smile:

Describe the problem/error/question

The node does not return any workbooks as seen below. I set up the credential exactly as in the docs.

What is the error message (if any)?

Not even an error message, just no restults as if my workbooks don’t exist at all.

Information on your n8n setup

  • n8n version: 1.81.4

I’ve just checked my emails and the security notification from Microsoft came on my second account. Which is kind of strange, as I’ve been logged in with my main in my browser.
So that could be the issue, I’ll take a look this evening and give an update - hopefully it just connected the wrong account :sweat_smile:

hello @tom.jdg

in order to see resources, you should enable an API permission Cloud Resource Manager API

however, you should be able to access the document/spreadsheet by it’s ID

Hi there,

thanks for your answer. I unfortunately couldn’t get it to work - could it be that your suggestion is for connecting Google services? As I can’t find anything like that on Azure.

Kind regards :slight_smile:

ah… you have an Azure node. I thought it was a google spreadsheet.

Were you able to access the Workbook by its ID? If you can access it, then you didn’t have enough permissions to list resources. Otherwise, it may be another issue with permissions (like the account you are connecting from doesn’t have access to the spreadsheet)

Yeah it’s the Excel365 node. Accessing it by its ID isn’t really working, as I’m trying to append rows to my table for which I’d also need the ID of each column.

I gave my app the Files.ReadWrite permission scope as written in the docs:

My spreadsheet is saved in my personal OneDrive, and I’ve double checked that it’s the account authorized with n8n.

I’m really clueless what I’m doing wrong :sweat_smile:

what’s inside the three dots on the right on the permissions page? Is there an option to grant permission?

Nope, I’m only able to revoke the permission there :sweat_smile:

Could this be the source of the issue? (I am having the same problem and noticed my work access works fine but not personal — both using Azure)

Note : Support for workbooks stored in OneDrive Consumer platform is still not available. At this time, only the files stored in business platform are supported by Excel REST APIs.

Link below:

Source