How to get Sheet Data as a table in Google Docs
Sheet data as table in docSelect all the sheet data range as an array of values Get the values as a nested array of array items. Select the doc and use the appendTable to the body of the document. DocumentApp.openById(DOCID).getBody().appendTable(getValues1()); const SHEETID = ‘1u7vPqjklpmn8ygU’;const DOCID = ‘1yoV_oFO-v7963hhIrY’; function getValues1() {const ss = SpreadsheetApp.openById(SHEETID);const sheet = … Read more