Automated Workflow Backup System with Google Drive, Gmail, and Discord Alerts

## How it works This workflow automates the backup of all your n8n workflows to a specified Google Drive folder. It operates in two main phases: 1. **Orchestration (Scheduled Task):** - The workflow is initiated by a **Schedule Trigger** (e.g., daily at 1:30 AM by default). - It then uses an **n8n API Node** to fetch a list of all existing workflows in your n8n instance. - A **Loop Over Items** node processes each fetched workflow individually. - For every workflow in the list, an **Execute Workflow** node calls the worker part of this same workflow, passing the individual workflow's data. 2. **Individual Workflow Backup (Worker Task):** - This part is triggered by the **When Executed by Another Workflow** node (called by the orchestrator part). - It first retrieves the passed workflow data. - A **Parameters** node defines the target Google Drive directory. - The **Get Google Drive File Data** node searches the specified Google Drive folder to see if a backup file for the current workflow (named as `WorkflowName_WorkflowID.json`) already exists. - An **IF Node** (`ifDriveEmpty`) checks the result: - If a backup file **exists**, the workflow data is converted to a binary JSON file using a **Code Node**, and then the existing file on Google Drive is **updated** (`Backup to Google Drive2`). - If a backup file **does not exist**, the workflow data is first formatted as JSON, converted to a binary JSON file using another **Code Node**, and then **uploaded as a new file** to Google Drive (`Backup to Google Drive4`). - If any Google Drive upload/update operation fails, a **Failure Email** is sent. After the loop in the orchestration phase completes (all workflows processed), a **Limit** node ensures only one signal proceeds to send a **Success Email** and a **Discord** message indicating the overall backup process was completed. ## Setup 1. **Clone Workflow:** Clone this workflow into your n8n environment. 2. **Credentials:** - **n8n API:** In the Get all n8n Workflows node, select or create n8n API credentials. This allows the workflow to list all your other workflows. - **Google Drive:** In the getDriveFileData, Backup to Google Drive2, and Backup to Google Drive4 nodes, select or create your Google Drive OAuth2 API credentials. - **Gmail:** In the successEmail and failureEmail nodes, select or create your Gmail credentials. - **Discord (Optional):** If you wish to use Discord notifications, configure your Discord Bot API credentials in the Discord node. 3. **Configuration:** - **Schedule:** Open the Schedule Trigger node and adjust the trigger interval (e.g., time of day) as needed. - **Google Drive Folder:** Open the Parameters node (connected after Workflow Data). Edit the `directory` value to the full URL of the Google Drive folder where you want to store your backups (e.g., `https://drive.google.com/drive/folders/YOUR_FOLDER_ID`). - **Email Recipients:** Open the successEmail and failureEmail nodes and update the Send To field with your desired recipient email address(es). - **Discord Channel (Optional):** If using Discord, open the Discord node and set the Channel ID for notifications. - **Sub-Workflow ID:** The Execute Workflow node is pre-configured to call this workflow itself using its ID. If you import this workflow and its ID changes, you *may* need to update the `workflowId` in the Execute Workflow node to the new ID of this imported workflow. *However, n8n usually handles this if it's self-referential within the same imported workflow.* ## How to use 1. **Activate:** After completing the setup steps, activate the workflow. It will automatically run according to the defined schedule. 2. **Manual Execution:** You can also manually trigger the workflow by clicking the Execute Workflow play button on the Schedule Trigger node to perform an immediate backup of all workflows. 3. **Check Backups:** Your n8n workflows will be saved as `.json` files (named `WorkflowName_WorkflowID.json`) in the Google Drive folder you specified in the Parameters node. 4. **Notifications:** You will receive an email (and optionally a Discord message) upon successful completion of the entire backup process, or individual failure emails if a specific workflow backup to Google Drive fails. ## Author & Credits - **Creator:** Hochien Chang - **YouTube Channel (Chinese):** [HC AI](https://www.youtube.com/channel/UCvGfUB-wBdG4i_dDGBCwJg) - **YouTube Channel (English):** [HC HumanizeAI](https://www.youtube.com/@HC-HumanizeAI) - **Original Explanation Video:** [https://youtu.be/PA15H5qunC0](https://youtu.be/PA15H5qunC0) - **Based on:** [n8n Workflow Backup to Google Drive](https://n8n.io/workflows/3112-backup-n8n-workflows-to-google-drive/)

Platform

n8n

Category

Business Operations & ERPs

Price

Free

Creator

HoChien Chang

• if
• n8n
• set
• code
• gmail
• limit
• discord
• stickyNote
• googleDrive
• executionData