Match lost and found items with OpenAI, SendGrid and Google Sheets
Needs changesWhat this workflow does
This AI workflow has 22 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects OpenAI Chat Model. It also calls sheets.googleapis.com and api.sendgrid.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Prepare Report Context (Edit Fields (Set)): sets 8 fields: reportType, itemDescription, location…
- AI - Normalize & Validate Report (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- JS - Parse AI Normalization (Code): runs custom JavaScript code
- Filter: keeps only the items that match a condition
- Fetch Existing Opposite Reports (HTTP Request): calls sheets.googleapis.com
- JS - Parse Existing Reports (Code): runs custom JavaScript code
- Python - Score Candidate Matches (Code): runs custom Python code
- JS - Select Best Match (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- AI - Generate Match Notification Message (AI Agent): runs an AI agent, with model: OpenAI Chat Model
…plus 9 more steps. See the full node list below.
Services it uses
HTTP calls to: sheets.googleapis.com, api.sendgrid.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI - Normalize & Validate Report (v1.6), AI - Generate Match Notification Message (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI - Normalize & Validate Report (v1.6), AI - Generate Match Notification Message (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (11)
- Webhook
n8n-nodes-base.webhook - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Respond to Webhook
n8n-nodes-base.respondToWebhook - Wait
n8n-nodes-base.wait
From the author
Quick overview This workflow accepts lost-and-found item reports via a webhook or a 20-minute schedule, uses OpenAI to generate an empathetic notification message, then sends the email through SendGrid and logs each processed case to Google Sheets. How it…