Microsoft Excel

Overview

Connect your Microsoft account to read and write Excel workbooks stored in OneDrive using the Microsoft Graph Excel API. The Excel node works on three resources — Workbook, Worksheet, and Table — with OAuth2 authentication and automatic token refresh.

Getting Connected

1. Go to Dashboard → Credentials → Add Credential
2. Select Microsoft Excel from the credential type list
3. Give it a name and click Connect Microsoft Excel
4. Sign in with your Microsoft account and grant the requested permissions
5. Once connected, select this credential in the Excel node's config panel

Tokens are saved and refresh automatically. Works with personal Microsoft accounts and Microsoft 365 work/school accounts.

Workbook

• Get Many — list the Excel workbooks (.xlsx files) in your OneDrive, with their file IDs, names, and URLs

Worksheet

• Get Many — list the worksheets in a workbook
• Add — add a new worksheet (optionally named)
• Delete — delete a worksheet by name or ID
• Get Content — read a worksheet's used range, or a specific range (e.g. A1:C3), as a 2D array of values
• Clear — clear the worksheet's used range
• Update Range — write a JSON 2D array of values to a range

Table

• Add Row — append one or more rows to a table (JSON 2D array, no header)
• Get Columns — list a table's columns
• Get Rows — read a table's rows (optional max results)
• Lookup — return the rows where a named column matches a value

Addressing a workbook

The Workbook (File) ID field accepts either:

• a drive-item ID for a file in your own OneDrive (use Workbook → Get Many to find it), or
• a full sharing link (https://…sharepoint.com/…) for a file shared with you — paste the whole URL, not just the short code.

For a shared file, read operations download and parse the workbook so they work even when the file is in another drive or tenant. Writing to a file in another tenant requires a credential in that tenant.

Configuration

• Credential — select a Microsoft Excel OAuth2 credential
• Resource — choose Workbook, Worksheet, or Table
• Operation — the available operations change based on the resource
• Output Variable — variable name for the result (default: excel_result). Access via {{excel_result}} or {{$json}}
• Text fields support variable interpolation using {{variable_name}} syntax

Troubleshooting

• MFA / AADSTS50076 — the account requires multi-factor authentication. See Microsoft MFA & Conditional Access Errors and reconnect, completing the MFA prompt.
• Values must be a 2D array — Update Range and Add Row expect JSON like [["Name","Email"],["Jane","jane@example.com"]].
• 401 Unauthorized — reconnect the credential to restore access.

Required Credentials