Companies often face the problem of a large volume of incoming documents that come through various channels. Manual processing and archiving of these documents leads to:
The system automatically accepts PDF documents sent to corporate Gmail and also allows users to send files via a special Telegram bot. The system initiates a script when a new email or Telegram message is received.
For the Telegram bot, the chat_id is checked in the Employees database in Notion DB.
Only PDF files are accepted. Other formats are rejected or auto-converted.
Documents undergo optical text recognition (OCR) using the Google Cloud Vision API.
Once the text is extracted, the data is sent to ChatGPT/GPT-3, which automatically generates a short summary, determines the category and keywords for each document.
All processed data and document metadata are automatically created in the Notion DB "Document Archive" with fields: Name, Category, PL Summary, UA Summary, Keywords, GDrive Link, Status.
Files are stored in a logically organized manner in Google Drive, in folders by category and date:
Document Archive////....
After archiving, the bot sends a message to Telegram informing about the category, summary, and link to the document.
Users can answer the question "Do you agree with the archiving?" with the text "Yes" or "No". If the user rejects archiving, the file is deleted from Google Drive and the corresponding record in Notion.
The system handles exceptions. For an unsupported format, the response "Format not supported, send PDF" is sent. If the OCR is less than 80%, the status is marked as "Requires Manual Review" and a notification is sent to the #archive_manual channel. If there is no category, LLM prompts the user. No duplicate files are created by MD5 checksum, the bot reports "Document is already in the archive".
A monthly report is generated in PDF format and sent to the #management_reports Slack channel. The report includes the number of processed documents, saved man-hours (FTE), ROI calculation, and errors/exceptions.
AI automation for SMBs, recruiters & HR teams.
Thanks for reaching out!
Our experts will get in touch within 24 hours to schedule your free consultation