Route commodity sample quality approvals with Telegram, Claude and spreadsheets
Needs changesWhat this workflow does
This workflow has 160 nodes and runs when someone submits an n8n form (“Dispatch a sample”) (plus 6 other triggers). Along the way it connects Microsoft Excel 365, Google Sheets, Microsoft Outlook and Telegram.
How it runs
Trigger: When someone submits an n8n form (“Dispatch a sample”) (plus 6 other triggers).
- Configuration (Edit Fields (Set)): sets 18 fields: register_table_id, spec_table_id, log_table_id…
- Configuration B (Edit Fields (Set)): sets 18 fields: register_table_id, spec_table_id, log_table_id…
- Route the update (Code): runs custom JavaScript code
- Parse the button (Code): runs custom JavaScript code
- Configuration E (Edit Fields (Set)): sets 18 fields: register_table_id, spec_table_id, log_table_id…
- Configuration F (Edit Fields (Set)): sets 18 fields: register_table_id, spec_table_id, log_table_id…
- Normalise dispatch form (Code): runs custom JavaScript code
- Normalise receipt form (Code): runs custom JavaScript code
- Configuration C (Edit Fields (Set)): sets 18 fields: register_table_id, spec_table_id, log_table_id…
- Configuration D (Edit Fields (Set)): sets 18 fields: register_table_id, spec_table_id, log_table_id…
…plus 143 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Convert to/from binary data in Read the file as base64: replace with Convert to File or Extract from File.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Convert to/from binary data Read the file as base64 | Convert to File or Extract from File |
Nodes used (16)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Microsoft Excel 365
n8n-nodes-base.microsoftExcel - Google Sheets
n8n-nodes-base.googleSheets - Data table
n8n-nodes-base.dataTable - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - Telegram
n8n-nodes-base.telegram - n8n Form
n8n-nodes-base.form - Telegram Trigger
n8n-nodes-base.telegramTrigger - Webhook
n8n-nodes-base.webhook - Convert to/from binary data
n8n-nodes-base.moveBinaryData - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow manages commodity sample dispatch, QR-based intake, assessment, and final approval by combining n8n Forms, Telegram, Anthropic (Claude) or any other LLM Model for data extraction, and a register stored in n8n Data Tables, Google…