Validate shipments & generate freight documents with GPT-4o, Google Sheets & Drive
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 17 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets, OpenAI Chat Model, Gmail and Google Drive. It also calls v2.convertapi.com over HTTP.
How it runs
Trigger: On Google Sheets events (row added).
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Validate Shipment details (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (Carrier Details); output parser: Structured Output Parser
- If: checks a condition and branches into true / false
- Set Shipment Data (Code): runs custom JavaScript code
- Send Mismatch Items Details (Gmail): uses Gmail
- PDF Generate (HTTP Request): calls v2.convertapi.com (POST)
- Update State (Google Sheets): append or update
- Get PDF (Extract from File): extracts data from a file (from json)
- Send Shipment PDF To Sender (Gmail): uses Gmail
- Send Shipment PDF To Receiver (Gmail): uses Gmail
…plus 3 more steps. See the full node list below.
Services it uses
HTTP calls to: v2.convertapi.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Gmail
n8n-nodes-base.gmail - Extract from File
n8n-nodes-base.extractFromFile - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Drive
n8n-nodes-base.googleDrive - Google Sheets Tool
n8n-nodes-base.googleSheetsTool
From the author
✅ What problem does this workflow solve? Logistics teams spend hours manually validating shipment data, checking compliance, generating freight documents, and emailing stakeholders. Errors in HSN codes, weights, or carrier details can lead to shipment delays,…