Resources · Make integration

Microsoft SharePoint Online Make integrationAutomate Microsoft SharePoint Online with Make.

What can SharePoint do on its own once Make watches it? The Microsoft SharePoint Online Make integration gives you 36 modules: 7 triggers, 22 actions and 7 searches over lists, items, pages, sites and files. This guide is for ops and IT people who want to connect an account, build a first scenario and pick the right module without writing code.

Try the Microsoft SharePoint Online integration on MakeSee the 36 modules

Verified Trustpilot reviews · AI, automation & growth agency

What you can automate

What does the Microsoft SharePoint Online Make integration do?

It links your SharePoint Online account to Make so a scenario, the automation you build in Make, can read and change your SharePoint content for you. Make can watch sites for new files, list items and pages, then create, update or delete items, upload or download files and publish pages, all from a visual editor.

Requests that log themselves. A form or a message in another app becomes a new row in a SharePoint list through Create an Item, and Update an Item changes its status later, so nobody retypes anything.

Files that land in the right place. Watch Files/Folders spots a new document on a site, Download a File hands it to the next module, and Upload a File does the reverse when an attachment arrives elsewhere and belongs in SharePoint.

An intranet that stays current. Watch Pages notices an edited page, Get a Page reads it, and Publish a Page pushes the latest version live once the content is approved.

Know the limits before you start. The doc warns that Microsoft Graph APIs in beta can change and are not supported in production, and that each module still needs its lower level permissions even if you granted ReadWrite. Only followed sites show up in the Site ID list; any other site takes its ID typed by hand. The same app also has an n8n node: see the Microsoft SharePoint Online n8n integration and the n8n vs Make comparison. Before committing, read the Make review.

Connect

How do you connect SharePoint Online to Make?

  1. 01

    Add a SharePoint module

    In your Make account, open a scenario and add any Microsoft SharePoint Online module. Make then asks for a connection, meaning your Microsoft account linked to Make once and reused by every SharePoint module. Click Create a connection.

  2. 02

    Name it and check the options

    Type a label in Connection name if you manage several tenants. Show advanced settings is optional: it takes your own app client credentials and extra scopes. If Microsoft asks for a redirect URI for that custom app, use https://www.integromat.com/oauth/cb/azure.

  3. 03

    Save and sign in

    Click Save. A Microsoft window opens when authentication is needed: sign in with the account that owns the sites you want to automate and confirm the access. The connection then appears in every SharePoint module of your scenarios.

First scenario

Your first scenario: file an attachment in SharePoint and log it

GoalWhen a file arrives in another app, Make uploads it to a SharePoint site and adds a row to a tracking list.

  1. 01

    Create the scenario

    On the Scenarios page, create a new scenario and click the + to add the first module: the app where your files come in, such as your mailbox with its attachments.

  2. 02

    Add Upload a File

    Click the + on the right, search Microsoft SharePoint Online and pick Upload a File. Create the connection, choose the site from the list Make shows, and map the file coming from the first module.

  3. 03

    Log it with Create an Item

    Add Create an Item after the upload and point it at your tracking list. Map the file details from earlier modules so each upload leaves a readable trace.

  4. 04

    Test with Run once

    Click Run once and send yourself a test file. Open each module bubble to read the bundles it received, the items passed from one module to the next, then check the site and the list.

  5. 05

    Schedule and switch on

    Set the schedule on the first module, every 15 minutes by default, and switch the scenario on. Each module run on each bundle counts as one operation on your Make plan.

Triggers

What can start a SharePoint scenario?

7 modules start a scenario when something happens in Microsoft SharePoint Online. A scheduled trigger is checked by Make on the scenario's schedule; an instant one is called by Microsoft SharePoint Online as soon as it happens.

Microsoft SharePoint Online1Watch Items - User.Read, Sites.Read.All, offline_access

Watch Items - User.Read, Sites.Read.All, offline_access

triggerIn the docs only

This entry gives you the list item watcher as the permission table of the doc presents it, so you know which delegated scopes your Azure app registration needs: User.Read, Sites.Read.All and offline_access.

How it fires
scheduled, Make checks the app on the scenario's schedule and picks up what changed since the last check.
When to use it
you connect through your own app credentials and want a trigger on list rows that only reads the site.
Watch out
the doc says a higher permission such as ReadWrite does not replace these lower scopes, so set them all.
Microsoft SharePoint Online2Watch Lists - User.Read, Sites.Read.All, offline_access

