- Home
- Resources
- Integrations
- Microsoft SharePoint
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
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.
How do you connect SharePoint to n8n?
- 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. - 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.
- 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.
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.
| Resource | Create | Get | Get Many | Update | Delete | Download | Upload | Create or Update |
|---|---|---|---|---|---|---|---|---|
| File | ✓ | ✓ | ✓ | |||||
| Item | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||
| List | ✓ | ✓ |
Operations index
File
3 operationsDownload file
file.downloadWhat 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.
Update file
file.updateWhat 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.
Upload file
file.uploadWhat 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.
Item
6 operationsCreate item in a list
item.createWhat 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 }}.
Create or update item (upsert)
item.upsertWhat 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.
Delete an item
item.deleteWhat 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.
Get an item
item.getWhat 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.
Get many items
item.getAllWhat 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,lastModifiedDateTimeand five others.
Update item in a list
item.updateWhat 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.
List
2 operationsGet list
list.getWhat 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.
Get many lists
list.getAllWhat 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.
Need help automating Microsoft SharePoint with n8n?
A person reads every message.
Microsoft SharePoint and n8n, the questions that come up
01Is the Microsoft SharePoint n8n integration free?
02Which credentials does the node need?
03What are the limits of the node?
04Can a workflow react to a SharePoint change in real time?
05n8n or Make for SharePoint?
Get our weekly integration tips.
No spam. Unsubscribe anytime.



