Create Google Doc from template and pull data from a Google Sheet with Google App Script (GAS).

In this folder are the Google Doc templates and a Google spreadsheet called: Source Data - Populated. Create the Google App Script (GAS) code in the spreadsheet to complete the google doc templates in the same folder, which are called: CLAIM TO EXEMPT GOODS - Witness Statement Notice-of-Claim-To-Exempt-Goods-CPR85.8 Draft Order Here is a copy of the folder containing the documents: [login to view URL] The assignment: Create the GAS code in the spreadsheet, make copies of each of the three Google docs and save with a new file name. Prefix the new filename with the text in cell {C2} Then pull data from the Google spreadsheet by reference to cell numbers and insert them into the Google doc the position the cell number is shown in {curly brackets}. I will give the freelancer a non-public version of this folder. This folder is a public copy to allow freelancers to look over the source documents. Some paragraphs in the template are optional. If any value in the source Google spreadsheet document cell is empty or zero, then leave out that paragraph in the finished Google document. The paragraph numbers in the finished Google Document must still be in ascending order. The optional cells are {E10} to {E16}. if the value of any of these cells are empty, then the finished document must not have the paragraph containing references {E10} to {E16}. In all other cases, if the value in the cell is empty, then leave the Google Doc as it is with the cell number shown in {curly brackets} We must keep the formatting of the document, e.g. bold. Italics, etc.