Create a searchable document archive with Telegram, Drive, OCR and Airtable
Ready for 3.0What this workflow does
This workflow has 17 nodes and runs on Telegram events (message, edited message). Along the way it connects Telegram, Google Drive and Airtable.
How it runs
Trigger: On Telegram events (message, edited message).
- Check if File/Image (If): checks a condition and branches into true / false
- Check Search Command (If): checks a condition and branches into true / false
- Extract File Metadata (Edit Fields (Set)): sets 5 fields: fileId, fileName, mimeType…
- Extract Search Query (Edit Fields (Set)): sets 2 fields: searchQuery, chatId
- Download File from Telegram (Telegram): work with file
- Search in Index (Airtable): search
- Upload to Google Drive (Google Drive): uses Google Drive
- Send Search Results (Telegram): uses Telegram
- Check if OCR Eligible (If): checks a condition and branches into true / false
- Google Vision OCR (HTTP Request): calls an HTTP API
…plus 6 more steps. See the full node list below.
Services it uses
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 (8)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Telegram
n8n-nodes-base.telegram - Google Drive
n8n-nodes-base.googleDrive - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Airtable
n8n-nodes-base.airtable
From the author
This n8n workflow receives files sent in a Telegram chat, uploads them to Google Drive, extracts text using OCR (for images and PDFs), and stores the extracted content in Airtable for quick search and retrieval. Users can later search through documents using…