问将数据获取到Google Sheets

EN

const sheet = SpreadsheetApp.openById('yourSpreadsheetId').getSheetByName('yourSheetName');
const data = [
    {
        "ID": "AF",
        "LocalizedName": "Afghanistan",
        "EnglishName": "Afghanistan"
    },
    {
        "ID": "AM",
        "LocalizedName": "Armenia",
        "EnglishName": "Armenia"
    },
]; // replace with your data fetch logic

// collect your row data into array of arrays
const rows = [];
for (const location of data) {
  rows.push([location.ID, location.LocalizedName]);
}

// get range beginning at the first row and first column,
// with number of rows equels to amount of rows, and 2 as a number of cols
// and fill it with your data
sheet.getRange(1, 1, rows.length, 2).setValues(rows);