# Dynamic Google Sheets Charts

Did you know you can now insert Google Sheets charts into Google Slides and have them update automatically whenever the automation runs? It’s quick and easy—check it out! 😃

> **Note** - This feature is only available in Google Slides. If you'd like to see it added to Google Docs, please upvote this Google Issue ticket: [Google Issue ticket](https://issuetracker.google.com/issues/297245048).

**In this article you will learn how to:**\
\
1\. Add Google Sheets Charts to Google Slides

2\. How Google Sheets Charts Update in Google Slides During Automation

#### **How to add Google Sheets Charts to Google Slides**

In this article, we will jump straight to adding a Google Sheets chart to a Google Slides template. However, if this is your first time creating a workflow, please refer to this [**article**](https://www.portant.co/guide-article/how-to-create-your-first-workflow) to learn more. 

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

<figure><img src="https://uploads-ssl.webflow.com/5f3b57b5405f8bd0f98b5e14/65394eac6ecbe8268348c47d_eOCeJqLIalVhtI25HckqhjRCYBTz1jn7qe5mAt3HwHrO4nYVI0DqaMQzQxxaHnup6RNmkWCPEPBvheNTDOw8fftZuOS_WGpRcs7sppZilWDO0k_FV5prlNssYA4WIOswGPdqzOAT9bKGJlSvM5Iqkwc.png" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="https://uploads-ssl.webflow.com/5f3b57b5405f8bd0f98b5e14/65394ead563288cd85092bdc_-4Xs_o6wsZ-YnuC5UuAGHG5gBobD1rkNyEHBJIiarxj8LqPi5MKyW2qj6e_qPBA1fMrIm7jAyiIao5EWTcLJI5R1hMW-_Bl-G5J-13Sy-5WWSKFDzGYsrdqu9VMsSG090B9Sd7Dcx1HhcrBzURF7I_U.png" alt=""><figcaption></figcaption></figure>

Now your template will now display the linked chart, ready to update automatically whenever the data in Google Sheets changes!

<figure><img src="https://uploads-ssl.webflow.com/5f3b57b5405f8bd0f98b5e14/65394ead6a770d1309a02d1c_1SsT-_QuBKh6kzQsZgYNVexOQd9x1FF05TLc6xAC4HLf7I1SEgVlz0aw09XHZ0wPPJnT6e3ZjYzaMJ8ECvKwnRsu4oRRHkGq7lJb7iuclEIZMwZW6L15sU6L0RKtPWc6Ql9UQynSuDvRHLXEB3q8BnI.png" alt=""><figcaption></figcaption></figure>

#### How Google Sheets Charts Update in Google Slides During Automation

When an automation runs, Portant ensures that all charts are updated with the latest data—just like clicking the update button manually, but done automatically for you. This way, your outputs will always include 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 <contact@portant.co>

Thanks,

Blake and James

‍


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.portant.co/portant-docs/personalise-documents/dynamic-google-sheets-charts.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.