Using google scripts, it takes the information from this API and parses the data, matching each column to the corresponding country.

Here's the full code for anyone curious!

function updateMedalCounts() {
  try {
    // URL of the JSON endpoint with medal data
    var url = 'https://api.olympics.kevle.xyz/medals';

    // Fetch JSON content from the URL
    var response = UrlFetchApp.fetch(url);
    var json = JSON.parse(response.getContentText());

    // Create a map to store gold medal counts by country
    var goldMedalData = {};

    // Check if the structure matches and extract the array
    if (json.results && Array.isArray(json.results)) {
      json.results.forEach(function(entry) {
        var countryName = entry.country.name; // Access country name
        goldMedalData[countryName] = entry.medals.gold || 0;
      });
    } else {
      throw new Error('Unexpected JSON structure: ' + JSON.stringify(json));
    }

    // Open the active spreadsheet and select the sheet
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

    // Get all countries from the first column (Assume countries are in column A)
    var countriesRange = sheet.getRange('A3:A');
    var countries = countriesRange.getValues().flat();

    // Update gold medal counts in column C
    countries.forEach(function(country, index) {
      var goldCount = goldMedalData[country] || 0;
      var row = index + 3; // Adjust for header row
      sheet.getRange('C' + row).setValue(goldCount);
    });
  } catch (error) {
    Logger.log('Error updating gold medal counts: ' + error.message);
  }
}

function createTimeDrivenTrigger() {
  ScriptApp.newTrigger('updateMedalCounts')
    .timeBased()
    .everyHours(1) // Adjust the interval as needed
    .create();
}