Automation n8n
TECHNICAL TASK
Automation of Document Processing via Telegram Bot on n8n Platform
1. GENERAL PROJECT DESCRIPTION
It is necessary to create an automated workflow on the n8n platform that will ensure document processing through a Telegram bot with subsequent analysis using the Claude API, comparison with a reference list of documents in Google Sheets, automatic checkbox marking, and document archiving.
2. TECHNICAL STACK
- Automation platform: n8n
- Messenger: Telegram Bot API
- AI analysis: Claude API (prompt provided by the Client)
- Data storage: Google Sheets
- Archive generation: Google Apps Script (already prepared)
- File formats: PDF, DOCX
3. FUNCTIONAL REQUIREMENTS
3.1 File Reception via Telegram
Input data:
- The user sends from 1 to 6 files via the Telegram bot
- File types: PDF, DOCX
- Number of employee users: several people
Technical requirements:
- The bot must accept multiple file uploads (up to 6 files per request)
- Store files for further processing
- Confirm receipt of files to the user
3.2 Document Analysis using Claude API
Process:
- All received files are sent for analysis to the Claude API
- A ready-made instruction (prompt) provided by the Client is used
- Claude analyzes the content of the documents and extracts information
Response format:
- JSON structure (format defined by the Client)
- Contains names/types of documents identified in the files
Technical requirements:
- Processing of all file types (PDF, DOCX)
- Saving the JSON response for further processing
3.3 Comparison with Reference List and Checkbox Marking
Source of reference data:
- Google Sheets (specific sheet will be provided by the Client)
- Structure: one row = one document = one checkbox
- The reference list of document names is stored in the same sheet
Comparison logic:
- Comparison of document names from the JSON response with the reference list
- Comparison principle: content match (not necessarily exact text match)
- All names in the reference list are unique (guaranteed by the Client)
Actions upon finding a match:
- An active checkbox (checked) is marked in the corresponding row of Google Sheets
Result:
- The list of documents is divided into two categories:
- Found: documents that matched the reference list (checkboxes marked)
- Not found: documents that did not match any position in the reference
3.4 Document Archive Generation
Process:
- After checkbox marking, the existing Google Apps Script is called
- The script generates a ZIP archive with PDF documents based on the marked checkboxes
- The archive is formed automatically
Technical requirements:
- n8n must call the execution of the existing Google Apps Script
- Obtain a link or file of the generated archive
3.5 Returning Results in Telegram
What is returned to the user:
- Document archive (ZIP file received from Google Apps Script)
- List of not found documents - a simple text list of document names that did not match the reference list
Message format:
✅ Processing completed!
📦 Document archive: [file]
❌ Not found documents:
- [Document Name 1]
- [Document Name 2]
- [Document Name N](if all documents are found, the "Not found documents" block is not displayed)
4. NON-FUNCTIONAL REQUIREMENTS
4.1 Performance
- Maximum processing time for a single request: up to 5 minutes
- The workflow must process requests sequentially (queue)
4.2 Logging
- Mandatory logging of all processing stages:
- Who (Telegram User ID/Username)
- When (date and time)
- Which files were uploaded (names, quantity)
- Result of Claude analysis
- Which checkboxes were marked
- Which documents were not found
- Execution status (success/error)
- Logs to be stored in a separate sheet of Google Sheets or another convenient format
4.3 Error Handling
- Details of error handling (Claude API unavailable, file processing errors, Google Sheets errors) will be agreed with the executor at the development stage
- The user must receive understandable error messages
5. RESPONSIBILITY ALLOCATION
Performed by the Client:
- ✅ Provides a ready-made instruction (prompt) for Claude API
- ✅ Provides access to Google Sheets with the structure
- ✅ Provides a ready-made Google Apps Script for archive generation
- ✅ Implements user authorization/authentication in the Telegram bot
- ✅ Defines the format of the JSON response from Claude
Performed by the Executor:
- ✅ Creates a workflow on the n8n platform
- ✅ Configures Telegram Bot integration
- ✅ Configures Claude API integration
- ✅ Configures Google Sheets API integration
- ✅ Implements document comparison logic
- ✅ Implements automatic checkbox marking
- ✅ Configures the call to Google Apps Script
- ✅ Implements process logging
- ✅ Agrees with the Client on error handling
- ✅ Conducts workflow testing
-
Good day!
I have 3+ years of experience working with n8n, Telegram Bot API. I am ready to implement a complete workflow: receiving documents in Telegram, analyzing through Claude API, matching with a reference list in Google Sheets, marking checkboxes, calling a ready Google Apps Script to create an archive and return results, and logging in a separate sheet.
Can we discuss the details?
-
1315 7 0 Good day.
I am ready to take your project into work.
I can develop such automation for you using n8n.
Write to me privately, we will discuss all the details and can start the implementation.
-
2848 17 0 1 Hello, Danilo!
The task is completely clear. The technical implementation will take about 3 days; if there is a need to upgrade the prompt, I can help with that as well. There are no questions regarding anything else. The only thing that might be an issue is that the documents are large, and the AI may not process them effectively (but you will let me know if such a situation is even possible). However, there is a solution for this too, so there won't be any problems.
I have extensive experience, so it will be done well and on time)
Overall, regarding the deadlines: 3 working days.
As for the cost, 10,000 UAH would be fine, but we can discuss it.
-
206 We have carefully reviewed the technical assignment and are ready to implement this workflow on n8n as a turnkey solution.
We have practical experience working with n8n, Telegram Bot API, integrations via REST API, Google Sheets, and AI services (Claude / GPT). We understand the specifics of processing PDF and DOCX, building stable JSON output from AI, and implementing the logic of semantic comparison of documents.
We will pay special attention to:
the stability of the JSON response from Claude
correct semantic matching with the reference list
…
error handling and retry logic
the queue for processing requests (to stay within 5 minutes)
detailed logging of each stage
We have experience in building production automation solutions, where not only functionality but also reliability and transparency of the process are important.
Estimated implementation time: 8-9 working days (including testing).
We are ready to discuss the details, clarify the nuances of semantic comparison, and start working soon.
-
432 1 0 Hello, Danilo!
I can implement a complete workflow in n8n for automated document processing via Telegram with integration of Claude API, Google Sheets, and Google Apps Script.
I would be happy to discuss the details to propose the optimal solution.
-
893 1 0 Good day, Danil.
I am ready to create an automated workflow on the n8n platform for document processing via Telegram. I will integrate the Telegram Bot API, Claude API for analysis, Google Sheets API for comparison, and will call your Google Apps Script to generate the archive. I will ensure logging of all stages and error handling for stable system operation.
---
The main problem lies in the need for seamless integration of Telegram, Claude API, and Google Sheets for automating routine document checks. I will build a workflow in n8n that will reliably group incoming files (up to 6), convert PDF/DOCX to text for Claude, and process the JSON response for synchronization with your spreadsheet.
I will pay special attention to the comparison logic: instead of rigid searching, I will implement flexible matching of names so that Claude correctly identifies items from the reference list. After checking the boxes via Google Sheets API, n8n will initiate your Apps Script through HTTP Request and return the completed archive to the user along with a report on missing items.
…
For stability, I will set up a processing queue and detailed logging of each step (from user ID to API statuses) in a separate Google Sheets document, as specified in the technical specifications. I will use n8n, Telegram Bot API, and Claude API to create a fault-tolerant system.
---
We can agree on the exact price and deadlines during the discussion of the task details.