Skip to content
007

Public tender scanner

An automation that looks for work every day and emails a report in the morning

Client
EMC, my multimedia and exhibition production company
Scope
source research, scoring notices, PDF report, email delivery
Tools
Python, SQLite, Google Apps Script
Year
2026

Going through public procurement notices took a quarter of an hour a day, and most of them had nothing to do with the industry. It needed an automation that reads everything and shows only the hits.

The report arrives by email in the morning, only when something new has appeared.
The report arrives by email in the morning, only when something new has appeared.

How it works

It looks at several codes at once. The code for “multimedia equipment” on its own usually means a hardware delivery. A real commission carries several codes from different groups.

It understands Polish inflection. Different grammatical forms of the same phrase count as one phrase.

It skips notices past their deadline. The portal mixes open notices with settled ones, and only the open ones make the report.

Result

Out of 1764 notices checked, 29 made the report. Nobody has to read the rest any more.

Next projectCar park bookings in one calendar