Smart Shipping Prioritization with Google Gemini & Sheets

This n8n workflow revolutionizes shipping operations by integrating Google Sheets for data management and Google Gemini AI for smart decision-making. Triggered by a webhook from an external button (e.g., Unihiker n8n Terminal), it reads pending shipments from a 'Shipping' Google Sheet with columns: idEnvio, fechaOrden, nombre, direccion, detalle, and enviado. The AI agent evaluates rows to select the highest priority shipment, prioritizing oldest orders but flagging urgent customer comments in 'detalle' that risk cancellation.

Once selected, the workflow marks the 'enviado' column with an 'X' to track completion and forwards key details (idEnvio, nombre, direccion, detalle) to the terminal for execution. This ensures efficient, context-aware prioritization beyond simple FIFO, reducing errors and delays in delivery management.

Ideal for e-commerce, logistics firms, or small businesses handling manual shipping queues. Benefits include time savings (automates selection in seconds), improved customer satisfaction (handles urgent notes), scalability (handles growing sheet data), and seamless integration with hardware like Unihiker. Setup is straightforward: create the sheet, connect credentials, and link the webhook URL.