This is a Google Apps Script library for easily managing the template of Google Documents and Google Slides using Google Spreadsheet as a database using Google Apps Script.
You might have situations where are required to create multiple Google Documents and Google Slides from the templates using Google Spreadsheet as a database with Google Apps Script. When the simple texts are replaced with the placeholders on the templates, this can be achieved by a simple script. However, there is the case that the images are required to be inserted into the templates. In this case, the script is complicated. The method for replacing the placeholders with the images is different between Google Documents and Google Slides. And, when I see questions on Stackoverflow, a lot of questions related to the template process using Google Documents and Google Slides can be seen. Furthermore, I personally have a lot of questions related to this from other users. From this situation, I thought that when managing the template process can be simply run, it will be useful for a lot of users. So, I created this library.
There are 2 useful features in this library.
- Text styles in the cells on the Spreadsheet can be reflected in the template.
- Images in the cells can be used.
In my experience, when the text styles of the cells were reflected in the template and the images in the cells can be used, it was useful. However, unfortunately, I have never seen them. So, I thought that if those are implemented, it might be useful for other users.
Library’s project key
You can see the detail information here https://github.com/tanaikech/TemplateApp.