Watch Lists - User.Read, Sites.Read.All, offline_access

triggerIn the docs only

Here you get the list watcher with its scopes spelled out, which saves a round of trial and error when an administrator sets up the Azure app behind your connection.

How it fires
scheduled, Make checks the app on the scenario's schedule rather than being called by SharePoint.
When to use it
a governance scenario that reacts when someone creates or reshapes a list, run under a custom app with read access only.
Watch out
the doc lists it without a description, so compare its output with Watch Lists in a Run once before relying on it.
Microsoft SharePoint Online3Watch Pages - User.Read, Sites.Read.All, offline_access

Watch Pages - User.Read, Sites.Read.All, offline_access

triggerIn the docs only

You get a page watcher documented together with the three delegated permissions it needs, handy when your IT team grants scopes one by one in the Azure portal.

How it fires
scheduled, Make checks the app on the scenario's schedule, so a page edit shows up at the next run.
When to use it
an intranet review flow on a tenant where your own app registration is mandatory.
Watch out
page features may rely on Microsoft Graph APIs in beta, which the doc says can change and are not supported in production.
Microsoft SharePoint Online4Watch Files/Folders

Watch Files/Folders

Scheduled trigger

In Make“Triggers when a file or folder is created or updated in a specified site.”

Watch Files/Folders starts your scenario when a file or folder is created or updated on the site you pick, so documents flow onward without anyone forwarding them.

How it fires
scheduled, Make checks the app on the scenario's schedule, every 15 minutes by default.
When to use it
a shared document library where signed contracts land and need to reach an archive or a notification channel.
Watch out
updates fire it too, so an edited file comes through again and the next modules run a second time.
Microsoft SharePoint Online5Watch Items

Watch Items

Scheduled trigger

In Make“Triggers when an item on a specified list is created or modified.”

Watch Items hands you every row of a chosen list created or modified since Make's last check, which turns a SharePoint list into a queue your scenario can work through.

How it fires
scheduled, Make checks the app on the scenario's schedule and returns each new or changed item as a bundle.
When to use it
an IT request list or a purchase approval list whose rows should alert someone or feed another tool.
Watch out
if the same scenario updates items of that list, it will see its own changes and loop.
Microsoft SharePoint Online6Watch Lists

Watch Lists

Scheduled trigger

In Make“Triggers when a list is created or modified.”

Watch Lists tells your scenario that a list was created or changed, which is the way to keep an eye on the structure of a site rather than on its rows.

How it fires
scheduled, Make checks the app on the scenario's schedule and reports the lists created or modified since.
When to use it
you run many project sites and want a register of every new list, or a heads up when a key list changes.
Watch out
it reports lists, not their items; pair it with List Items when you need the content too.
Microsoft SharePoint Online7Watch Pages

Watch Pages

Scheduled trigger

In Make“Triggers when a page is modified.”

Watch Pages brings you each page that was modified, so edits to the intranet can trigger a review, a message to the owner or a copy elsewhere.

How it fires
scheduled, Make checks the app on the scenario's schedule, never the instant an author clicks save.
When to use it
a communications team that wants to know when a policy or news page moves, then approve it before Publish a Page.
Watch out
it reacts to modified pages, so a quick typo fix also starts a run; keep the next step light.
Modules

What can the SharePoint modules do?

Microsoft SharePoint Online gives you 29 modules in 2 groups. For each one: what it does for you, when to reach for it, and what to watch out for.

The Microsoft 365 Email module can have the following delegated permissions assigned in the Azure portal.

12 modules

Even if you have assigned higher level permissions (e.g., ReadWrite) it is still necessary to set the lower permissions for the modules as listed below.

Create a Folder - User.Read, offline_access, Files.ReadWrite.All, Sites.Read.All

Download a File - User.Read, Files.Read.All, Sites.Read.All, offline_access

Upload a File - User.Read, Files.ReadWrite.All, Sites.ReadWrite.All, offline_access

Watch Files/Folders - User.Read, Files.Read.All, Sites.Read.All, offline_access

Microsoft SharePoint Online1

Create a List - User.Read, Sites.Manage.All, offline_access

