Automated Workflow Backups to Google Drive

• Daily automated backups of n8n workflows.
• Creation of timestamped folders in Google Drive for organization.
• Saving individual workflows as JSON files.
• Automatic cleanup of old backups, keeping only the last 7 days.
• Telegram notifications upon successful backup completion.

Setup Steps

API Configuration 🔑

1. Google Drive Integration:
   • Set up Google Drive OAuth2 credentials in n8n.
   • Ensure the n8n account credential has access to your Google Drive.
2. n8n API Access:
   • Configure n8n API credentials in n8n (n8n account credential) to allow fetching workflows.
3. Telegram Notifications:
   • Add your Telegram bot credentials (Telegram account credential).
   • Set the TELEGRAM_CHAT_ID environment variable for the Telegram chat where notifications should be sent.

Workflow Customization ⚙️

1. Trigger: The Every Day node is set to run daily. You can adjust the rule.interval for different scheduling needs. The On clicking 'execute' node is for manual testing.
2. Retention Policy: The Find Folders to Delete node uses a JavaScript code snippet to keep the last 7 days of backups. Modify sortedItems.slice(7) to change the retention period.
3. Telegram Message: The Complete Message node allows you to customize the notification text.

Testing & Deployment 🚀

1. Manual Execution: Trigger the workflow manually using the On clicking 'execute' node to test the backup process.
2. Verify Google Drive: Check your Google Drive for newly created timestamped folders and the JSON files within.
3. Test Cleanup: Schedule the workflow to run for several days and verify that older backup folders are automatically deleted.
4. Monitor Notifications: Ensure Telegram notifications are sent correctly upon completion.

Node Descriptions

• On clicking 'execute': Manual trigger for testing.
• Every Day: Scheduled trigger to run the backup daily.
• Get DateTIme: Sets a variable for the current date and time using ={{ $now }}.
• Create Folder with DateTime Stamp: Creates a new folder in Google Drive named n8n-Workflow-Backups-YYYY-MM-DD.
• Get Workflows: Retrieves all workflows from your n8n instance using the n8n API.
• Limit to 200: Limits the number of workflows fetched (useful for debugging or large instances).
• Loop Over Items: This node seems misplaced; it should typically be used to process items individually, but here it's connected in a way that might not be intended for its usual purpose. It's connected to Convert Workflow to JSON File and Execute Once which is unusual.
• Convert Workflow to JSON File: Converts workflow data into a JSON file.
• Save JSON File to Google Drive Folder: Uploads the generated JSON file to the newly created Google Drive folder.
• Execute Once: This node seems to be part of the folder deletion logic, it's not directly involved in the backup creation process but is triggered after the loop.
• Search Folder Names: Searches for existing backup folders in Google Drive.
• Find Folders to Delete: Uses JavaScript to identify backup folders older than 7 days.
• Delete Folders: Permanently deletes identified old backup folders.
• Complete Message: Sends a notification message via Telegram with backup details and a Google Drive link.