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.
This content is subject to limited support.
hi, any updates on this topic?
thanks!
Hello,
Very interested in the Python solution mentioned. What APIs would be used/needed for this initial setup?
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.
@LucianaPadua @KarlR you should check out Rollstack. It allows you to connect Looker to Slides and automate the process of creating and updating slide decks and documents from Looker, Tableau, Metabase, etc.
For home-grown solutions, your best bet is still either DIY (Python etc) or using the Looker → Sheets → Slides method. I’m not sure how flexible that method is though when it comes to configuration and collaboration.
There are also some proprietary, 3rd party services cropping up. We are developing one such tool that incorporates both PPT and Google Slides. Users can upload highly customized templates and link key elements to charts, tables, etc from their preferred BI/external system. Check us out at slideform.co or just shoot me an email at james@slideform.co if you want to learn more.