How to Generate Packing Lists from Airtable Automatically

Manual packing list creation is slow and error-prone. Copying item names and quantities from Airtable into separate documents wastes time and introduces mistakes that delay shipments.

This guide shows you how to automatically generate professional packing list PDFs from your Airtable order data. No coding required.

Why Automate Packing List Generation in Airtable

Warehouse teams need packing lists that are accurate, readable, and generated instantly. Manual creation causes problems:

• Tedious data copying - Transcribing order details into Word or Excel wastes time
• Inconsistent formatting - Each packing list looks different depending on who creates it
• Human error - Wrong quantities, missing items, or incorrect addresses delay shipments
• No audit trail - Hard to track which orders have packing lists generated

Automated generation solves these issues. When an order is ready to pack, the system pulls data directly from Airtable and creates a professional PDF in seconds.

What You Need Before Starting

Before you begin, ensure you have:

1. An Airtable base with order data - Orders and Products tables with linked records connecting them
2. A Google account - For creating your packing list template in Google Docs
3. A TypeFlow account - The service that connects Airtable to your template and generates PDFs

Step 1: Set Up Your Airtable Base for Packing Lists

Your Airtable base needs two core tables connected by linked records.

Create an Orders Table

Create a Products Table

Link Products to Orders

Create a linked record field in your Orders table pointing to the Products table. This allows each order to contain multiple products that will appear as line items on your packing list.

Step 2: Create Your Packing List Template in Google Docs

Design your packing list template with placeholders that TypeFlow will replace with actual data.

Add Company Branding

Start with your company logo at the top, followed by company name and contact information. Keep the design clean and readable for warehouse staff.

Insert Placeholders for Order Details

Use double curly braces for placeholders:

PACKING LIST

Order #: {{Order ID}}
Date: {{Order Date}}

SHIP TO:
{{Customer Name}}
{{Shipping Address}}

---

Format the Line Items Section

Create a table for products. Use the loop syntax to repeat rows for each linked product:

ITEMS TO PACK:

| SKU | Product | Qty | Location |
|-----|---------|-----|----------|
{{loop_0}}
| {{SKU}} | {{Product Name}} | {{Quantity}} | {{Location}} |

Add Footer Elements

Include space for picker signature and completion checkboxes:

---

Total Items: {{Total Items}}

Packed by: ________________  Date: ________________

[ ] All items verified
[ ] Package sealed
[ ] Label attached

Step 3: Connect Your Template to Airtable

Install TypeFlow from the Airtable Marketplace and connect it to your base.

Select Your Template

Choose the Google Docs packing list template you created. TypeFlow will detect all the placeholders automatically.

Configure the Output Location

Select the attachment field where generated packing lists should be saved (e.g., "Packing List PDF" field in your Orders table).

Step 4: Map Your Airtable Fields to the Template

Connect each placeholder in your template to the corresponding Airtable field.

Map Single Fields

Direct one-to-one mapping for order details:

• {{Order ID}} → Order ID field
• {{Customer Name}} → Customer Name field
• {{Shipping Address}} → Shipping Address field
• {{Order Date}} → Order Date field

Map Linked Records for Line Items

For the products loop, map the linked record field to pull data from each connected product.

Apply Data Formatting

Use TypeFlow's formatting options to ensure dates and numbers display correctly.

Generate Packing Lists: 3 Options

Once configured, you have multiple ways to generate packing lists depending on your workflow.

Option 1: Button Field (On-Demand Generation)

Add a button field to your Orders table for one-click generation.

Workflow:

1. Open an order record
2. Click "Generate Packing List"
3. PDF appears in the attachment field within seconds
4. Print and hand to warehouse team

Best for: Small operations where orders are processed individually.

Option 2: Bulk Generation (Batch Processing)

Generate packing lists for multiple orders at once.

Workflow:

1. Filter your view to show orders with Status = "Ready to Pack"
2. Select all records
3. Click "Generate PDFs"
4. All packing lists generate in parallel

Best for: Daily batch processing where you generate all packing lists at once (e.g., morning pick lists).

Option 3: Airtable Automations (Automatic Generation)

Set up automations to generate packing lists when orders reach a specific status.

Setup steps:

1. Create a new Automation in Airtable
2. Set trigger: "When record matches conditions" (Status = "Ready to Pack")
3. Add action: "Run script"
4. Paste the TypeFlow script

Best Practices for Packing List Workflows

Include All Essential Fields

Every packing list should contain:

• Order number for easy reference and tracking
• Full shipping address to prevent delivery errors
• Product SKUs for accurate warehouse picking
• Quantities for each item
• Special handling instructions if applicable

Use Consistent Naming Conventions

Airtable field names must match template placeholders exactly. Avoid spaces or special characters in field names when possible. Use underscores instead (e.g., Order_ID rather than Order ID).

Set Up Print-Ready Formatting

Configure your Google Docs template with:

• Standard letter or A4 page size
• Adequate margins for printing
• Large, readable fonts (12pt minimum for item details)
• High-contrast colors (black text on white background)

Common Issues and Solutions

Linked Records Not Showing

Problem: Products don't appear on the generated packing list.

Solution:

1. Verify the linked record field is included in your TypeFlow mapping
2. Check that products are actually linked to the order in Airtable
3. Ensure the loop syntax is correct in your template

Quantities Displaying Incorrectly

Problem: Wrong quantities or missing quantity data.

Solution:

1. If using a junction table, map quantity from the line items table, not the products table
2. Check that the Quantity field contains numbers, not text
3. Apply number formatting in TypeFlow if needed

Automation Not Triggering

Problem: Packing lists aren't generating automatically.

Solution:

1. Verify the record meets all trigger conditions
2. Check that the automation is turned on
3. Review the automation run history for error messages
4. Ensure TypeFlow has permission to access your base

Start Generating Packing Lists from Airtable Today

With TypeFlow, automating packing list generation from Airtable takes minutes to set up and runs reliably without code. Stop copying data manually and start generating professional documents instantly.