ActionIn the docs only

You get the list creation module with its required scopes, and note the one that stands out: Sites.Manage.All, a step above the read and write scopes of the other entries.

When to use it
your admin must grant exactly what is needed on a custom Azure app.
Watch out
the doc says ReadWrite does not replace Sites.Manage.All, so grant it.
Microsoft SharePoint Online2

Create an Item - User.Read, Sites.ReadWrite.All, offline_access

ActionIn the docs only

This entry maps the new row module to its scopes, so writing into a list works on the first try once Sites.ReadWrite.All is on your app registration.

When to use it
you connect with your own client credentials through Show advanced settings.
Watch out
the doc gives it no description; test it with Run once on a sandbox list.
Microsoft SharePoint Online3

Delete an Item - User.Read, Sites.ReadWrite.All, offline_access

ActionIn the docs only

You learn which scopes the delete module needs before your admin opens the Azure portal: write access to sites plus the basic profile and offline scopes.

When to use it
a cleanup scenario under a custom app registration.
Watch out
your scenario cannot undo a deletion, so run your first tests on a copy of the list.
Microsoft SharePoint Online4

Get a List - User.Read, Sites.Read.All, offline_access

ActionIn the docs only

Reading one list's data only takes read scopes, and this entry confirms it, which keeps your custom app from asking users for more than it uses.

When to use it
a reporting scenario that should never be able to write to SharePoint.
Watch out
the doc only names it in the permission table, so check its output in a test run.
Microsoft SharePoint Online5

Get an Item - User.Read, Sites.Read.All, offline_access

ActionIn the docs only

Fetching a single row runs on read access alone, and this listing gives the three scopes to tick so an audit of your app shows nothing extra.

When to use it
a read only lookup inside a scenario built on your own Azure credentials.
Watch out
scopes are delegated, so the signed in account must also see that list.
Microsoft SharePoint Online6

Get a Page - User.Read, Sites.Read.All, offline_access

ActionIn the docs only

Reading a page needs nothing beyond Sites.Read.All with User.Read and offline_access, which this entry makes explicit for your app registration.

When to use it
you copy intranet content to another tool and want a connection that cannot change pages.
Watch out
page endpoints may be in Microsoft Graph beta, which the doc says can change.
Microsoft SharePoint Online7

List Items - User.Read, Sites.Read.All, offline_access

SearchIn the docs only

This search returns the rows of a list with read scopes only, and the table shows exactly which ones, so an export scenario stays harmless for your data.

When to use it
a backup or report flow under a custom Azure app.
Watch out
each row comes out as its own bundle, and every module after it runs once per row.
Microsoft SharePoint Online8

List Pages - User.Read, Sites.Read.All, offline_access

SearchIn the docs only

You can inventory the pages of a site with read access only; this entry names the scopes your admin grants for that search to work.

When to use it
building a content audit of an intranet from a scenario that must stay read only.
Watch out
one bundle per page means one operation per page for each module downstream.
Microsoft SharePoint Online9

Make an API Call - offline_access, User.Read

ActionIn the docs only

The free form call only asks for offline_access and User.Read by default, so the scopes of the endpoint you target are yours to add in the advanced settings of the connection.

When to use it
you call an endpoint no listed module covers.
Watch out
without the scope of that endpoint, expect a refused call; check it with Run once.
Microsoft SharePoint Online10

Publish a Page - User.Read, Sites.ReadWrite.All, offline_access

ActionIn the docs only

Pushing a page live requires write access to sites, and this entry lists it next to User.Read and offline_access so your custom app can publish without errors.

When to use it
an approval flow that ends with publication under your own Azure credentials.
Watch out
the read scopes of Watch Pages are not enough for this step.
Microsoft SharePoint Online11

Search Sites - User.Read, Sites.Read.All, offline_access

SearchIn the docs only

Finding sites by keyword works with read scopes, and this listing gives you the set to grant so the search sees every site your account can open.

When to use it
a custom app scenario that first locates a site before touching its lists.
Watch out
the account's own SharePoint access still limits what comes back.
Microsoft SharePoint Online12

Update an Item - User.Read, Sites.ReadWrite.All, offline_access

ActionIn the docs only

Changing an existing row needs Sites.ReadWrite.All, and seeing it written next to the module avoids the classic permission error on the first run of a custom app.

