Not currently possible with how zola works. Zola expects a markdown source for every page you want to create. I previously asked for this two years ago but it didn’t gain any traction: Dynamically create pages from data
In that thread though is a possible solution that you could run outside of zola. Might be something you could try?
An alternative is to use a different SSG that can handle external sources like CSV or JSON. Eleventy might be a good option.
EDIT: If you were happy to make a one page project, you can use Zola’s load_data to parse a CSV and loop through it, rendering out every entry onto the same page. Probably not what you want though.