Verify photo proof of delivery with gpt-5.6-terra, Google Sheets, Gmail and Telegram
Ready for 3.0What this workflow does
This AI workflow has 47 nodes and runs when someone submits an n8n form (“Delivery Proof Form”) (plus 2 other triggers). Along the way it connects Gmail, Telegram, Google Sheets and OpenAI Chat Model. It also calls api.openai.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Delivery Proof Form”) (plus 2 other triggers).
- Normalize submission and check photo (Code): runs custom JavaScript code
- Read deliveries for sweep (Google Sheets): uses Google Sheets
- Read proof log for summary (Google Sheets): uses Google Sheets
- Validate waybill present (If): checks a condition and branches into true / false
- Find overdue deliveries (Code): runs custom JavaScript code
- Summarize proof log week (Code): runs custom JavaScript code
- Read deliveries register (Google Sheets): uses Google Sheets
- Build invalid submission alert (Edit Fields (Set)): sets 4 fields: pod_id, email_subject, email_body…
- AI write overdue nudge (AI Agent): runs an AI agent, with model: Overdue nudge model
- AI write weekly summary (AI Agent): runs an AI agent, with model: Weekly summary model
…plus 32 more steps. See the full node list below.
Services it uses
HTTP calls to: api.openai.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 (11)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail - Telegram
n8n-nodes-base.telegram - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Schedule Trigger
n8n-nodes-base.scheduleTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
Proof of delivery that checks itself. This workflow collects driver submissions from an n8n Form, matches each waybill against your Google Sheets deliveries register, verifies the uploaded photo with OpenAI vision (gpt-5.6-terra), and confirms the delivery or…