When to use it
a status update flow built on your own client ID.
Watch out
the doc insists that higher permissions do not replace the lower ones listed.

Other modules

17 modules
Microsoft SharePoint Online13

Create a Folder

Action

In Make“Creates a folder in OneDrive.”

Create a Folder gives each new project or client its own folder, ready before the first document arrives. The official description places that folder in OneDrive.

When to use it
a deal is won in your CRM and the team needs a place to drop the files.
Watch out
it needs Files.ReadWrite.All and Sites.Read.All on top of User.Read and offline_access.
Microsoft SharePoint Online14

Create a List

Action

In Make“Creates a new list.”

Create a List sets up a brand new list on a site from your scenario, so a tracker exists the moment a project starts instead of when someone remembers to build it.

When to use it
each new client site should come with the same task or request list.
Watch out
it runs once per bundle, so a search in front of it can create several lists at once.
Microsoft SharePoint Online15

Create an Item

Action

In Make“Creates a new item.”

Create an Item adds a new row to a SharePoint list with the values you map, which turns a form, an email or a CRM record into a tracked entry.

When to use it
requests arrive in another app and the team works from a SharePoint list.
Watch out
if Watch Items listens to the same list in this scenario, the new row wakes it up again.
Microsoft SharePoint Online16

Delete an Item

Action

In Make“Deletes an Item.”

Delete an Item removes a row from a list, which keeps trackers clean when the source record disappears or a request is withdrawn.

When to use it
a cancelled order or a closed ticket in another app should also leave SharePoint.
Watch out
the scenario cannot bring the row back, so put a filter before this module and test it on a copy.
Microsoft SharePoint Online17

Download a File

Action

In Make“Downloads a file from a specified site.”

Download a File pulls a document from a site into your scenario, so the next module can attach it, archive it or send it to another service.

When to use it
right after Watch Files/Folders, to hand a new contract to an e-signature or storage app.
Watch out
on the Free plan Make handles files up to 5 MB, so heavy documents need a paid plan.
Microsoft SharePoint Online18

Get a List

Action

In Make“Returns the data of a specified list.”

Get a List returns the data of one list you point to, which gives later modules its details without searching through every list of the site.

When to use it
you know which list to read and need its information to route or log something.
Watch out
it describes the list itself; the rows come from List Items.
Microsoft SharePoint Online19

Get an Item

Action

In Make“Returns the data of a specified item.”

Get an Item reads one row in full, so you can work with its latest values rather than the partial data another module handed over.

When to use it
a trigger gives you an ID and you need the complete record before emailing a manager.
Watch out
it needs a known item; to find rows by their content, start with List Items.
Microsoft SharePoint Online20

Get a Page

Action

In Make“Returns the data of a specified page.”

Get a Page returns the data of a chosen page, which lets you copy intranet content into a newsletter, a wiki or an archive.

When to use it
after Watch Pages, to read the edited page before notifying its owner.
Watch out
the doc warns that Microsoft Graph beta APIs can change, so retest this step if the output shifts.
Microsoft SharePoint Online21

Get a Site

Action

In Make“Returns the data of a specified site.”

Get a Site returns the data of one site, handy for naming the site in plain words in a message instead of a raw ID.

When to use it
a scenario covering several sites needs to say which one an event came from.
Watch out
a site you do not follow is missing from the drop-down; type its Site ID yourself.
Microsoft SharePoint Online22

Make an API Call

Action

In Make“Performs an arbitrary authorized API call.”

Make an API Call lets you reach any endpoint of the Microsoft API with your existing SharePoint connection, which covers what the other modules leave out.

When to use it
you need an operation that no listed module offers.
Watch out
Microsoft Graph endpoints in beta can change without notice and are not supported in production, so prefer stable ones.
Microsoft SharePoint Online23

Publish a Page

Action

In Make“Publishes the latest version of a page.”

Publish a Page puts the latest version of a page live, so an approval in another tool can end with the page online without a manual click.

When to use it
a manager approves a news post and it should reach the intranet right away.
Watch out
it publishes the latest version, including edits made after the approval.
Microsoft SharePoint Online24

Update an Item

Action

In Make“Updates an existing item.”

Update an Item changes the values of an existing row, which keeps a SharePoint tracker in step with what happens in your other tools.

