Resources · n8n integration

Microsoft SharePoint n8n integrationAutomate Microsoft SharePoint with n8n.

Eleven operations, three resources, no trigger. The Microsoft SharePoint n8n integration reaches files in a document library, items inside a list, and the lists themselves. Since the node ships without a trigger, a Schedule or a Webhook starts the run. Written for ops teams who already live in SharePoint.

Verified Trustpilot reviews · AI, automation & growth agency

Why automate

What does the Microsoft SharePoint n8n integration actually cover?

The node links an n8n workflow to a SharePoint site and works on three resources: File for documents stored in a library, Item for the rows of a list, and List for the lists themselves. Eleven operations cover the round trip, reading a list, writing a row back, dropping a generated document into a folder.

Every operation opens with the same question: which site? The Site field sits on all eleven, and the folders, lists and items n8n offers next come from that choice.

First scenario, the weekly report. A Schedule Trigger fires, item.getAll reads a list of requests, Filter by Formula narrows the batch to what matters, and the rows land in a message posted through Slack or in a sheet handled by Microsoft Excel 365. Nobody opens SharePoint to copy anything.

Second scenario, the document that travels. A PDF generated earlier in the workflow goes into a library folder with file.upload, or the reverse: file.download pulls an existing document out as binary data so the next node can attach it to a message sent with Gmail. Same file, two directions, same three fields to fill.

Third scenario, the list that stays clean. A form submission arrives, item.upsert writes it into the list, and the workflow stops worrying about whether the entry already existed. Teams that keep a mirror of the same data in Google Sheets run the two writes side by side in one workflow.

Some work sits outside these eleven operations. That is what the HTTP Request node is for: it calls any endpoint of the API and reuses the same credential through predefined authentication, so a call the dedicated node does not carry still runs inside the workflow, with no second login to manage.

Two practical notes before building. Reading is paginated: with Return All off, Limit caps how many items come back, and a list longer than that limit returns truncated. And a required field left empty stops the node, which on this node means Site on every single operation. The wider comparison of the platform sits in the n8n review, and teams who want to get their hands on it can look at the n8n training.

Connect

How do you connect SharePoint to n8n?

  1. 01

    Drop the node into the canvas

    Search for Microsoft SharePoint in the node panel and add it. Its job description is short: interact with the Microsoft SharePoint API. Internally it is n8n-nodes-base.microsoftSharePoint, and it ships with n8n, so there is nothing to install and nothing extra to pay on the n8n side, whether the instance runs on n8n Cloud or self-hosted under the Community Edition.

  2. 02

    Create the Microsoft credential once

    A credential is the stored login n8n uses on your behalf. You build it once in the Credentials menu, then every workflow reuses it from the node's dropdown. This node has no authentication selector of its own: it takes the Microsoft credential and nothing else. The node documentation points to the shared Microsoft credentials page for the exact values to paste in.

  3. 03

    Pick a resource, then run one node alone

    Choose File, Item or List, then the operation. Start with list.getAll, which asks for nothing but Site: if the lists of that site come back, the credential works. From there the other fields become dropdowns fed by the site you selected, so folder and list names get picked, not typed from memory.

Actions

What can the Microsoft SharePoint node do?

The Microsoft SharePoint node exposes 11 operations across 3 resources. For each one: the node as you configure it in n8n, the required fields, and our field notes.

Resources × operations matrix
ResourceCreateGetGet ManyUpdateDeleteDownloadUploadCreate or Update
File
Item
List

File

3 operations
01

Download file

file.download

What you see in n8n

Notes & use cases

Takes a document out of a SharePoint library and hands it to the next node as binary data, ready to be attached, read or copied somewhere else.

Key parameters

  • Site: the site whose folders n8n retrieves, picked from the dropdown.
  • Parent Folder: the folder the file is downloaded from, / (Library root) when the document sits at the top of the library.
  • File: the document itself, selected by name, for example my-file.pdf.
Use cases
grab the signed contract kept for a customer, then let the next node attach it to the confirmation email.
02

Update file

file.update

What you see in n8n

Notes & use cases

Replaces what is already in the library instead of adding a second copy next to it. The file keeps its place, the version behind the name changes.

Key parameters

  • Site and Parent Folder: where the file to update lives, root of the library included.
  • File: the existing document to update.
  • Change File Content: whether the contents get updated at all.
  • Updated File Contents: the name of the input field holding the binary data, shown in the Binary tab of the Input panel on the left, often data.
  • Updated File Name: optional, and the original name stays if you leave it empty.
Use cases
refresh the monthly export everyone has bookmarked, without breaking the link they saved.
03

Upload file

file.upload

What you see in n8n

Notes & use cases

Writes a new document into a library folder from binary data produced earlier in the workflow.

Key parameters

  • Site: the site the folder list is retrieved from.
  • Parent Folder: the destination folder, or / (Library root).
  • File Name: the name the file gets once uploaded, so build it with an expression when it has to carry a date or a reference.
  • File Contents: the input field carrying the binary data, the one listed in the Binary tab of the Input panel, commonly data.
Use cases
a quote rendered as a PDF two nodes earlier lands straight in the client folder.

Item

6 operations
04

Create item in a list

item.create

What you see in n8n

Notes & use cases

Adds a row to a list that already exists. The list is never created here, only filled.

Key parameters

  • Site: the site n8n reads the available lists from.
  • List: the list the item is created in.
  • Columns: the mapper where each column of that list gets its value, typed in or pulled from the incoming item with {{ $json.field }}.
Use cases
every incoming support request becomes a row in the intake list, filled from the form payload rather than retyped by whoever opens the mailbox first.
05

