Automated Workflow Metadata Generation to Google Drive

Name: Automated Workflow Metadata Generation to Google Drive
Rating: 5 (5 reviews)
Author: Free N8N

Intermediate

21 nodes connected

detail.loadingPreview

Free N8N Temples

139 views

0 downloads

Data Managementautomationbackupgoogle drivemetadatan8nworkflows

This workflow automatically retrieves a list of n8n workflows, fetches details for each, merges them, and uploads the structured metadata as JSON files to Google Drive daily.

About This Workflow

This workflow automates the process of extracting metadata from your n8n instance and storing it in Google Drive. It's designed to run daily, ensuring you have an up-to-date backup or record of your workflow configurations. The process involves fetching a list of all workflows, then iteratively retrieving details for each workflow, merging this data, converting it into a binary JSON format, and finally uploading it to a specified Google Drive folder.

Key Features

Scheduled Execution: Runs automatically daily at 2:30 AM.
n8n API Integration: Uses HTTP requests to interact with the n8n REST API to fetch workflow data.
Data Merging: Combines workflow list data with individual workflow details.
JSON to Binary Conversion: Prepares the structured data for efficient storage.
Google Drive Integration: Uploads the generated JSON files to a designated Google Drive folder.
Configurable Output: The filename and target folder in Google Drive can be customized.

How To Use

Trigger: The workflow can be manually triggered by clicking 'execute' or automatically started by the 'Run Daily at 2:30am' cron trigger.
Get Workflow List: The Get Workflow List node fetches all workflows from your n8n instance via the /rest/workflows endpoint. Ensure your n8n Creds are correctly set up for basic authentication.
Map: The Map node processes the list of workflows, preparing them for the next stage.
Get Workflow: The Get Workflow node is called for each workflow ID obtained from the Map node, fetching the detailed configuration of that specific workflow. This node also requires the n8n Creds.
Merge: The Merge node combines the data from the workflow list and the individual workflow details. It uses mergeByIndex to align the data correctly.
FunctionItem: The FunctionItem node restructures the merged data, making it ready for conversion.
Move Binary Data: This node converts the structured JSON data into a binary format suitable for upload.
Google Drive: The Google Drive node uploads the binary JSON file to your Google Drive.
- Filename: The filename is dynamically set using the workflow's name property (e.g., {{$node["Merge"].data["name"]}}.json).
- Folder ID: You must replace the placeholder text in the parents field with the actual ID of your desired Google Drive folder. This ID can be found in the URL when you navigate to the folder in Google Drive.
- Credentials: Ensure your test Google Cloud credentials are correctly configured.

Apps Used

automation

backup

google drive

metadata

n8n

workflows

Workflow JSON

{
  "id": "36f73250-f39b-4920-ad86-6074517f5523",
  "name": "Automated Workflow Metadata Generation to Google Drive",
  "nodes": 21,
  "category": "Data Management",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.