Clients' Challenge
Publiq is responsible for the UiTdatabase. This is the biggest database for events in Flanders and Brussels. Every year, more than 28.000 organizers enter more than 215.000 activities in this database, whether there are concerts, exhibitions, film, sporting events or something else. Additionally, on a weekly basis, every cinema in Flanders sends them a report with their detailed weekly schedule. This often via Gmail. For every email, new information thus needs to be added into the enormous database. This email data extraction was done manually. A weekly repetitive and time-consuming task.
Our Solution
To help executing this task, we made use of Intelligent Automation (IA), a combination of process automation and machine learning (ML) to accelerate and facilitate a business process. Our solution used both Document AI from the Google Cloud Platform (GCP) to extract information from the mails, and the Google Workspace environment to extract, transform and load (ETL) the data into the database using both Google App Script and App Sheet.The overall solution was englobed within a fully automated flow that ensures faster processing.
Created Impact
Thanks to the intelligent automation flow, the film intake process has become more effective, with faster data reading, processing and ingestion. A fully automated flow allows for easier maintenance and a reduction in time of human effort. The solution allowed for an original time of 2-3 hours/week to be reduced to a time of less than 10 minutes of validating a week. Our solution was developed for one type of email but is scalable to all film emails.
