Last tested: Sep 8, 2020
Looking for a solution to export a dashboard of visualizations to a Google Slide deck on their template. Below were the options I was able to outline. Spoiler alert: none are ideal.
- (1) Python Script
- Allows you to take a template slide deck and push viz images onto them
- Most complete, detailed solution
- Works with Google Slides
- Very automatic solution once complete - would scale well
- Requires significant dev time to create the solution
- Minor maintenance may be required to make changes over time
- (2) LiveSlides
- Embed live visualizations into MS PPT presentation
- Embed interactive visualizations into a PPT presentation
- Very easy to get set up
- Will update with live data with no work. No need to export images
- Only available in MS PowerPoint
- Cannot be exported to PDF
- (3) Use a webhook tool like Zapier
- Use a tool like Zapier to send a visualization from Looker and place it on slides
- Uses Google Slides
- Could potentially allow you to update slides directly from Looker
- Unproven method - haven't seen it implemented before
- May need to create specific endpoints in Zapier for every image, which would be time consuming.
One potential workaround is to send the data from your visualization to Google Sheets, using the new Looker Actions - Google Sheets integration. Maybe not ideal because you will need to use Google Sheets charts as your visualization, but live charts from Google Sheets can be directly embedded into Google Slides. Here’s what you’d need to do:
Like with some of the other options some initial work is needed, but once set up it can be fully automated.
Very interested in the Python solution mentioned. What APIs would be used/needed for this initial setup?
hi, any updates on this topic?