Integrate Looker Studio with Powerpoint

In this tutorial, I'll show you how to pull visuals from Looker Studio into a PowerPoint deck using Slideform's Looker Studio integration. We'll also go over the new features released this week to embed individual charts from Looker Studio into slide decks and reports. Let's explore! 

Prefer to watch the video tutorial?

Why Embed Looker Studio Charts into PowerPoint?

Looker Studio is an affordable and easy-to-use dashboard solution. However, the challenge arises when you need to present these charts in a slide deck, document or report. Traditional methods such as screenshots and manual copying can be time-consuming and inefficient. That's where Slideform comes in. Slideform bridges the gap between where your data lives and where you report on it. Slideform automatically pulls the latest data into your customized PowerPoint decks, Google Slides, documents, and reports for you. This is especially useful for reports that you create on a recurring basis each month or week, or if you create the same report for many different clients. Let's see how we can use Slideform to automate some of these common reporting tasks.

Step 1: Use Your Own Custom PowerPoint Slide Template

The first step towards automating your report is to make a custom template for the slide deck in PowerPoint. It is useful to use a previous report as a guide. The slide's look & feel should align with your company's branding, colors, and presentation style. Use any colors, fonts, and images you want. All the styling will be carried through to the final output.

Next, insert placeholders for the Looker Studio charts you wish to include. Use a PowerPoint shape (rectangle, square, or even circle) to indicate the placement and size of the chart. Then click into the shape and insert text enclosed in curly braces to identify the placeholder. These placeholders serve as dynamic containers that automatically update with the latest data, ensuring your presentations are always up-to-date.

For this tutorial, I'll create a PowerPoint presentation with Website Analytics from my Looker Studio dashboard. Here's one slide from my PowerPoint template. My slide includes placeholders for two charts, a logo, page number, plus notes and comments about the charts. For example, {{chart:impressions_by_device}} is a placeholder for a specific chart from my dashboard.

Once you've saved your slide deck template as a PowerPoint file, click New Project in Slideform and upload it.

Step 2: Connect Looker Studio to Slideform

Next, we need to connect your Looker Studio dashboard to Slideform. Slideform just released a ⭐ new feature that makes it easier than ever to pull individual charts into your presentations using the "Schedule Delivery" functions in Looker Studio. 

Two methods to link Looker Studio to Slideform:

1. Embed report: Use the iframe embed code to pull a specific page from your Looker Studio dashboard into a presentation. 

2. ⭐ Schedule Delivery: Use the Share button to send your dashboard content to Slideform each day.

With both of these methods, you can embed entire dashboard pages or individual charts into your slides. 

Today I'm going to try out the new Schedule Delivery feature. Here is my Looker Studio dashboard. I click the dropdown menu next to the Share button and select Schedule delivery. I set the report to be emailed to share@slideform.co each day.

Then, in Slideform, navigate to "Add Data Source," and establish a secure connection with the Looker Studio dashboard. 

Step 3: Match Each Chart to Your PowerPoint Template

With Looker Studio connected, it's time to map your charts and visuals to your PowerPoint slide template. In Slideform, click Configure Data, and match each placeholder in your template to the corresponding Looker Studio chart. Use the preview button to take a look at the chart. This ensures that the correct chart goes into each place, maintaining the structure and aesthetics of your presentation.

For my example, I have mapped each placeholder to the appropriate chart from Looker Studio. Here's an example for the first chart:

Step 5: Generate and Save Your PowerPoint Presentation

The magic happens when you click "Generate" in Slideform. Witness the latest Looker charts seamlessly populating into your PowerPoint slides. You can preview the presentation to confirm before you save the output as either PowerPoint, Google Slides, or PDF.

And here's the output for the Website Performance slide!

Advantages of Embedding Looker Studio Charts with Slideform:

1. Efficiency: Say farewell to time-consuming screenshots and manual copying.
2. Dynamic Updates: Charts automatically update each time you generate the slides.
3. Customization: Tailor your presentations with branded templates and dynamic charts.
4. Advanced Functionality: Combine data, images, and charts from multiple data sources in a single report.
5. Format Flexibility: Generate output in PowerPoint, Google Slides, Google Docs, Word, or even PDF.

Gain Efficiency Today with Slideform

Slideform emerges as the go-to solution for seamlessly connecting Looker Studio charts to your PowerPoint presentations. Experience a reporting workflow that is not only efficient but also visually compelling. Elevate your presentations, captivate your audience, and let your Looker Studio charts tell a compelling story.

Ready to streamline the way you present Looker Studio charts? Try Slideform for free today!