{"product_id":"verify-proof-of-delivery-photos-with-gpt-4o-mini-in-n8n","title":"Verify Proof of Delivery Photos with GPT-4o Mini in n8n","description":"\u003ch3\u003eAutomatically verify delivery proof photos in n8n using GPT-4o mini\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures proof-of-delivery (POD) submissions from drivers, matches them to your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e deliveries register, verifies the uploaded photo with \u003cstrong\u003eOpenAI (GPT-4o mini) vision\u003c\/strong\u003e, and then logs results while notifying both \u003cstrong\u003eops\u003c\/strong\u003e and the \u003cstrong\u003ecustomer\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a driver submission\u003c\/strong\u003e from an \u003cstrong\u003en8n Form\u003c\/strong\u003e containing waybill\/order number, recipient name, optional notes, and an optional delivery photo.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates the data\u003c\/strong\u003e: generates a POD ID and flags whether a usable photo file is attached.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles missing waybill\u003c\/strong\u003e: if the waybill is missing, the workflow emails ops via \u003cstrong\u003eGmail\u003c\/strong\u003e, posts an alert to \u003cstrong\u003eTelegram\u003c\/strong\u003e, and stops processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks waybill in Google Sheets\u003c\/strong\u003e: looks up the submitted waybill in the \u003cstrong\u003eDeliveries\u003c\/strong\u003e register; if not found, it appends an \u003cstrong\u003e“Unrecognized waybill”\u003c\/strong\u003e entry to \u003cstrong\u003ePodLog\u003c\/strong\u003e and alerts ops.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles missing photo\u003c\/strong\u003e: if the waybill exists but no photo is provided, it logs a \u003cstrong\u003e“no photo”\u003c\/strong\u003e exception to \u003cstrong\u003ePodLog\u003c\/strong\u003e and notifies ops via Gmail + Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVerifies photo with GPT-4o mini\u003c\/strong\u003e: when a photo is provided, it sends the image and context to \u003cstrong\u003eOpenAI (GPT-4o-mini)\u003c\/strong\u003e to classify the POD as \u003cstrong\u003e“ok”\u003c\/strong\u003e or \u003cstrong\u003e“mismatch”\u003c\/strong\u003e, returning a short summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates outcomes\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eIf \u003cstrong\u003eok\u003c\/strong\u003e: updates the delivery row to \u003cstrong\u003eDelivered\u003c\/strong\u003e, logs the verified result to \u003cstrong\u003ePodLog\u003c\/strong\u003e, emails the \u003cstrong\u003ecustomer\u003c\/strong\u003e via Gmail, and posts a confirmation to Telegram.\u003c\/li\u003e\n      \u003cli\u003eIf \u003cstrong\u003emismatch\u003c\/strong\u003e: logs the exception to \u003cstrong\u003ePodLog\u003c\/strong\u003e and alerts ops via Gmail + Telegram.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConfirm POD photos for last-mile deliveries and automatically mark shipments as \u003cstrong\u003eDelivered\u003c\/strong\u003e in your registry.\u003c\/li\u003e\n  \u003cli\u003eDetect and escalate issues like \u003cstrong\u003emissing waybills\u003c\/strong\u003e, \u003cstrong\u003emissing photos\u003c\/strong\u003e, unrecognized waybills, or \u003cstrong\u003ephoto mismatches\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eReduce manual ops effort by using \u003cstrong\u003eGPT-4o mini\u003c\/strong\u003e vision verification and structured logging in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: if, set, code, gmail, telegram, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData sources\u003c\/strong\u003e: n8n Form input, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (“Deliveries” and “PodLog” sheets)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI verification\u003c\/strong\u003e: \u003cstrong\u003eOpenAI GPT-4o mini\u003c\/strong\u003e vision to classify POD as ok vs mismatch and provide a brief summary\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46001889345715,"sku":"N8N-19440","price":50.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WJA_nUOGLcLNpSMPQOC9s_0TCEXdVe.png?v=1789118432","url":"https:\/\/buyflowscripts.com\/products\/verify-proof-of-delivery-photos-with-gpt-4o-mini-in-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}