n8n Tutorial

Automate Inventory Label Generation with n8n

AI generates tracking URLs and batches items into printable QR code sheets. From Airtable, Notion, or Sheets.

Vincent Ventalon
Vincent Ventalon
·Updated
TemplateFox

About the TemplateFox Node

The official TemplateFox community node for n8n lets you generate PDFs from templates with dynamic data. Works synchronously — returns the PDF URL immediately. Compatible with n8n AI Agents.

Why automate labels?

New assets arrive. Someone adds rows to a spreadsheet. Now you need labels with QR codes. Print them, stick them on assets. Tomorrow more assets arrive. Repeat.

With n8n, your inventory database triggers automatic label generation. New rows become printable QR sheets. Done.

The workflow: inventory trigger → build URLs → generate PDF → send to print.

1

Create your label template

Use a barcode or QR code sheet template. The key is the items array — it auto-repeats labels in a grid.

// Sample items structure
{
"items": [
{ "qrcode": "https://inv.co/asset/001" },
{ "qrcode": "https://inv.co/asset/002" }
]
}

Template: QR Code Sheet

QR Code Sheet template in the visual editor

Click a QR code to see its properties. The Content field uses the template variable.

QR code selected showing properties panel
2

Build the workflow

2.1 — Inventory trigger

Add a trigger for your inventory source:

Airtable Trigger

Watch for new/updated records in your inventory base. Best for structured data.

Google Sheets Trigger

Watch for Row Added or Row Updated.

Notion Trigger

Watch a Notion database for new pages (inventory items).

Schedule Trigger

Run daily/weekly to process all "pending" items in bulk.

Tip: For high-volume inventory, use Schedule trigger + "status" column to batch process unprocessed items.

2.2 — Build tracking URLs

Use a Code node to transform each row into a QR code URL:

// Code node - Run Once for Each Item
return {
qrcode: `https://inv.co/asset/${$json.id}`
};

2.3 — Batch items

Use an Aggregate node to group items into batches:

  • Aggregate items into items array
  • Use Split In Batches for multiple sheets

2.4 — Generate label sheet

Add the TemplateFox node:

  • Select the QR code sheet template
  • Map items array from aggregated output
  • Output to Google Drive, email, or print queue
QR Code Sheet preview with generated labels

Result: Inventory items automatically become printable QR code sheets.

Supported platforms

G
Google Sheets
A
Airtable
N
Notion
E
Excel Online
C
CSV Upload
W
Webhook

Frequently asked questions

What spreadsheet platforms work?

Any platform with n8n support: Google Sheets, Airtable, Notion, Excel Online. Also CSV files via webhook upload.

How do I build tracking URLs?

Use a Code node to transform each row. Example: return { qrcode: `https://yoursite.com/asset/${$json.id}` }

How many labels fit on one sheet?

Depends on your template. The QR code sheet template fits multiple labels per page. The workflow automatically batches items for multi-page output.

Can I trigger on schedule instead of new rows?

Yes. Use n8n's Schedule trigger to run daily/weekly. The workflow fetches all rows (or rows marked 'pending'), generates labels, then marks them 'processed.'

What does this automation cost?

n8n self-hosted is free. TemplateFox offers 60 free PDFs per month. View pricing.

Automate your PDF generation

Complete documentation, no-code integrations, and a powerful API to help you generate PDFs at scale. Let us handle the boring stuff.