Automated Workflow Backups to Google Drive

• Daily Scheduled Backups: Automatically backs up workflows at a set interval (e.g., daily).
• Timestamped Folders: Creates uniquely named folders in Google Drive for each backup session (e.g., n8n-Workflow-Backups-YYYY-MM-DD).
• JSON Workflow Export: Converts each n8n workflow into a JSON file.
• Google Drive Integration: Seamlessly uploads backup files to Google Drive.
• Automated Retention Policy: Deletes backup folders older than 7 days to manage storage space.
• Telegram Notifications: Sends alerts to a specified Telegram chat with backup status and a link to the created folder.
• Manual Trigger Option: Allows for on-demand workflow backups.

Setup Steps

1. Trigger Configuration:

• On clicking 'execute' (manualTrigger): For manual backups.
• Every Day (scheduleTrigger): Configure the rule.interval to set the daily backup schedule.

2. Backup Process:

• Get DateTIme (set): Captures the current date and time.
• Create Folder with DateTime Stamp (googleDrive): Creates a new folder in Google Drive using the captured timestamp.
• Get Workflows (n8n): Retrieves all workflows from your n8n instance.
• Limit to 200 (limit): (Optional, for testing) Limits the number of workflows processed.
• Loop Over Items (splitInBatches): Iterates through each workflow retrieved.
• Convert Workflow to JSON File (convertToFile): Converts each workflow into a JSON file.
• Save JSON File to Google Drive Folder (googleDrive): Uploads the JSON file to the newly created Google Drive folder.

3. Backup Management (Deletion of Old Backups):

• Execute Once (noOp): This node acts as a point for the deletion logic to run independently or alongside the backup process.
• Search Folder Names (googleDrive): Searches for existing backup folders in Google Drive matching the naming convention n8n-Workflow-Backups.
• Find Folders to Delete (code): A JavaScript function that sorts the found folders by name (descending) and selects all but the most recent 7 to be deleted.
• Delete Folders (googleDrive): Permanently deletes the identified older backup folders.

4. Notifications:

• Complete Message (telegram): Sends a success message to Telegram, including the name and link of the newly created backup folder.

Important Notes:

• Ensure your Google Drive, n8n API, and Telegram credentials are correctly configured in n8n.
• The n8n-Workflow-Backups prefix is crucial for the deletion logic to identify correct folders.
• Adjust the retention logic in the Find Folders to Delete node if you need to keep more or fewer than 7 days of backups.