Saving time, money and sanity by Pythonizing Google Slides

Friday, May 26

16:45 - 17:15
Audience levelBeginner
Elevator pitch

Unfortunately, there are people whose day-to-day job it is to create Slides from templates. Some of them are my friends and I could not stand them wasting so much time doing something that could be nicely automated. This talk will reveal the story of building a tool that can do just that!


Believe it or not, there are people whose job it is to regularly (like every day or every week) create Slides from pre-defined templates and manually edit the informations inside them. Some of them, sadly, are my fools (I mean colleagues), friends and family. They usually need to:

  1. duplicate the presentation
  2. find the placeholders
  3. fill them in
  4. update the charts
  5. replace old images
  6. and remember not to forget any of the previous steps.

And yet, it is not uncommon for them to realise they missed something just as they are presenting to an important client. I could not stand them wasting so much time doing something that is very error prone, time consuming and that could be easily automated, if only there was a tool for it.

This talk will cover the story of building that very tool, which includes:

  • A sport scientist transitioning into the tech world
  • A Jupyter notebook analysing his Tinder data
  • Eating blood pancakes in the middle of Sweden wilderness, followed by pulling a car out of snow at 1AM
  • The technicalities of getting Jinja2 templates into Google Slides
  • Making this solution available through an open-source PyPI package
  • Putting together a Streamlit frontend for people not comfortable with the command line
  • and much much more.

If all goes well, I will try to do a live demo showing how to use this open-source tool and share a few tips on how you can save time, money and sanity of your fools, friends and family as well!

TagsOpen-Source, Tooling, Case Study, Jupyter/iPython Notebook, PyPi
participant photo

Giulio Piccolo

Giulio Piccolo is a former competitive swimmer who recently transitioned to the world of data. He has a Sports Science degree and likes intellectual stimulating challenges. He works as Analytics Engineer at Slido (part of Cisco), an audience interaction company that provides world-class polling and Q&A. In his free time he likes to cook carbonara pasta and swipe right (making data informed decisions, that is). Recently he swiped right on Python which inspired him to come to talk at PyCon Italia.