Microsoft Excel 365 append row into foreign spreadsheet

[henk23]

Describe the problem/error/question

I want to add a row into a Microsoft Excel (365/online) spreadsheet that I don’t own / was shared with me.

It works perfectly when the spreadsheet has been created by me and lives in my own OneDrive, but I can’t seem to access any other spreadsheets, like the ones of Groups I’m in or ones that have been shared with me.

Main use case as a Web Dev Freelancer is that one of my Web Apps can write data directly into the spreadsheet of my client, so we save the step “export to / download xlsx file”.

Not sure if this is possible at all, and if yes how I can achieve this? Do I need to do something about the OAuth? Does my Azure App need a special setting? Does my client have to authorize my Azure App to use inside his OneDrive?

Maybe this is very trivial, but I could not find any information about this, I unfortunately also don’t have any knowledge/experience in Azure.

What is the error message (if any)?

There is no error.

Information on your n8n setup

• n8n version: 1.32.1
• Database (default: SQLite): SQLite
• n8n EXECUTIONS_PROCESS setting (default: own, main): own, main
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
• Operating system: Ubuntu 22

[barn4k]

hello @henk23

@henk23

Does my client have to authorize my Azure App to use inside his OneDrive?

I suppose that is what you need. OAuth Apps works with permissions. If you want to access someone’s OneDrive, your app must have permissions to access it.

[henk23]

Okay, that’s what I thought. The question is: How do I do that? Can I just send them a link? The Azure App platform has sooo many options and half of them are for all kinds of Auth and permissions. I clicked through everything but could not find something that sounds remotely like what I need.