Copy Google Docs and fill in data from a Google Sheet using GAS.
Budget: $30 – $250 USD
I have an existing setup on Google drive where I can pull google docs by ID from a library using a google sheets by ID, completing data from the sheet into the doc and saving it with a new name,
I need to add some further automation.
I have a worksheet which can already pull a doc by its ID and save it to a local google drive folder (local to the google sheet ID).
I have added a library of google docs and I want to be able to add the sheet ID and select using the tick boxes which documents to pull from the library, use the existing script to fill on the doc(s) using data from the sheet, and save it to the folder local to the entered sheet ID.
Then clear all the tick boxes on the sheet.
For more detail and screenshots explaining what I need done, please see the attached PDF
I need to add some further automation.
I have a worksheet which can already pull a doc by its ID and save it to a local google drive folder (local to the google sheet ID).
I have added a library of google docs and I want to be able to add the sheet ID and select using the tick boxes which documents to pull from the library, use the existing script to fill on the doc(s) using data from the sheet, and save it to the folder local to the entered sheet ID.
Then clear all the tick boxes on the sheet.
For more detail and screenshots explaining what I need done, please see the attached PDF