osu quals query

var scriptProperties = PropertiesService.getScriptProperties();
var token = "redacted"
var ss = SpreadsheetApp.getActiveSpreadsheet();
var qualsheet = ss.getSheetByName("result")
var linksheet = ss.getSheetByName("link")

function getMatchData(matchID) {
    var url = "https://osu.ppy.sh/api/get_match?k=" + token + "&mp=" + matchID;
    var response = UrlFetchApp.fetch(url);
    var json = response.getContentText();
    return JSON.parse(json);
}

function updateSheet() {
    var row = 1;
    var mplinks = linksheet.getRange("A1:A").getValues().filter(String);
    mplinks.forEach(function(link){
        var matchID = link.toString().slice(37);
        var results = getMatchData(matchID);
        results["games"].forEach(function(game){
            game["scores"].forEach(function(score){
                if(score["score"]){
                    qualsheet.getRange(row, 1, 1, 3).setValues(
                        [[
                            game["beatmap_id"],
                            score["user_id"],
                            score["score"]
                        ]]);
                    row++;
                }
            });
        });
    });
}