Using Google Drive & Slide API as report template engine
July 4, 2023
At my current job, we are using Google Cloud Platform, which is awesome since it opens up so many services that exist in the Google ecosystem.
The other week a need arose to create reports based on data, from a template. We were wondering for a while and then decided that Google Slides could be up for the job. It was. But there were quite a lot of small hoops to jump around in, especially considering that there were so many different versions, languages, and ways to do things.
Here’s my plan:
- Create a Google Slide Template that will serve as the report original. This will contain some placeholder strings that we will replace with data from the report
- Create a folder for the report we are generating, and make a copy of the report original to this folder.
- Uploading a few pictures to this folder, and ensure that...