Completed

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.

Skills: Google App Engine, JavaScript, Google Docs, Google Sheets

See more: create data sheet, fetch data excel sheet perl script, create excel template import data, excel create data sheet, create product data sheet illustrator, create populate word doc template file, create product data sheet, script download google finance data python, create data sheet web excel, create excel sheet ajax script, create word doc template asp, project data sheet template, template word data sheet, graphic design data sheet template designs, data sheet template, script breakdown sheet app, create powerpoint template excel data, data sheet template doc

About the Employer:
( 171 reviews ) Surrey, United Kingdom

Project ID: #30641520

Awarded to:

(14 Reviews)
5.4

2 freelancers are bidding on average $165 for this job

(21 Reviews)
4.6