Sticky Note Automate

Sticky Note Automate creates a nightly backup of all workflows in Google Drive, organizing them into "n8n_backups" and "n8n_old" folders. It automatically purges backups older than 30 days, ensuring efficient storage management. This workflow runs on a schedule, streamlining backup processes and enhancing data security.

7/8/2025
33 nodes
Complex
schedulecomplexsticky notemovebinarydatafiltergoogle driveitemlistssplitinbatchesn8nschedule triggerautomationadvancedlogicconditionalcron
Categories:
Schedule TriggeredComplex Workflow
Integrations:
Sticky NoteMoveBinaryDataFilterGoogle DriveItemListsSplitInBatchesN8nSchedule Trigger

Target Audience

This workflow is designed for:
- Small Business Owners: Those who need to automate their backup processes without manual intervention.
- Freelancers: Individuals who manage multiple projects and require a reliable backup system for their workflows.
- IT Professionals: Users looking to maintain data integrity by automating backup tasks in Google Drive.
- Developers: Those who want to ensure their code and project files are regularly backed up and easily retrievable.

Problem Solved

This workflow automates the backup of all current workflows in n8n to Google Drive, addressing the following issues:
- Data Loss: Prevents loss of important workflows by creating regular backups.
- Manual Management: Eliminates the need for manual backup management, saving time and reducing errors.
- Old Backup Purging: Automatically purges backups older than 30 days, ensuring that storage space is utilized effectively and outdated files are removed.

Workflow Steps

  • Schedule Trigger: The workflow is triggered based on a defined schedule, allowing for automatic execution at set intervals.
    2. Get Current Folder: Retrieves the current folders in Google Drive to check for existing backup folders.
    3. Create Backup Folders: If the folders n8n_backups and n8n_old do not exist, they are created.
    4. Check for Existing Backups: Retrieves current backups to determine if any files already exist.
    5. Move Old Backups: Moves previous backups to the n8n_old folder, maintaining an organized structure.
    6. Upload Workflows: Batches and uploads the current workflows to the n8n_backups folder.
    7. Purge Old Backups: Checks for and deletes backups older than 30 days to free up space.

    • Customization Guide

    To customize this workflow:
    - Change Backup Frequency: Adjust the Schedule Trigger settings to modify how often the backups occur.
    - Modify Folder Names: Update the names of the backup folders in the Create n8n_backups and Create n8n_old nodes to suit your naming conventions.
    - Adjust Purge Duration: Change the 30 days threshold in the purge logic to retain backups for a longer or shorter period.
    - Add Additional Nodes: Integrate more nodes for additional functionalities, such as notifications upon successful backups or error handling procedures.