Automatically create whatsapp groups from given database records and respective invitation links

I have stored a bunch of locations on a DB.

I’m looking forward to create a whatsapp group for each location automatically with minimum contacts at first and generate the respective invitation link.

The idea is within a map where all those locations are mapped, users can sign into each location specific whatsapp group chat via invitation link.

Is it possible to do it with a certain level of automation? What would be the most effective way to achieve such?