Google App Script for Google Sheets

Please read before bidding: I work at a small school. I need someone to write a small app script for me. Details are as follows: 1. Pick up data from google sheets (such as student name, marks or other entries) 2. Populate these entries in a document template and make a customized document (pdf) for each student 3. Email the document by selecting the email address from one of the columns in the same row Basically it is like a mail merge wherein a template is made with place holders and then these placeholders are filled with information picked up from the google sheet and then customized document (in pdf) is mailed (mail accounts are picked from a column in the same row)