What they needed

  • Turn a huge, incomplete spreadsheet into a clean, searchable online directory.
  • Make it easy for parents to find the closest school on an interactive map or filterable table.
  • Give staff a simple way to update school profiles themselves without calling a developer.

What I built

I built this custom Drupal website to help families easily find French public schools across Ontario. To keep their hosting costs low and reduce administrative work, I connected it directly to the ACÉPO platform. They share a single backend but run on completely separate databases. Visitors can search for schools using an interactive map or a clean table, with custom filters to find the location closest to them. I also integrated a custom AI chatbot that answers parent questions using current information from the directory and from the open web. To speed up the launch, I imported their massive Excel spreadsheet of schools, cleaned up the data, and filled the missing records with an automated AI crawl. Now, the staff can easily update the directory themselves. I even built a monitoring automation that alerts the team if a school's website goes down, and I structured the entire directory by city to boost their local search traffic on Google.

Features of this website and automation

  • Interactive map and filterable directory of French public schools
  • Custom AI chatbot answering parent questions from up-to-date directory and web sources
  • School records imported from a large Excel spreadsheet, then completed and verified by an automated AI web crawl
  • Directory organized by city for local search visibility
  • Monitoring automation that alerts the team when a school's own site goes down
  • Staff-editable directory, no developer needed for updates

What changed

  • Staff now manage one central school directory that they can edit anytime.
  • An automated AI web crawl filled in the missing school details before launch, saving weeks of manual data entry.
  • A custom AI chatbot answers parents' questions right on the page using live directory and web data.
  • Organizing the directory by city brings in steady Google traffic from parents searching for schools in their area.
  • An automated monitor alerts the team if a school's own website goes offline, before parents run into a dead link.

What this means for a business like yours

A lot of organizations sit on useful spreadsheets that are frustrating for visitors to actually use on a website. Instead of spending weeks filling in missing details by hand, I used an automated AI crawl to verify and complete the data before importing it. And by organizing the directory into clean pages by city and pairing it with an interactive map and chatbot, parents can actually find what they need, whether they start on Google or right on the site.

Built with

  • Drupal
  • Interactive map and filters
  • Custom AI chatbot on current directory and web data
  • Spreadsheet import, completed by an automated AI crawl
  • Automated site monitoring