Logistics

Freight Document Generation & Validation

Validates new shipment entries with AI, generates the freight document as a PDF, stores it in Drive and emails it to both shipper and receiver. Mismatches are flagged before anything goes out.

The Freight Document Generation & Validation workflow on the n8n canvas, with its 18 nodes and connections
The workflow on the n8n canvas. Click to open it full size.

At a glance

Category
Logistics
Nodes
18
Apps
Google Drive, OpenAI, Google Sheets
Price
Free
Download JSON
On this page

How it works

  1. A new shipment row in Google Sheets starts the workflow.
  2. AI checks the shipment details against carrier information.
  3. If something doesn't match, the issue is emailed and the row is marked.
  4. Valid shipments get a PDF document, uploaded to Drive.
  5. The PDF is sent to sender and receiver and the sheet is updated.

Use cases

  • Freight forwarders
  • 3PL and courier companies
  • Export and import desks

What you need

This workflow connects to these apps.

  • Google Drive
  • OpenAI
  • Google Sheets

You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.

  • Gmail account
  • Google Drive account
  • Google Sheets Trigger account
  • Google Sheets account
  • OpenAI account

Data setup

Create these tables with these exact column names before the first run.

TableColumns
Freight Documentation → Sheet1Google SheetsColumns are in the README.
Freight Documentation → Shipping DetailsGoogle SheetsShipment ID / Reference NumberStateDrive_link
Freight Documentation → Carrier DetailsGoogle SheetsStatus

Setup

  1. Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
  2. Connect the credentials listed above.
  3. Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
  4. Replace placeholder emails, phone numbers, and form links with your own.
  5. Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.

Nodes

NodeType
Google Sheets TriggergoogleSheetsTrigger
Loop Over ItemssplitInBatches
OpenAI Chat ModellmChatOpenAi
Structured Output ParseroutputParserStructured
Send Shipment PDF To Sendergmail
Send Shipment PDF To Receivergmail
Get PDFextractFromFile
PDF GeneratehttpRequest
Set Shipment Datacode
If Validateif
Send Mismatch Items Detailsgmail
Update StategoogleSheets
Append or update row in sheetgoogleSheets
Validate Shipment detailsagent
Upload filegoogleDrive
Download FilehttpRequest
Carrier DetailsgoogleSheetsTool

Frequently asked questions

Validates new shipment entries with AI, generates the freight document as a PDF, stores it in Drive and emails it to both shipper and receiver. Mismatches are flagged before anything goes out. It's a 18-node n8n workflow.

An n8n instance, on n8n Cloud or self-hosted, and credentials for Gmail, Google Drive, Google Sheets, and OpenAI. It uses only nodes that ship with n8n, so there's nothing else to install.

It works with 3 tables in Google Sheets. Create them with the column names listed under Data setup on this page before the first run.

Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.

Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.

Keep exploring
  • n8n canvas of the Delivery Route Optimization & Driver Dispatch workflow

    Logistics22 nodes

    Delivery Route Optimization & Driver Dispatch

    Groups today's ready orders into routes, picks an available truck, calculates distance and time, checks the weather on the route and sends the driver a WhatsApp brief with a map link.

  • n8n canvas of the Proof of Delivery AI Verification workflow

    Logistics13 nodes

    Proof of Delivery AI Verification

    Drivers send a delivery photo on WhatsApp. AI vision checks it for a signature, package and readability, then saves it to Drive, logs it in a sheet and confirms, or asks for a clearer photo.