# Generate fabric label data via webhook from MySQL and PostgreSQL
This automation streamlines the preparation of label data for fabric rolls. Triggered by an HTTP webhook, it pulls product information from MySQL and roll data from PostgreSQL, merges both datasets, and prepares unified output for label printing. Designed for warehouses, logistics teams, and textile manufacturers who require accurate, real-time labeling integrated with inventory or ERP systems.
## Who it´s for
- Warehouse operators handling fabric rolls and automated label printing
- Logistics companies automating real-time material tracking
- Textile manufacturers needing precise product labeling based on ERP data
## What the automation does
- Receives product and roll identifiers via HTTP webhook
- Fetches print configuration from a custom REST API endpoint
- Retrieves product details from a MySQL database
- Pulls roll-specific data (width, composition, batch) from PostgreSQL
- Merges all data into a structured format suitable for label generation
- Supports integration scenarios with ERP systems and document-based triggers
## What´s included
- Ready-to-use n8n workflow template
- Webhook trigger and data processing logic
- Pre-built integrations with MySQL, PostgreSQL, and HTTP API
- Basic setup and adaptation guide in text format
## Requirements for setup
- Active n8n instance with workflow editing access
- Credentials for MySQL and PostgreSQL (host, port, login, password, table names)
- Endpoint URL for the external print configuration API
- Sample webhook payload (e.g., product ID and roll ID) for testing
## Benefits and outcomes
- Eliminates manual data entry during label creation
- Reduces errors by sourcing live data directly from databases
- Speeds up labeling during intake and internal transfers
- Unifies data from distributed systems into one coherent structure
- Enables seamless ERP integration (e.g., ´Receipt´ document → label)
- Supports real-time, event-driven operations
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet