Smart shipping prioritization with Google Gemini and Google Sheets
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 8 nodes and runs when an HTTP GET request hits its webhook URL. Along the way it connects Date & Time, Google Gemini Chat Model and Google Sheets.
How it runs
Trigger: When an HTTP GET request hits its webhook URL.
- AI Agent: runs an AI agent, with model: Gemini Flash 2.; 2 tools (Shipping, Date & Time); output parser: Structured Output Parser
- Update (Google Sheets): update
- Screen (Respond to Webhook): sends the response back to the webhook caller
Services it uses
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 (8)
- Webhook
n8n-nodes-base.webhook - AI Agent
@n8n/n8n-nodes-langchain.agent - Date Time Tool
n8n-nodes-base.dateTimeTool - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Google Sheets
n8n-nodes-base.googleSheets - Respond to Webhook
n8n-nodes-base.respondToWebhook - Google Sheets Tool
n8n-nodes-base.googleSheetsTool
From the author
How it works This template waits for an external button to be pressed via webhook, then reads a Google Sheet with pending shipments. The sheet contains the columns: idEnvio, fechaOrden, nombre, direccion, detalle, and enviado. It determines the next shipment…