You can also try ImportJSON() in google sheet to capture data in just one section. It does allow you to add URL and filters. this is one of the simplest method with 0 effort, I feel

example:
IMPORTJSON("https://restcountries.eu/rest/v2/", "/name", A1:D2)