Create a searchable document archive with Telegram, Drive, OCR and Airtable

Name: Create a searchable document archive with Telegram, Drive, OCR and Airtable
Availability: InStock
Rating: 4.5 (11 reviews)
Author: Oneclick AI Squad

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

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 a Telegram /search command.

Key Features

Accepts images and documents from Telegram
Uploads files to Google Drive automatically
Detects file type and runs OCR if eligible
Extracts text from images & PDFs via Google Vision
Stores file metadata + text in Airtable
Search documents using /search command in Telegram
Sends result previews and file links
Error handling & user notifications included

Use Cases

Personal document vault with search
Team knowledge filing system
Receipt & invoice OCR archive
Legal documents store & retrieval
Research papers & notes indexing
Company file inbox for AI knowledge base

Workflow Steps

Step	Action	Description
1	Telegram Trigger	Detects incoming docs/images or `/search` command
2	Filter File or Search	Routes based on whether message has file or search command
3	Extract Metadata	Reads file info such as name, MIME type, user
4	Download File	Downloads file via Telegram API
5	Upload to Drive	Saves file in Google Drive
6	OCR Check	Determines if file supports OCR
7	Google OCR	Runs OCR for images/PDFs
8	Extract Text	Pulls text output from OCR
9	Merge OCR Text	Combines file data + text
10	Save to Airtable	Indexes with metadata + text
11	Success Reply	Sends link + success message
12	`/search` Flow	Parse search query
13	Airtable Search	Full-text search for records
14	Send Results	Sends matches to Telegram
15	Error Handler	Notifies user on failure

Input Formats

File Messages Supported

Images
PDFs
Documents

Search Command

/search keyword

Example:

/search invoice

Output

After Upload:

✅ File saved & indexed successfully!
🔗 Drive Link: &lt;link&gt;

After Search:

Returns structured result:

File name
Preview text snippet
Google Drive link

Data Stored in Airtable

Field	Description
File Name	Original name
File Link	Google Drive link
MIME Type	File type
Telegram User	Sender info
OCR Text	Extracted searchable text
Uploaded Date	Timestamp

Technical Requirements

Telegram Bot Token
Google Drive API connection
Google Vision API key
Airtable API key & table

Benefits

Automatically organizes Telegram files
Makes PDFs & images searchable
Saves manual sorting and indexing time
AI-ready data storage (future LLM integration)
Fast search experience right in Telegram

Enhancement Ideas

Add Whisper for voice message transcription
Add chat GPT summarization for large docs
Build dashboard for uploaded files
Auto-tag documents (invoice, ID, receipt etc.)
Multi-language OCR support

Status

✅ Ready for production ✅ Handles images, PDFs, and files ✅ End-to-end automation 🛠 Optional: add more AI enrichment later

Oneclick AI Squad

0 workflows

Nodes

set gmail telegram agent google-gemini

Complexity

advanced

Published 31 Oct 2025

Likes 0

View on n8n.io Download Workflow

✨

Share Your Workflow

Have a great workflow to share? Join the n8n Creator Hub and help the community!

Submit Your Template How to Submit

Related Workflows

Analyze legal contracts with GPT-4.1 and manage cases in Google Sheets and Slack

## Who this workflow is for Law firms in corporate, litigation, or family law needing streamlined case and contract management. ## What this workflow does Automatically analyzes contracts using AI, extracts key clauses, logs cases in Google Sheets, routes cases to attorneys, sends client summaries, generates PDFs, and schedules follow-ups. ## How the workflow works 1. Webhook triggers on new case or contract 2. AI analyzes contract 3. Case routed by type 4. Logs case info in Google Sheets 5. Notifies attorney via Slack 6. Sends client email summary 7. Generates PDF report 8. Schedules follow-up events 9. Optional integration with practice management software **Author:** Hyrum Hurst, AI Automation Engineer **Company:** QuarterSmart **Contact:** [email protected]

View

Forecast and report multi-channel tax liabilities with OpenAI, Gmail, Sheets and Airtable

## How It Works This workflow automates tax compliance by aggregating multi-channel revenue data, calculating jurisdiction-specific tax obligations, detecting anomalies, and generating submission-ready reports for tax authorities. Designed for finance teams, tax professionals, and e-commerce operations, it solves the challenge of manually reconciling transactions across multiple sales channels, applying complex tax rules, and preparing compliant filings under tight deadlines. The system triggers monthly or on-demand, fetching revenue data from e-commerce platforms, payment processors, and accounting systems. Transaction records flow through validation layers that merge historical context, classify revenue streams, and calculate tax obligations using jurisdiction-specific rules engines. AI models detect anomalies in tax calculations, identify unusual deduction patterns, and flag potential audit risks. The workflow routes revenue data by tax jurisdiction, applies progressive tax brackets, and generates formatted reports matching authority specifications. Critical anomalies trigger immediate alerts to tax teams via Gmail, while finalized reports store in Google Sheets and Airtable for audit trails. This eliminates 80% of manual tax preparation work, ensures multi-jurisdiction compliance, and reduces filing errors. ## Setup Steps 1. Configure e-commerce API credentials for transaction access 2. Set up payment processor integrations (Stripe, PayPal) for revenue reconciliation 3. Add accounting system credentials (QuickBooks, Xero) for financial data 4. Configure OpenAI API key for anomaly detection and tax analysis 5. Set Gmail OAuth credentials for tax team alert notifications 6. Link Google Sheets for report storage and audit trail documentation 7. Connect Airtable workspace for structured tax record management ## Prerequisites Active e-commerce platform accounts with API access. Payment processor credentials. ## Use Cases Automated monthly sales tax calculations for multi-state e-commerce. ## Customization Modify tax calculation rules for specific jurisdiction requirements. ## Benefits Reduces tax preparation time by 80% through end-to-end automation.

View

Automate satellite data analysis and regulatory reporting with GPT-4 and Slack

## How It Works This workflow automates satellite data processing by ingesting raw geospatial data, applying AI analysis, and submitting formatted reports to regulatory authorities. Designed for environmental agencies, research institutions, and compliance teams, it solves the challenge of manually processing large satellite datasets and preparing standardized submissions for government agencies. The system triggers on scheduled intervals or event webhooks, fetching satellite imagery and sensor data from ECC/climate APIs. Raw data flows through parsing and normalization stages, then routes to AI models for analysis—detecting environmental changes, calculating metrics, and identifying anomalies. Processed results are validated against agency specifications, formatted into SDQAR reports, and automatically stored in designated repositories. The workflow generates submission packages with required metadata, notifies stakeholders via Slack and email, and logs all activities to Google Sheets for audit trails. This eliminates hours of manual data processing, ensures compliance with submission standards, and accelerates environmental monitoring workflows. ## Setup Steps 1. Configure ECC/climate API credentials for satellite data access 2. Set up webhook endpoints for event-driven data ingestion triggers 3. Add OpenAI API key for geospatial analysis and anomaly detection 4. Configure NVIDIA NIM API for specialized environmental modeling 5. Set Google Sheets credentials for audit logging and tracking 6. Connect Slack workspace and specify notification channels for submission updates 7. Configure Gmail OAuth for automated stakeholder notifications ## Prerequisites Active satellite data API access (ECC, NASA, ESA) with authentication credentials. ## Use Cases Automated climate monitoring with monthly regulatory submissions. ## Customization Modify AI analysis prompts for specific environmental parameters. ## Benefits Reduces satellite data processing time by 85% through end-to-end automation.

View

👨‍💻

Need Custom Automation?

N8N Automation Expert

Specialized in N8N automation, I design custom workflows that connect your tools and automate your processes.