0

I want to updated a liked SheetsChart for Google Slides. It works instantly when the slide is in edit mode, doesn't refresh the chart with latest data from Google Sheets when it's in "Slideshow" mode.

How can I refresh a Sheets Chart while in "Slideshow" mode?

Code

curl --request POST \
  'https://slides.googleapis.com/v1/presentations/[presentationId]:batchUpdate?key=[YOUR_API_KEY]' \
  --header 'Authorization: Bearer [YOUR_ACCESS_TOKEN]' \
  --header 'Accept: application/json' \
  --header 'Content-Type: application/json' \
  --data '{"requests":[{"refreshSheetsChart":{"objectId":"object Id that include a linked Sheets Chart"}}]}' \
  --compressed
Output
HTTP 200
{
  "presentationId": "presentationId",
  "replies": [
    {}
  ],
  "writeControl": {
    "requiredRevisionId": "<>"
  }
}

My use case is to update the Slide's SheetsChart in real-time with an external data source: When an external data source is updated -> use Google API to update Google Sheets and trigger to refresh linked SheetsChart in Slides.

When Slides in "edit" mode: it updates the linked chart instantly When Slides in "Slideshow" mode (or in presentation): it doesn't update the linked chart, exiting the "Slideshow" mode, the chart is updated. Is there an alternative way?

Improve this question
6
  • 5
    This is not an uncommon question. To the best of my knowledge, when a slideshow is running, the content is shown as an image and it isn’t possible to dynamically update a slideshow per se. One must update the actual Slides presentation file prior to running the Slideshow. Commented Mar 15 at 7:06
  • Try reading the first related question below Commented Mar 15 at 16:50
  • @Cooper the related question doesn't have the same issue Commented Mar 16 at 5:04
  • 2
    Yes but it boils down to running a script to update everything before starting the slideshow and it's probably the only way you are going to solve your issue. Commented Mar 16 at 13:39
  • Thanks, @Cooper. That doesn’t address the issue in the question: refreshing only works in ‘edit’ mode, not in ‘slideshow’ mode. Am I missing something? Commented Mar 18 at 8:11
Related questions
1
Google Apps Script refresh Sheets-Charts not working
4
Google slides auto update links /tables linked from google sheet
0
Linked Chart Populated by =NOW() Not Updating
Load 4 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.