Dynamic Google Sheets Charts

In this article we will show you how to add Google Sheets Charts to Google Slides that update each automation

Did you know that you can now insert Google Sheets Charts to Google Slides that update when the automation is run in just a few simple steps? Take a look! 😀

Note - This feature is only available in Google Slides. It request it to be added to Google Docs please +1 this Google Issue ticket

In this article you will learn how to:

1. Add Google Sheets Charts to Google Slides

2. How Google Sheets Charts in Google Slides work during an automation

How to add Google Sheets Charts to Google Docs and Google Slides

In this article, we will jump straight to adding a Google Sheets chart to a Google Docs and a Google Slides template. However, if this is your first time creating a workflow, please refer to this article to learn more.

The first step is to copy the chart from your Google Sheets Source:

Next, insert it into your template document by selecting the "Link to spreadsheet" option:

Note | If you select the 'Paste unlinked' option, your chart will be inserted into your template as a static snapshot, preventing updates from being reflected within it.

And then your template will look like this:

How Google Sheets Charts in Google Slides work during an automation

When an automation is run Portant will make sure all the charts are updated so they contain the most recent data. It’s a bit like clicking this update button before running an automation (apart from Portant does it automatically)

Then your outputs will contain the most recent and up to date charts.

Feedback and feature suggestions

We created Portant in 2021 and the feedback we have received since then has been very helpful and greatly appreciated. If you have any feedback please feel free to send us an email at [e-mail]

Thanks,

Blake and James

‍