Mundo Lógico
Case studies/Public agency · Medellín
Public sector · Culture

A smart cultural calendar for a city

From 13 disconnected sources to a single database of 8,212 events, with an AI agent serving citizens on WhatsApp 24/7.

The problem

A public cultural agency needed to consolidate a city's events calendar from more than 13 different organizations. The manual process took hours every week and produced inconsistent data.

What we built

Project 1. Smart scraping network: 13 automations in Make.com that pull events from each source, process them with OpenAI to standardize the format, and insert or update them automatically in Airtable. The website queries this database in real time.

Project 2. Conversational agent: an AI assistant connected directly to the events database. It serves citizens on WhatsApp, answers only with real data (not the model's general knowledge), and when the conversation ends it automatically sends a 5-question satisfaction survey.

Tech stack

Make.com
Make.com
OpenAI
OpenAI
Airtable
Airtable
WhatsApp API
91%
of users would recommend the channel
8,212
events in the live database
2,036
unique users served on WhatsApp
18,927
messages processed in 18 months

Does your business have processes that could be automated?

Book a 20-minute call. We review one specific process and tell you whether it is worth automating.