Generate Structured User Metadata with GPT-4
detail.loadingPreview
Creates CSV files containing structured mock user data generated by GPT-4.
About This Workflow
This n8n workflow automates the generation of structured mock user data using OpenAI's GPT-4 model. The generated data includes user names, emails, subscription status, and subscription dates. The workflow then processes this data to create multiple CSV files, ensuring proper formatting and saving them to the disk.
Key Features
- GPT-4 Integration: Leverages GPT-4 to generate diverse and creative mock user data.
- JSON to CSV Conversion: Transforms raw JSON output from GPT-4 into well-formatted CSV files.
- Batch Processing: Splits the generated data into manageable batches for processing.
- BOM Stripping: Includes nodes to handle potential Byte Order Mark (BOM) issues in CSV files, ensuring compatibility with various readers.
- File Naming Convention: Generates dynamic file names for the CSV outputs, incorporating batch index.
- Local File Saving: Saves the generated CSV files to the local disk within the n8n environment.
How To Use
- Trigger the Workflow: Click the "Execute Workflow" button.
- GPT-4 Interaction: The
OpenAInode will query GPT-4 with a specific prompt to generate a JSON array of user data. - Batching: The
Split In Batchesnode divides the JSON array into individual items (ifbatchSizeis 1, each item becomes a separate batch). - JSON Parsing: The
Parse JSONnode ensures the JSON content is correctly parsed. - Table Creation: The
Make JSON Tablenode prepares the data for CSV conversion. - CSV Conversion: The
Convert to CSVnode transforms the structured data into CSV format, dynamically naming the file. - BOM Handling: The
Strip UTF BOM bytesandCreate valid binarynodes clean up the CSV file to prevent reading issues. - File Saving: The
Save to Disknode stores the generated CSV file locally in the.n8ndirectory.
Apps Used
Workflow JSON
{
"id": "cd021e6a-785a-4be5-bfc9-dd4698eb0909",
"name": "Generate Structured User Metadata with GPT-4",
"nodes": 7,
"category": "Data Generation",
"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: cd021e6a-785a...
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
Generate Structured Metadata in Multiple Languages
Workflow to create structured metadata in both English and Chinese.
Smart Factory Data Generator & Sender
Generates random smart factory sensor data and sends it via AMQP.