function myFunction() {
try {
let spread = SpreadsheetApp.openById("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx");
let sheet = spread.getSheetByName("Sheet1");
let range = sheet.getDataRange();
let values = range.getDisplayValues();
let bColors = range.getBackgrounds();
let fColors = range.getFontColors();
let present = SlidesApp.getActivePresentation();
let slide = present.getSlides()[0];
let table = slide.insertTable(values.length,values[0].length);
values.forEach( (row,i) => {
row.forEach( (text,j) => {
let cell = table.getCell(i,j)
cell.getText().setText(text);
cell.getText().getTextStyle().setForegroundColor(fColors[i][j])
cell.getFill().setSolidFill(bColors[i][j]);
cell
}
);
}
);
}
catch(err) {
console.log(err);
}
}