When to use it
a ticket is closed elsewhere and the matching list row should switch to Done.
Watch out
Watch Items sees modified rows, so updating the watched list in the same scenario creates a loop.
Microsoft SharePoint Online25

Upload a File

Action

In Make“Uploads a new file to a specified site.”

Upload a File drops a new document on the site you choose, so attachments and exports end up in the shared library instead of someone's inbox.

When to use it
invoices received by email should live in the finance site.
Watch out
it needs Files.ReadWrite.All and Sites.ReadWrite.All, and the Free plan caps files at 5 MB.
Microsoft SharePoint Online26

List Items

Search

In Make“Retrieves a list of all items in a specified list.”

List Items returns all the rows of a list, one bundle each, so you can export a tracker, check each entry or feed a report.

When to use it
a summary of open requests built when a manager asks for it, or a sync of a list into a spreadsheet.
Watch out
each row counts as an operation for every module that follows, which adds up on long lists.
Microsoft SharePoint Online27

List Lists

Search

In Make“Retrieves a list of all lists.”

List Lists gives you every list of a site as separate bundles, a quick way to map what a site contains before you automate it.

When to use it
auditing project sites or picking the list to act on by its name.
Watch out
every list is its own bundle, so check the name before acting on the results.
Microsoft SharePoint Online28

List Pages

Search

In Make“Retrieves a list of all pages.”

List Pages returns the pages of a site one by one, the starting point for an intranet inventory or a bulk review.

When to use it
checking which pages exist before copying or republishing them.
Watch out
every page is a bundle, so a Get a Page after it runs once per page and counts operations each time.
Microsoft SharePoint Online29

Search Sites

Search

In Make“Searches for sites by the searching parameter.”

Search Sites finds sites matching the words you give it, useful when the site to use depends on a client or a project name coming from another app.

When to use it
routing a document to the site named after the customer.
Watch out
the search may return zero, one or several sites; handle each case before uploading.
Need help

Need help automating Microsoft SharePoint Online with Make?

A person reads every message.

FAQ

Microsoft SharePoint Online Make integration: common questions

01Is the Microsoft SharePoint Online Make integration free?
Yes, SharePoint Online is a standard app in Make, so it works on the Free plan as well as on paid ones. The Free plan still has limits: 2 active scenarios, at least 15 minutes between scheduled runs, 5 minutes per execution, files up to 5 MB and 512 MB of data transfer. Paid plans lower the interval to 1 minute and allow 40 minutes per run. Make counts operations, one module run on one bundle, so long lists use your credits faster. On the Microsoft side, you also need a SharePoint Online user account.
02What do you need to connect SharePoint Online to Make?
A Microsoft SharePoint Online user account (the doc also accepts an Office E3 account) and a Make account. Add a SharePoint module, click Create a connection, optionally name it, then Save and sign in to Microsoft to confirm access. Companies that require their own Azure app can enter client credentials and extra scopes under Show advanced settings, with the redirect URI given by the doc. Each module then needs its lower level delegated permissions, even when a higher ReadWrite permission is already granted.
03Do the SharePoint triggers in Make react in real time?
No. All 7 SharePoint triggers are scheduled: Make checks SharePoint on the scenario's schedule and processes what changed since the last check. A new scenario runs every 15 minutes by default, which is also the minimum on the Free plan; paid plans go down to 1 minute. None of them is instant, so SharePoint never calls Make through a webhook. For most document and list workflows that delay is fine, and you can lower it on a paid plan when a list needs a faster reaction.
04What if a SharePoint module is missing in Make?
It depends on the endpoint. Make an API Call reaches any endpoint of the Microsoft API with the same connection, so you can cover what the 36 listed modules do not. Add the matching scope in the advanced settings of your connection if the endpoint needs it. The doc warns that Microsoft Graph APIs in beta can change and are not supported in production, so favor stable endpoints for anything critical.
05Should you use Make or n8n for SharePoint Online?
It depends on the tool your team already runs. SharePoint Online also has an n8n node, so both can cover sites, lists and files. On Make you get 36 ready modules, a visual editor, a Free plan to test with and Make an API Call for the rest. This page does not rank the two: compare the modules you need on each side, then test your first scenario on the Free plan before deciding.
Same platform

Other docs you might need on this stack.

Browse all integrations