'Google Apps Script - Cant read dynamic id

Here in the code I am trying to change variables from Google Sheet to Google doc and then create a pdf. Here I want to get the ids from cells in Link Sheet. However, I always get Exception: Unexpected error while getting the method or property getFileById on object DriveApp for line 25 (var newdoc = DriveApp.getFileById(templateId).makeCopy();)

How can I fix this? Thank you in advance

function CreateReport(){
var rawdata = Sheets.Spreadsheets.Values.get('LinkofSpreadsheet','Input!A2:Z');
var linkdata = Sheets.Spreadsheets.Values.get('LinkofSpreadsheet','Link!B1:B3');
const ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
const docid = ss.getRange("Link!B2").getValue();
const pdfid = ss.getRange("Link!B3").getValue();
const tempId = ss.getRange("Link!B1").getValue();
const folderdoc = DriveApp.getFolderById(docid);
const folderpdf = DriveApp.getFolderById(pdfid);
const templateId = DriveApp.getFileById(tempId);
for(var i = 0; i < rawdata.values.length; i++){
var check = rawdata.values[i][11];
if(check !== "Done"){
var Name = rawdata.values[i][0];
var var1 = rawdata.values[i][1];
var var2 = rawdata.values[i][2];
var var3 = rawdata.values[i][3];
var var4 = rawdata.values[i][4];
var var5 = rawdata.values[i][5];
var var6 = rawdata.values[i][6];
var var7 = rawdata.values[i][7];
var var8 = rawdata.values[i][8];
var var9 = rawdata.values[i][9];
var var10 = rawdata.values[i][10];
var newdoc = DriveApp.getFileById(templateId).makeCopy();
var documentId = newdoc.getId();
var doc = DocumentApp.openById(documentId);
DriveApp.getFileById(documentId).setName(Name);
var body = DocumentApp.openById(documentId).getBody();
body.replaceText('#1#', rawdata.values[i][1]);
body.replaceText('#2#', rawdata.values[i][2]);
body.replaceText('#3#', rawdata.values[i][3]);
body.replaceText('#4#', rawdata.values[i][4]);
body.replaceText('#5#', rawdata.values[i][5]);
body.replaceText('#6#', rawdata.values[i][6]);
body.replaceText('#7#', rawdata.values[i][7]);
body.replaceText('#8#', rawdata.values[i][8]);
body.replaceText('#9#', rawdata.values[i][9]);
body.replaceText('#10#', rawdata.values[i][10]);
folderdoc.addFile(DriveApp.getFileById(documentId));
doc.saveAndClose();
var docblob = doc.getBlob();
docblob.setName(doc.getName() + ".pdf");
folderpdf.createFile(docblob);
ss.getRange(i+2, 8).setValue("Done");
SpreadsheetApp.flush();
}

} }



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source