How to insert chart from Google Sheets into Google Slides?

Question

Hey guys!I am trying to find a way to automatically create/add a chart on google slides from a newly updated google sheet. Below is my zap flow :Step 1 : CRM Hook - Trigger : When a new prospect comes in	Step 2 : Create a new spreadsheet from template	Step 3 : Update spreadsheet row with content from CRM	Step 4 : Create presentation (google slide) from templateI am trying to add the chart from the spreadsheet onto the slide. I can’t seem to find an option to do so? Anyone help please? *If I can insert a chart on a slide and be able to change the source of this chart via zapier so it will reflect updated numbers, that could also work.

SamB · Accepted Answer

Just wanted to followup to confirm that should be possibleto pull in a chart created in a Google Sheet with the Google Slides integration. We have a help guide on how to setup templates for Google Slides here:How to Use the "Set up Google Slides Presentation" ActionIf you’re also wanting to update an existing chart when values are changed on the associated Google Sheet, then you’ll want to use a Google SlidesRefresh Charts action. This will get the updated values fromGoogle Sheets and update those on the Google Slide. Hope this helps! :)

Danvers · Answer

Hmm, that’s an interesting question @Limbic :thinking:

The Create Slide from Template action can replace placeholder information, so the question is whether you can set the source of the chart as a placeholder. I’m not sure that’s possible, but I think that’s how you would do it.

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded