Automate n8n Backups: GitHub & SFTP Workflow Solution

Revolutionize Your Backup Strategy: Automate n8n Backups with GitHub & SFTP!

Take control of your data protection routine with the "Automate n8n Backups: GitHub & SFTP Workflow Solution". Designed for the tech-savvy n8n community, this powerhouse workflow seamlessly backs up your self-hosted n8n Docker container's workflows and credentials directly to GitHub — all on an automated schedule. Effortlessly restore data using a user-friendly web form, SFTP, and the n8n CLI. Say goodbye to tedious manual backups and hello to streamlined data management.

What this workflow does

• Operates on a predefined cron schedule (default times: 10:00 and 22:00) to automate the backup process.
• Generates a uniquely timestamped folder in your GitHub repository for orderly storage of backup files.
• Exports and parses all n8n workflows and credentials using secure SSH connections, resulting in precise JSON outputs.
• Categorizes export data into individual items and comprehensive files (workflows-all.json, credentials-all.json, and workflows-credentials.json).
• Uploads individual and full backup JSON files to the timestamped GitHub folder for seamless version control.
• Includes a straightforward restore option via a web form, analyzing uploaded JSON contents to identify relevant data sets.
• Ensures unblemished recovery by uploading parsed JSON files back to the Docker host using SFTP and executing n8n import commands through SSH.

Use cases

• Automated Data Security — Keep your n8n workflows and credentials secure with this set-and-forget backup solution.
• Efficient Data Recovery — Quickly restore critical components in the event of system failures or data corruption.
• Seamless Version Control — Utilize GitHub's versioning to track changes and roll back when necessary.
• Development and Testing — Manage multiple development environments with consistent data by syncing backup and restore operations.

Technical details

• Tech stack/nodes employed: FTP, Set, SSH, Code, Merge, GitHub
• Integrates with GitHub for version control and backup storage
• Utilizes SFTP for secure file transfers
• Employs n8n CLI for export and import operations

Unlock efficient, reliable, and automated data management for your n8n workflows today with this GitHub & SFTP Workflow Solution, the perfect blend of automation and precision!