Microsoft Excel 365 append row into foreign spreadsheet

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

hello @henk23

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.

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.