Location pages plugin / Script / Solution for wordpress site running elementor

Hi,

I run a national service website in the UK which has location / service pages for every town / city / village in the UK.

The site has been built on Elementor

We started off with just a single location page for each location as we only offered one service.

The company has now expanded and we will be building out to be offering 10+ services to each location over the next 3-6 months.

We need a solution to automate the building of new location pages and internal linking of the new / existing location pages.

There are many variations to the content of each service / location page including the location name, the google maps embed URL, the internal links to other pages in each county, links to other service / location pages in that location etc

I think a logical way to build it would be to have a database of counties, which also contains the towns / villages in each county. Also have Services in the database (so the database knows which services are already live for each county, town, village).

Then when we want to add a new service we upload a csv of the editable data for the county, the csv would contain the locations and all of the variables.

Potentially we should also have the option to provide unique content for each location in txt files from the csv