Detect and move duplicate Google Drive files with Supabase and Slack — Workflow n8n

Élevé complexité⚡ Déclencheur21 nœuds🏷️ File Managementpar Shashwat Singh

Aperçu

This workflow automatically detects duplicate files uploaded to a specific Google Drive folder by generating an MD5 hash of each file and comparing it against a Supabase database. If a duplicate is found, the file is moved to a dedicated Duplicates folder and a Slack notification is sent. All events, including unique uploads, duplicates, race conditions, and errors, are logged for audit purposes.

It is designed for teams that handle high file volumes and need reliable, content based deduplicati

Nœuds utilisés

SlackGoogle DriveCryptoSupabaseCode

Aperçu du workflow

This workflow detects and handles duplicate f
Watches a specific Google Drive folder for ne
Generates an MD5 hash from the file binary an
If the hash exists for a different file, the
If the hash does not exist, the workflow inse
Logs duplicates, unique inserts, race conditi
⚡
G
Google Drive Trigger
Prepare File Info
Download File
V
Validate Binary
Crypto
Check Hash Exists
Move to Duplicates
Notify Duplicate
Prepare Dup Log Data
Log Duplicate Event
Prepare Hash Data
Insert New Hash
Handle DB Error
Prepare Unique Log Data
Log Unique Event
Handle Missing Binary
Prepare Error Log Data
Log Error Event
N
No Operation, do nothing
S
Same File Re-triggered?
H
Hash Matched Different F…
21 nodes20 edges

Comment ça fonctionne

  1. 1

    Déclencheur

    Le workflow démarre avec un déclencheur déclencheur.

  2. 2

    Traitement

    Les données transitent par 21 nœuds, connecting code, crypto, googledrive.

  3. 3

    Sortie

    Le workflow termine son automatisation et livre le résultat à la destination configurée.

Détails des nœuds (21)

SL

Slack

slack

#1
GO

Google Drive

googleDrive

#2
CR

Crypto

crypto

#3
SU

Supabase

supabase

#4
CO

Code

code

#5

Comment importer ce workflow

  1. 1Cliquez sur le bouton Télécharger JSON à droite pour enregistrer le fichier du workflow.
  2. 2Ouvrez votre instance n8n. Accédez à Workflows → Nouveau → Importer depuis un fichier.
  3. 3Sélectionnez le fichier detect-and-move-duplicate-google-drive-files-with-supabase-and-slack téléchargé et cliquez sur Importer.
  4. 4Configurez les identifiants pour chaque nœud de service (clés API, OAuth, etc.).
  5. 5Cliquez sur Tester le workflow pour vérifier que tout fonctionne, puis activez-le.

Ou collez directement dans n8n → Importer depuis JSON :

{ "name": "Detect and move duplicate Google Drive files with Supabase and Slack", "nodes": [...], ...}

Intégrations

codecryptogoogledrivegoogledrivetriggerifslacksupabase

Obtenir ce workflow

Téléchargez et importez en un clic

Télécharger JSONVoir sur n8n.io
Nœuds21
Complexitéhigh
Déclencheurtrigger
CatégorieFile Management

Créé par

Shashwat Singh

Shashwat Singh

@shashwatsingh

Tags

codecryptogoogledrivegoogledrivetriggerifslacksupabase
⚡

Nouveau sur n8n ?

n8n est un outil d'automatisation de workflows gratuit et open-source. Hébergez-le vous-même ou utilisez la version cloud.

Obtenir n8n gratuitement →

Related File Management Workflows

COCOGOHT+5
medium

Sync SharePoint to Google Drive via Supabase (n8n Workflow)

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.

⏰ Scheduled·15 nodes
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