Insert Sheets Chart into Slides
Automatically put the Charts from Google Sheets into specified Google Slides at any step of your workflow
Fields
- Connection - Your selected Google Drive connection. Note that you have to select the connection where you have access to view, edit, create, and delete files.
Source Sheet Data
- Spreadsheet File Id - The Google Sheet File from which you want to take the Chart. You can pick the file from your Google Drive folders by clicking on the Drive icon or using a Token Picker.
- Sheet Name - You can pick the needed Sheet from the drop-down that appears when you click the Google Sheets icon or use a Token Picker.
- Chart title - it is displayed on top of your Chart
Target Presentation
- Source Slide File Id -The Google Slides file where you want to insert the Chart. You can pick the file from your Google Drive folders by clicking on the Drive icon or using a Token Picker.
Select Based On Slide Numbers or Slide ID
- Slide ID/Number - to find a Slide ID, open the slide and copy everything that is indicated after id.{{SlideID}} in the Slide URL. For example, gc6f9e470d_0_0.
Slide numbers are located on the left sidebar.
Please note that if you are using an slide that is generated based on a template that is used in your workflow, you cannot specify the id of the created slide, so it is best to use slide number for selecting the slides.
- Chart placeholder name - to indicate the specific place on the Slide where you want to put the Chart, create a shape, right-click on it and find the Alt Text option. Please note that you have to create a shape, and cannot use and image instead.
Then, specify the placeholder in the Title, under Advanced options(not the description!):
Put the same title inside the Zenphi field:
Result
Upon executing this Flow, the "User types" chart was inserted from Google Sheets to Google Slide. the charts inserted in the Slides file are (by default) linked to the original charts in the Sheets file, so when the data is updated in the sheets file you can click on the update symbol for the chart.
Updated 9 months ago