Join Product Data from MySQL Databases for Label Printing

This workflow receives a product grade ID via webhook, queries and joins detailed product, grade, tissue, and composition data from multiple MySQL databases, unifying it for label generation.

The workflow starts with a webhook trigger named 'emitirEtiqueta' that accepts POST requests containing an 'id_produto_grade'. It then executes a complex MySQL query in the 'dadosProduto' node using CTEs to fetch data: 'pg' for product grade details, 'p' for active product info, 't' for tissue width extracted from JSON in a dynamic reporting database, and 'cp' for aggregated composition using JSON_TABLE to parse array data. This unifies disparate data sources—product tables and dynamic 'i_objet
Platform
n8n
Category
Lifestyle
Price
$14.99
Creator
Jordi Faber

How to import this workflow into n8n

  1. 1Purchase or download the workflow to get the n8n workflow JSON file.
  2. 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
  3. 3Open each node marked with a credential warning and connect your own accounts and API keys.
  4. 4Run the workflow once manually to verify the data flow, then toggle it to Active.

Related Lifestyle workflows

More from Jordi Faber

All Lifestyle workflows →All n8n workflows →

Need this deployed? We'll set it up for you.

Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.

Get It DeployedCustom Build