Automated n8n Workflow Backup to Google Drive and Sheets
detail.loadingPreview
Never worry about losing your n8n workflows again. This automation ensures all your critical workflows are automatically backed up daily to Google Drive, with a comprehensive log maintained in Google Sheets for easy tracking and disaster recovery.
About This Workflow
This powerful n8n workflow provides an indispensable layer of security for your n8n automation ecosystem. It automatically runs every night, querying your n8n instance to fetch definitions for all active workflows. Each workflow's JSON data is then meticulously stored in its own dedicated subfolder within a designated Google Drive directory, timestamped for version control. Simultaneously, a Google Sheet is updated to serve as a central inventory, listing each workflow's ID, name, and the timestamp of its last successful backup, offering a transparent audit trail and quick access to recovery information.
Key Features
- Automated Daily Backups: Configured to run automatically every night at a specific time (1:30 AM).
- Comprehensive Workflow Backup: Retrieves and backs up all active workflows from your n8n instance.
- Organized Google Drive Storage: Each workflow gets its own subfolder, containing timestamped JSON files for easy versioning and retrieval.
- Centralized Backup Log: A Google Sheet acts as an index, tracking workflow IDs, names, and last backup times.
- Disaster Recovery Ready: Provides a clear path to restore workflows in case of accidental deletion, corruption, or server issues.
How To Use
- Configure n8n API Credentials: Ensure you have an n8n API credential set up in n8n (used by "Get all n8n Workflow").
- Set Up Google Sheets Credentials: Create a Google Sheets OAuth2 credential in n8n and link it to the "Append row in sheet" node. Ensure it has access to the target Google Sheet.
- Set Up Google Drive Credentials: Create a Google Drive OAuth2 credential in n8n and link it to the "Store File in Subfolder", "Search Subfolder", and "Create SubFolder" nodes. Ensure it has full access to create folders and files in your Google Drive.
- Specify Google Sheet: In the "Append row in sheet" node, update the
documentIdandsheetNameparameters to point to your desired Google Sheet for the backup log. - Define Google Drive Backup Folder: In the "Search Subfolder" and "Create SubFolder" nodes, update the
folderIdparameter to the ID of your main "n8n workflows" parent folder in Google Drive. This is where subfolders for individual workflows will be created. - Activate Workflow: Once configured, activate the workflow to enable daily automated backups.
Apps Used
Workflow JSON
{
"id": "8285ccc7-0fb9-49dc-bda6-d1656cc86e52",
"name": "Automated n8n Workflow Backup to Google Drive and Sheets",
"nodes": 11,
"category": "DevOps",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 8285ccc7-0fb9...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
Automated PR Merged QA Notifications
Streamline your QA process with this automated workflow that notifies your team upon successful Pull Request merges. Leverage AI and vector stores to enrich notifications and ensure seamless integration into your development pipeline.
Robust Concurrency Control for n8n Workflows with Redis
Prevent simultaneous execution of critical n8n workflows or tasks using a centralized, Redis-backed locking mechanism. This reusable utility workflow ensures data integrity and resource management by allowing other workflows to acquire, check, and release locks.
Automate Qualys Report Generation and Retrieval
Streamline your Qualys security reporting by automating the generation and retrieval of reports. This workflow ensures timely access to crucial security data without manual intervention.