Programmatic SEO? How it should be done in 2025?

I am clueless about this old but tricky technique about creating thousands of pages as zappier do. I got to know about this through some YouTube channel but nobody is teaching it there so I am now curious about it. I think they use some script to create it so now I am curious about it. Can somebody help me on it? as I am planning to do it on my website to target multiple cities.