Audit external sharing in SharePoint to ensure compliance
Audit external sharing in SharePoint to ensure compliance This workflow audits your SharePoint Online environment for external sharing risks by identifying files and folders that are shared with anonymous links or external/guest users. It is designed to traverse SharePoint recursively, giving you full visibility into sharing across all sites, document libraries, folders and files. What it does Scans all SharePoint sites in the tenant. Traverses SharePoint recursively** through every folder and file, starting at the root of each drive. Fetches permissions for every item (files and folders). Detects and flags: Anonymous sharing links (anyone links) External or guest users, identified by: SharePoint guest login markers (#ext#, urn:spo:guest) Email domains not matching your internal tenant domains Outputs only items that are externally shared, including detailed metadata and permission evidence. How it works In the Set Variables node you define your internal tenantDomains, used to distinguish internal users from external ones. Microsoft Graph** is used to: Fetch all SharePoint sites Retrieve drives (document libraries) per site Each drive triggers a recursive subworkflow that: Starts at the root level Determines whether an item is a folder or a file If a folder, drills down into its children Keeps both folders and files, since both can have unique permissions For every discovered item: Permissions are retrieved via Microsoft Graph Item metadata and permissions are merged A custom filtering step analyzes permissions and: Flags anonymous links and external principals Drops items with no external exposure The final output is a clean, normalized list of externally shared SharePoint items, enriched with: Item name, type, URL and last modified date Site, drive, and parent identifiers Detailed lists of anonymous links and external users found Setup Create a Microsoft Entra ID (Azure AD) App Registration. Grant Microsoft Graph – Application permissions: Sites.Read.All Configure an OAuth2 Client Credentials credential in n8n and assign it to all HTTP Request nodes. Update the Set Variables node: Add all internal tenant domains (e.g. yourDomain.onmicrosoft.com, yourDomain.com) Run the workflow manually or attach a Schedule Trigger for recurring audits. Notes The workflow traverses SharePoint recursively, ensuring no nested folder or file is missed. Both folders and files are included because permissions can be broken at any level. External users are detected defensively using both login-name patterns and email domain checks. An n8n automation workflow template by Alexander Schnabl.
Alexander Schnabl
web
free
Others in the same category, ranked by how often they are opened.