Create or update item (upsert)

item.upsert

What you see in n8n

Notes & use cases

One operation for both cases: the item is created, or the existing one is updated. Handy when the workflow cannot know which of the two it is dealing with.

Key parameters

  • Site: the site holding the list.
  • List: the list the item is created or updated in.
  • Columns: the mapper carrying the values for that list's columns.
Use cases
a nightly sync that pushes the same customer records again and again stays flat instead of stacking near-duplicates for anyone who submitted twice.
06

Delete an item

item.delete

What you see in n8n

Notes & use cases

Removes one item from a list. There is nothing to undo afterwards, so the node usually sits behind an IF that checks a condition first.

Key parameters

  • Site: the site the lists are read from.
  • List: the list the item is deleted in.
  • Item: the item to delete, selected rather than described.
Use cases
clearing the temporary rows a workflow created for a campaign once the campaign is over, one item per execution.
07

Get an item

item.get

What you see in n8n

Notes & use cases

Reads a single item and puts its content into the workflow, so the following nodes work on real values instead of assumptions.

Key parameters

  • Site: the site the list belongs to.
  • List: the list the item is retrieved from.
  • Item: the item to get.
Use cases
before sending a reminder, re-read the row to check the current status, because the version captured at the start of the run may be an hour old.
08

Get many items

item.getAll

What you see in n8n

Notes & use cases

Reads several items at once, either the whole list or the subset that matches a formula. This is the reading operation most reporting workflows are built on.

Key parameters

  • Site and List: the site, then the list searched for items.
  • Filter by Formula: evaluated for each record, for instance fields/Title eq 'item1'. Leave it empty and all the items come back.
  • Return All: on, n8n walks the pages of the API and returns everything; off, Limit caps the number of items.
  • Fields: in Options, picks what the output carries, among id, webUrl, createdBy, lastModifiedDateTime and five others.
Use cases
pull the open tickets of the week to build the Monday recap.
09

Update item in a list

item.update

What you see in n8n

Notes & use cases

Changes the values of an item already sitting in a list, column by column, without touching the rest of the list.

Key parameters

  • Site: the site the lists are retrieved from.
  • List: the list the item is updated in.
  • Columns: the mapper where the new values are set for that list's columns.
Use cases
an approval received by email flips the status column of the matching row, and the person who approved never opens SharePoint at all.

List

2 operations
10

Get list

list.get

What you see in n8n

Notes & use cases

Returns the details of one list rather than its contents. Useful when the workflow needs to know about the container itself.

Key parameters

  • Site: the site the lists are retrieved from.
  • List: the list to retrieve.
Use cases
a first node reads the list details, and the branches after it decide what to do with the items, which keeps the site and list selection in one place instead of repeating it in every node.
11

Get many lists

list.getAll

What you see in n8n

Notes & use cases

Returns the lists of a site. It is also the shortest test available on this node, since Site is the only thing it needs.

Key parameters

  • Site: the site whose lists are retrieved.
  • Return All: on, every list comes back across the API pages; off, Limit sets the maximum.
Use cases
an inventory workflow that walks the lists of a site and hands each one to a loop, instead of a hardcoded list of names that nobody updates.
Need help

Need help automating Microsoft SharePoint with n8n?

A person reads every message.

FAQ

Microsoft SharePoint and n8n, the questions that come up

01Is the Microsoft SharePoint n8n integration free?
Yes on the n8n side. The node ships with n8n, so there is nothing to install and no extra cost to unlock it. That holds on n8n Cloud, the hosted offer run by n8n, and on a self-hosted instance under the Community Edition and its Sustainable Use license. A workflow behaves the same way in both places, which means a build started on Cloud can move onto your own server later without a rewrite. The eleven operations, the three resources and the fields described on this page are the same in either setup.
02Which credentials does the node need?
A Microsoft credential, created once in the Credentials menu of n8n and then reused by every workflow that touches SharePoint. The node itself has no authentication selector: there is no method to choose inside it, it simply picks the credential up from its dropdown. For the exact values to enter, the node documentation sends you to the shared Microsoft credentials page rather than describing them per node. One credential covers all eleven operations, so adding a second SharePoint node later means selecting the existing entry, not building a new login.
03What are the limits of the node?
Reading is the one to plan for. With Return All turned off, Limit sets the maximum number of items returned, so a list longer than that comes back truncated and the workflow silently works on a subset. Turn Return All on and n8n chains the pages of the API to bring everything back. For anything the node does not cover, the HTTP Request node calls any endpoint of the API and reuses the same credential through predefined authentication, so the workflow stays in one place with a single login to maintain.
04Can a workflow react to a SharePoint change in real time?
Not from SharePoint itself: this node has no trigger in n8n. The run always starts somewhere else. A Schedule Trigger fires at a fixed interval and the workflow reads with Get many items to see what moved. A Webhook node gives n8n a URL that a third-party service calls, which suits a form or an internal tool that can post. Or another tool's trigger starts the chain and SharePoint becomes the destination, which is the most common shape: something happens elsewhere, the file or the row lands here.
05n8n or Make for SharePoint?
It depends on where you want the workflows to live. Make is hosted, with no self-hosting option, and billed per operation, so the cost follows volume. n8n runs on n8n Cloud or on your own server, which matters when documents and list items should not leave your infrastructure. Both give you a visual canvas, and the logic you draw ends up fairly close. The honest split: high volume plus data you have to keep in house points to self-hosted n8n, while a small volume with no hosting appetite makes the difference marginal.
Hack'celeration Lab

Get our weekly integration tips.

No spam. Unsubscribe anytime.