I started Spatial Thoughts in 2020 as an online training academy. We have been hosting cohort-based training courses ever since and the business has steadily grown over the years. As with many small businesses, most of our data is scattered across spreadsheets, emails, and different SaaS platforms. As the number of training participants grew, I found it increasingly hard to find the data I needed to make decisions. For example, I frequently would go down a rabbit hole to answer questions like,
- Which of our participants received scholarships for a course but haven’t yet completed the certification?
- Can I get a list of our QGIS-certified participants from Germany?
- Do we know anyone who is skilled in both Earth Engine and Python and lives in Australia?
- We are launching a new course and want to reach out to everyone who has completed our intermediate Python courses. Can we get their emails?
These were really difficult to answer and involved manual searches and digging through various spreadsheets. I had always dreamt of having a unified database that I could query and find an answer. This type of database – also known as a Customer Relationship Management (CRM) – is something out of reach for small businesses like mine. The costs and time involved for building something custom and tailored to my needs were never justified. But things have changed rapidly in the past few months. With AI-coding tools – like Claude Code – building systems like these is no longer out of reach. I spent a lazy afternoon with Claude Code and built exactly what I needed. Everything from data extraction to building a private web app. I was blown away by the capabilities of modern AI tools and want to share the process here.
Continue reading





