This question already has answers here: App Script Google Docs Replace Text in Body (1 answer) Replace Text with DocumentApp (1 answer) Issue with body.replaceText() in Google Docs (1 answer) Closed 1 hour ago. I am working on a form that takes values and puts them in a spreadsheet. I want to take the values […]

I’m new at GAS and I was following a tutorial on Youtube for knowing how it works on the diferent plataforms on Google Workspace. But, when I executed my code in a Google Sheets it prompted me this error: “TypeError: Cannot read properties of null (reading ‘getBody’)”.

I´ve given the task to create a script that creates a document file as a report based on a spreadsheet. Now I´ve tried several types of aproach but none of these aproaches created the document in question.

I have a doc that contains text like %A1%, %B3%, %A3%, and so on. I have a Google sheet. I want to replace the text in the Google doc from the Google sheet. The replacement is to be made like this:”%A1% will be replaced by the value in cell (1,1), i.e., the value in range”A1:A1″,”%C3% will be replaced by the value in cell (3,3), i.e., the value in range”C3:C3″ and so on. The following code is just for one cell. I want to loop through all cells in the sheet and make all replacements. Any help will be appreciated.