Generate Structured Metadata for n8n Integrations (English & Chinese)

Name: Generate Structured Metadata for n8n Integrations (English & Chinese)
Rating: 5 (5 reviews)
Author: Free N8N

Advanced

22 nodes connected

detail.loadingPreview

Free N8N Temples

76 views

0 downloads

Automationdocumentationgoogle drivegoogle sheetslocalizationmetadatan8nopenai

This workflow generates structured metadata for n8n integrations, including descriptions, use cases, and how-to guides in both English and Chinese, leveraging AI for content enhancement.

About This Workflow

This workflow aims to automate the creation of comprehensive metadata for n8n integrations. It pulls data from Google Sheets, categorizes integrations, and then uses an OpenAI Chat Model (gpt-4o-mini) to generate or augment descriptions, questions, and answers. The final output is structured for display or documentation purposes and can be saved to Google Drive. The workflow supports generating metadata in both English and Chinese.

Key Features

Multi-language Metadata Generation: Creates content in both English and Chinese.
AI-powered Content Enhancement: Utilizes OpenAI's GPT-4o-mini for generating and refining text.
Dynamic Content Generation: Populates metadata based on integration type (Native, Cred-only, Non-native, Categories).
Structured Output: Generates JSON output with predefined fields for titles, summaries, overviews, features, use cases, and how-to guides.
Google Sheets Integration: Reads integration details from a Google Sheet.
Google Drive Storage: Saves generated metadata files to specified Google Drive folders.
Workflow Automation: Automates the entire process from data retrieval to content generation and storage.

How To Use

Configure Google Sheets Data Source: Ensure your Google Sheet is set up with columns like displayName, Category name, row_number, and status for integration data.
Set Google Drive Destination Folders: In the Prepare Job node, update the outdir assignments with the correct Google Drive folder IDs for each integration category (Single Integration Native, Single Integration Cred-only, Single Integration Non-native, Categories).
Trigger the Workflow: Click the 'Test workflow' button in n8n to initiate the process.
Monitor Execution: The workflow will read from your Google Sheet, process each integration type, generate metadata using OpenAI, and save the structured JSON files to your Google Drive.
Review Generated Metadata: The output files in Google Drive will contain the generated metadata in English and Chinese, ready for use.

Apps Used

documentation

google drive

google sheets

localization

metadata

n8n

openai

Workflow JSON

{
  "id": "278bf71d-e79b-429a-be8b-81b24904c99f",
  "name": "Generate Structured Metadata for n8n Integrations (English & Chinese)",
  "nodes": 22,
  "category": "Automation",
  "status": "active",
  "version": "1.0.0"
}

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