What is a common use case for this workflow? (Automated Multi-Cloud Disaster Recovery)

Maintain a real-time mirror of critical SharePoint corporate assets in Google Drive to ensure business continuity during service outages.

What is a common use case for this workflow? (Cross-Departmental Collaboration)

Automatically sync project documentation from an executive SharePoint site to a creative team's Google Drive folder for seamless cross-platform access.

What is a common use case for this workflow? (Centralized Document Auditing)

Use Supabase to track every file movement between ecosystems, creating a searchable metadata index for compliance and regulatory reporting.

Sync SharePoint to Google Drive via Supabase (n8n Workflow) — n8n Workflow

Medium complexity⏰ Scheduled15 nodes🏷️ File Management👁 24 viewsby DIGITAL BIZ TECH

Overview

Eliminate manual file transfers and data silos with this enterprise-grade synchronization pipeline. This n8n workflow automates the heavy lifting of mirroring your Microsoft SharePoint document libraries to Google Drive while maintaining a robust audit trail in Supabase or Postgres. Designed for high-reliability environments, the automation utilizes a sophisticated delta-check logic: it fetches SharePoint metadata, compares it against your existing database records using the 'Compare Datasets' node, and identifies only new or modified files for processing.

By leveraging the 'Split in Batches' node, the system handles large volumes of data without hitting memory limits, ensuring every document is securely downloaded via HTTP and re-uploaded to its destination. Once the transfer is verified, the workflow updates your database status in real-time, providing a transparent log of your synchronization history. This is an essential solution for organizations transitioning between cloud ecosystems or those requiring a redundant, cross-platform backup strategy. It effectively bridges the gap between Microsoft and Google ecosystems using Supabase as a high-performance state-management layer.

💡

Common Use Cases

Automated Multi-Cloud Disaster Recovery: Maintain a real-time mirror of critical SharePoint corporate assets in Google Drive to ensure business continuity during service outages.
Cross-Departmental Collaboration: Automatically sync project documentation from an executive SharePoint site to a creative team's Google Drive folder for seamless cross-platform access.
Centralized Document Auditing: Use Supabase to track every file movement between ecosystems, creating a searchable metadata index for compliance and regulatory reporting.

Nodes used

HTTP RequestPostgresGoogle DriveSupabaseCode

Workflow Preview

SharePoint Sync Overview

How it works

Runs on a schedule, fetches SharePoint folders and file

Only new or modifi

extract metadata

Rename Files

Renames each downloaded binary file

with its corresponding SharePoint file title before upl

Postgres (Mark Complete)

Marks entries as processed by setting `Loading Done = t

once uploads are complete.

Upload file (Google Drive)

Uploads downloaded files to Google Drive for safe stora

Microsoft SharePoint HTTP Request1 (Download)

Downloads each new or updated file directly from ShareP

Insert Document Metadata

Upserts processed SharePoint file data into `n8n_metada

Creates or updates existing records.

delete file from supabase (metadata table)

Filter Files

Filters out system and temporary files (`~$`, `.db`, `.

and flattens nested folders into a single clean file li

Compare Datasets

Compares SharePoint and Supabase data

to detect new or updated files and flag records for pro

Microsoft SharePoint HTTP Request

Retrieves all folders and files recursively from the sp

Supabase (Get)

Retrieves existing records from `n8n_metadata`

to check which SharePoint files are already stored.

Schedule Trigger

Triggers the workflow on a defined schedule

standardizes

`Last_modified_date`

loop over newly added or modified files

Loop Over Items2

Microsoft SharePoint HTT…

⚡

Schedule Trigger

Compare Datasets

Supabase

Supabase1

Insert Document Metadata

Postgres

Upload file

Microsoft SharePoint HTT…

filter files

normalize last modified …

get metadata

Set metadata

rename files

15 nodes17 edges

How it Works

1
Trigger
The workflow starts with a scheduled trigger, running on a defined schedule.
2
Process
Data flows through 15 nodes, connecting code, comparedatasets, googledrive.
3
Output
The workflow completes its automation and delivers the result to the configured destination.

Node Details (15)

HTTP Request

httpRequest

Postgres

postgres

Google Drive

googleDrive

Supabase

supabase

Code

code

How to Import This Workflow

1Click Download JSON button on the right to save the workflow file.
2Open your n8n instance. Go to Workflows → New → Import from file.
3Select the downloaded automated-document-sync-between-sharepoint-and-google-drive-with-supabase file and click Import.
4Set up credentials for each service node (API keys, OAuth, etc.).
5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Sync SharePoint to Google Drive via Supabase (n8n Workflow)", "nodes": [...], ...}

Integrations

codecomparedatasetsgoogledrivehttprequestpostgresscheduletriggersetsplitinbatchessupabase

Get This Workflow

Download and import in one click

Download JSON View on n8n.io

Nodes15

Complexitymedium

Triggerscheduled

CategoryFile Management

Created by

DIGITAL BIZ TECH

@dbt

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →

Related File Management Workflows

FOGOGOHT+2

medium

Automate Threads Video Backups to Google Drive & Sheets

Streamline your social media asset management with this robust n8n automation designed for digital marketers and content creators. This workflow eliminates the manual effort of downloading Threads content by providing a seamless bridge between Instagram's text-based platform and your cloud storage. Once triggered via a simple form input, the automation utilizes a RapidAPI connection to fetch high-quality video assets, processes the binary data, and securely uploads the file to a designated Google Drive folder. Simultaneously, the workflow maintains a centralized audit log in Google Sheets, capturing essential metadata such as timestamps and file IDs. Built-in logic gates and wait nodes ensure API rate limits are respected and file transfers are verified before logging. This is an essential tool for agencies managing high volumes of social content who need a reliable, automated pipeline for content repurposing, archival compliance, or collaborative review processes. By centralizing your Threads media assets, you ensure your creative team has instant access to raw footage without the friction of manual downloads. **Common Use Cases:** - Automated Social Media Content Archiving for Compliance - Centralized Asset Library Syncing for Creative Agencies - Competitor Research and Video Content Benchmarking

⚡ Trigger·9 nodes