Hi forum member i am using this function to convert spreadsheet to pdf and send by mail it work fine the problem is that the spreadsheet have 6 sheet and the snapshot take all 6 i want to take snap of sheet 6 only GID6 so i try to add getsheet number can anyone help how to do it Tx itay
var copyId1 = DocsList.getFileById(docTemplate1)
.getId()
.getSheets()[6];
var pdf = DocsList.getFileById(copyId1).getAs("application/pdf");
