Automation - Google Script for End to End task (Sheet- doc -pdf)

1. Get data from multiple Google Spreadsheet and after processing on few tasks like compiling the records or apply some validation it creates a pdf (replacing some specific values in a doc file and save it as pdf).

2. Save the pdf to a specific Google Drive folder.

3. Paste the link of that file and the hyperlink to open file directly from the Master sheet.

4. Email the pdf to the specific recipients. Post automation, All these steps would not require any manual steps.

It run automatically using Time Trigger method and processed the task successfully.