n8n + Microsoft Excel Integration: Automate Spreadsheets & Reports

The n8n Microsoft Excel integration connects your spreadsheets to over 400 apps and services, turning Excel from a passive data store into an active part of your automation stack. Whether you're pulling sales figures into a weekly report or pushing form responses into a tracking sheet, n8n handles the data flow so you can stop doing it manually.

Recent n8n updates have added custom scopes for Excel and Teams credentials, giving you finer control over permissions. That means your workflows only access exactly the workbooks and sheets they need — nothing more.

Why Automate Microsoft Excel with n8n

Microsoft Excel remains the default reporting and data tool for most businesses. The problem is that keeping spreadsheets current requires manual effort — downloading CSVs, copying rows between tabs, reformatting data. That's where n8n comes in.

With n8n's Microsoft Excel node, you can:

• Read rows from any workbook stored in OneDrive or SharePoint
• Append rows to existing tables as new data arrives
• Update specific cells based on matching criteria
• Delete rows that meet certain conditions
• List worksheets and workbooks programmatically

Unlike VBA macros that live inside a single file, n8n workflows run on a server and can connect Excel to Slack, databases, CRMs, payment systems, and AI models in a single flow. And because n8n is open-source with a visual builder, you don't need to write Microsoft Graph API calls by hand.

Connecting Microsoft Excel to n8n

The Microsoft Excel node uses OAuth 2.0 to authenticate through your Microsoft account. Here's how to set it up:

1. Open your n8n instance and add a new Microsoft Excel 365 node to your workflow canvas
2. Click Create New Credential under the Microsoft Excel API
3. Register an application in the Azure Portal under App Registrations
4. Set the redirect URI to your n8n instance's OAuth callback URL (e.g., https://yourname.n8nautomation.cloud/rest/oauth2-credential/callback)
5. Under API Permissions, add Files.ReadWrite and Sites.ReadWrite.All for SharePoint access
6. Copy the Application (client) ID and Client Secret back into n8n
7. Click Connect and authorize through the Microsoft login flow

If you're running n8n on n8nautomation.cloud, your instance already has a stable HTTPS URL and persistent storage, so OAuth tokens are preserved across restarts — no re-authentication headaches.

Workflow 1: CRM to Excel Data Sync

Keep your sales spreadsheet current without lifting a finger. This workflow pulls new and updated deals from your CRM into an Excel workbook on a schedule.

Nodes used:

• Schedule Trigger — runs every hour (or whatever cadence you need)
• HubSpot node (or Salesforce, Pipedrive) — Get All Deals operation, filtered by lastModifiedDate in the last hour
• Set node — maps CRM fields to your Excel column names: Deal Name, Stage, Amount, Close Date, Owner
• Microsoft Excel 365 node — Append operation targeting your Sales Pipeline workbook, Table1

To avoid duplicates, add an IF node before the Excel node that checks whether a row with the same Deal ID already exists. If it does, use the Update operation instead of Append. You can look up existing rows using the Microsoft Excel 365 node with the Get Rows operation and a filter on the Deal ID column.

Workflow 2: Automated Weekly Reports

This is where n8n Excel automation really shines. Instead of spending Friday afternoon pulling numbers from five different tools, build a workflow that does it for you.

Nodes used:

• Schedule Trigger — every Friday at 9:00 AM
• Stripe node — Get All Charges for the past 7 days to get revenue figures
• Google Analytics node — pull weekly traffic and conversion metrics
• PostgreSQL node — query for new signups, active users, or any custom metrics
• Merge node — combine all data sources into a single item
• Microsoft Excel 365 node — Append a new row with the week's date and all metrics into your Weekly KPIs workbook
• Slack node — post a summary message to your team channel with a link to the updated spreadsheet

Each week, a new row gets added to your Excel report. Over time you build a clean historical dataset without touching the spreadsheet manually. Your team gets a Slack ping when it's ready.

Workflow 3: Form Submissions to Excel

Capture leads, survey responses, or support requests directly in an Excel workbook. This works with any form tool that supports webhooks.

Nodes used:

• Webhook node — receives POST requests from Typeform, Google Forms (via Apps Script), or any form builder
• Set node — extracts and renames fields: Name, Email, Company, Message, Submitted At
• Microsoft Excel 365 node — Append to your Leads workbook
• Gmail node (optional) — sends a confirmation email to the respondent

For Google Forms specifically, you can use the n8n Google Forms Trigger node to skip the webhook entirely. The form submission triggers the workflow directly, and the data lands in Excel within seconds.

Workflow 4: Excel to Database Pipeline

Many teams receive data as Excel files — from vendors, partners, or internal departments — that needs to end up in a database. This workflow automates the import.

Nodes used:

• Schedule Trigger or Microsoft OneDrive Trigger — detects new or modified files in a specific folder
• Microsoft Excel 365 node — Get Rows to read all data from the target sheet
• Set node — clean and transform data: trim whitespace, parse dates, convert currency strings to numbers
• IF node — validate rows (skip any with missing required fields)
• PostgreSQL node (or MySQL, MongoDB) — Insert or Upsert rows into your database table

This pattern is common in finance teams that receive expense reports as Excel files, or operations teams that get inventory updates from suppliers. Instead of manually importing CSVs, the pipeline runs automatically whenever a new file appears.

Workflow 5: AI-Powered Excel Data Analysis

Combine n8n's AI capabilities with Excel data for automated insights. This workflow reads spreadsheet data, sends it to an AI model for analysis, and writes the results back.

Nodes used:

• Schedule Trigger — runs daily or on demand via webhook
• Microsoft Excel 365 node — Get Rows from your customer feedback or support ticket sheet
• Code node — formats the data into a structured prompt (e.g., "Analyze these 50 support tickets and categorize them by topic and sentiment")
• OpenAI node (or Google Gemini) — processes the prompt and returns structured analysis
• Set node — parses the AI response into columns: Category, Sentiment, Priority, Summary
• Microsoft Excel 365 node — Update or Append the analysis results back into a separate sheet in the same workbook

This is particularly useful for customer feedback analysis, categorizing expense line items, or flagging anomalies in financial data. The AI does the thinking; Excel stays your single source of truth.

Tips for Reliable Excel Automation

After building dozens of Excel workflows, here are the patterns that keep things running smoothly:

• Always use Excel Tables — the n8n node works with named Tables inside workbooks, not raw cell ranges. Select your data range in Excel and press Ctrl+T to create a Table before building your workflow.
• Use consistent column headers — the Excel node maps data by column header names. If someone renames a column, the workflow will fail. Lock down your headers or add error handling to catch mismatches.
• Batch your writes — if you're appending hundreds of rows, the Excel API has rate limits. Use n8n's Split In Batches node to process 50-100 rows at a time with a short wait between batches.
• Handle empty cells gracefully — use the IF node or expressions like {{ $json.email || 'N/A' }} to provide default values instead of writing blank cells that break downstream formulas.
• Set up error handling — add an Error Trigger workflow that alerts you via Slack or email if an Excel workflow fails. Common failures include expired OAuth tokens and deleted workbooks.

Microsoft Excel isn't going anywhere. It's still where most business data lives, gets reviewed, and gets shared. By connecting it to n8n, you turn those static spreadsheets into live, automated data pipelines. Pick one of the workflows above, build it in 20 minutes, and reclaim the hours you've been spending on manual data entry.

If you want a dedicated n8n instance with a stable URL for OAuth credentials and always-on scheduling, n8nautomation.cloud has you covered from $15/month — no server setup required.