I am looking for someone to automate the creation and saving of our monthly reports. The reports are built in Google Sheets and will update each month automatically. For the Google Script, I would like it to handle the following:
1) Create a Main PDF once with a dedicated URL that would never change (it would always have the most current report in it). This could be a one-time script.
2) Each time the script is run,
-make a copy of the Main PDF and save it as month-year-report.pdf
-save the tab on the workbook titled "final" over the Main PDF.
December 11, 2017
I am looking for a mix of experience and value