Automated receipt and stub repository system
Today I'm starting a series where I'll present projects developed to address pain points/demands that arise in the day-to-day operations of companies, showcasing ways of thinking and technical strategies to make things happen.
Issue:
Signed receipt stubs need to be sent to customers. However, these stubs arrive via frontline employees through photos sent in a WhatsApp group.
Solution:
I set up the following structure: (1) users sign and (2) send the image to the Whatsapp group.
I (3) created a bot that monitors this group on Whatsapp (it's a number that was added to the group) and, for each image it detects, (4) stores this image on a server.
From there, I created an automation (5) that monitors this server for detection of new images and through computer vision extracts important data such as NF and CT-e numbers.
This information is structured and sent to a (6) portal where the operator can validate it. In parallel, another automation (7) scans an email waiting for notification from the ERP about the Customer (CNPJ) / NF / CT-e relationship.
With everything in the (8) database, I created a (9) panel for the client to access (CNPJ / Password) and view their receipts.