如何获得Discord机器人从特定范围的Google表格中读取数据？

您可以尝试类似的方法，我尚未对此进行测试！我googleapis为此使用了npm-package。

/*
Assuming your table is something like this:
 |------------------|
 | Player  | Points |
 |------------------|
 | Player1 | 0      |
 | Player2 | 100    |
 |------------------|
*/
function checkPoints(auth,name) {
    return new Promise((resolve, reject) => {
        const sheets = google.sheets({ version: 'v4', auth });

        sheets.spreadsheets.values.get({
            spreadsheetId: '<your spreadsheetid>',
            range: '<Your Points sheetname>!A2:B', // A2 because i assume you got a title like "Name/Username" etc.
        }, (err, res) => {
            if (err) return console.log("The API returned an error: " + err);
            let list = [];
            for(let i = 0; i < res[0].length; i++){ //Loop throw all Players
                if(res[0][i] == name){
                    resolve(res[1][i]); //Returns the Points of the Player
                }
            }
        }
        );
    });
}

要使用此功能，您必须通过api传递auth（请查看googleapisPackage的文档）和名称。该函数返回一个Promise，然后您就可以执行了，就像我说过的，我还没有在不和谐的bot中测试过它。

checkPoints(auth,name).then(points =>{
    console.log("Points  of player " + name + ": " + points);
});