Google Slides: Page, Refresh Charts<\/div>
Refreshes all embedded Google Sheets charts in the specified slide by replacing them with the latest version of the chart from Google Sheets. For example, you can build a system to automatically update the “sales summary” aggregated in Google Sheets.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- U: Select HTTP_Authz Setting *<\/span><\/li>\n
- <\/i><\/span> A: Set FILE-ID in Drive *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B: Set Object-ID of Slide Page (Chars following “id.”)#{EL}<\/sup><\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strAuthzSetting = configs.get ( "AuthzConfU" ); \/\/\/ REQUIRED\n engine.log( " AutomatedTask Config: Authz Setting: " + strAuthzSetting );\nconst strInputfileId = configs.get ( "StrConfA1" ); \/\/\/ REQUIRED\n if( strInputfileId === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A1: FileID} is empty \\n" );\n }\nlet strPageidOriginal = configs.get ( "StrConfB1" ); \/\/ NotRequired\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\n\/\/\/ Get LastPage ID\n\/\/\/ Google Slides API\n\/\/\/ https:\/\/developers.google.com\/slides\/reference\/rest\/v1\/presentations\/get\n\nif( strPageidOriginal === "" ){\n \/\/ request0, prepare\n let request0Uri = "https:\/\/slides.googleapis.com\/v1\/presentations\/" + strInputfileId;\n let request0 = httpClient.begin(); \/\/ HttpRequestWrapper\n request0 = request0.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n \/\/ request0, try\n const response0 = request0.get( request0Uri ); \/\/ HttpResponseWrapper\n engine.log( " AutomatedTask ApiRequest0 Start: " + request0Uri );\n const response0Code = response0.getStatusCode() + "";\n const response0Body = response0.getResponseAsString() + "";\n engine.log( " AutomatedTask ApiResponse Status: " + response0Code );\n if( response0Code !== "200"){\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n response0Code + "\\n" + response0Body + "\\n" );\n }\n \/\/ response0, parse\n const response0Obj = JSON.parse( response0Body );\n strPageidOriginal = response0Obj.slides[ response0Obj.slides.length - 1 ].objectId;\n}\n\n\/\/\/ Get IDs of Charts\n\/\/\/ Google Slides API\n\/\/\/ https:\/\/developers.google.com\/slides\/reference\/rest\/v1\/presentations.pages\/get\nlet request1Uri = "https:\/\/slides.googleapis.com\/v1\/presentations\/" +\n strInputfileId + "\/pages\/" + strPageidOriginal;\nlet request1 = httpClient.begin(); \/\/ HttpRequestWrapper\n request1 = request1.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n\/\/ request1, try\nconst response1 = request1.get( request1Uri ); \/\/ HttpResponseWrapper\nengine.log( " AutomatedTask ApiRequest1 Start: " + request1Uri );\nconst response1Code = response1.getStatusCode() + "";\nconst response1Body = response1.getResponseAsString() + "";\nengine.log( " AutomatedTask ApiResponse Status: " + response1Code );\nif( response1Code !== "200"){\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n response1Code + "\\n" + response1Body + "\\n" );\n}\n\/\/ response1, parse\n\/* \nengine.log( response1Body ); \/\/ debug\n{\n "objectId": "SLIDES_API66619114_0",\n "pageElements": [\n {\n "objectId": "SLIDES_API66619114_1",\n "size": { ## },\n "transform": { ## },\n "title": "Revenue",\n "sheetsChart": { ## }\n },\n {\n "objectId": "SLIDES_API66619114_2",\n "size": { ## },\n "transform": { ## },\n "sheetsChart": { ## }\n },\n {\n "objectId": "SLIDES_API66619114_3",\n "size": { ## },\n "transform": { ## },\n "image": { ## }\n },\n {\n "objectId": "SLIDES_API66619114_4",\n "size": { ## },\n "shape": { ## }\n }\n ],\n "slideProperties": { ## },\n "revisionId": "opJuZBJWPCFPRw",\n "pageProperties": { ## }\n}\n*\/\nconst response1Obj = JSON.parse( response1Body );\nlet arrChartids = [];\nfor( let i = 0; i < response1Obj.pageElements.length; i++ ){\n if( response1Obj.pageElements[i].hasOwnProperty('sheetsChart') ){\n arrChartids.push( response1Obj.pageElements[i].objectId );\n engine.log( " AutomatedTask Founded Chart: ObjectID " + \n response1Obj.pageElements[i].objectId );\n }\n}\nif ( arrChartids.length === 0 ) {\n throw new Error( "\\n AutomatedTask UnexpectedError:" + \n " Sheets Chart not found \\n" );\n}\n\n\/\/\/ Refresh all Charts (via batchUpdate Request)\n\/\/\/ Google Slides API\n\/\/\/ https:\/\/developers.google.com\/slides\/reference\/rest\/v1\/presentations\/request#refreshsheetschartrequest\n\/\/ request2, prepare\nlet request2Uri = "https:\/\/slides.googleapis.com\/v1\/presentations\/" +\n strInputfileId + ":batchUpdate";\nlet request2Obj = {};\n request2Obj.requests = [];\n for( let i = 0; i < arrChartids.length; i++ ){\n request2Obj.requests[i] = {};\n request2Obj.requests[i].refreshSheetsChart = {};\n request2Obj.requests[i].refreshSheetsChart.objectId = arrChartids[i];\n }\nlet request2 = httpClient.begin(); \/\/ HttpRequestWrapper\n request2 = request2.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n request2 = request2.body( JSON.stringify( request2Obj ), "application\/json" );\n\/\/ request2, try\nconst response2 = request2.post( request2Uri ); \/\/ HttpResponseWrapper\nengine.log( " AutomatedTask ApiRequest2 Start: " + request2Uri );\nconst response2Code = response2.getStatusCode() + "";\nconst response2Body = response2.getResponseAsString() + "";\nengine.log( " AutomatedTask ApiResponse Status: " + response2Code );\nif( response2Code !== "200"){\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n response2Code + "\\n" + response2Body + "\\n" );\n}\n\/\/ response2, parse\n\/* \n{\n "presentationId": "1MsdTWR_pN4FQTCCqUhC1F_JWWsagogISvPF9WqOmaq8",\n "replies": [\n {}\n ],\n "writeControl": {\n "requiredRevisionId": "bvHyj2SJ0wwg4A"\n }\n}\n*\/\n\/\/ (nothing)\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\n\/\/ (nothing)\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/*\nNotes:\n- All updates are executed for the Google Sheets charts in the specified page. GoogleSlidesRefresh\n - If no page is specified, all updates will be executed for the last page.\n - No errors or warnings are recorded even if each chart is already up to date.\n- For example, if you want to automate the notification of "Monthly Sales Report", define as follows:\n - The template page is automatically duplicated (Google Slides: Page, Duplicate)\n - The report text part is automatically replaced (Google Slides: Page, Replace Strings)\n - The embedded graph is automatically updated (Google Slides: Page, Refresh Charts)\n - The slide page is automatically converted to a PNG image (Google Slides: Page, Generate PNG)\n - The email with the PNG image attached will be sent automatically. (ThrowEmail Event)\n- Add reference permission for Google Spreadsheet to the Scope of HTTP Authen Setting. (See Appendix)\n - Only "presentations" will result in a "PERMISSION_DENIED" error.\n - Include one of the spreadsheets.readonly, spreadsheets, drive.readonly, drive, or drive.file scopes.\n - API communication: presentations.batchUpdate > refreshSheetsChart request\n - https:\/\/developers.google.com\/slides\/reference\/rest\/v1\/presentations\/batchUpdate#authorization-scopes\n\nNotes-ja:\n- \u6307\u5b9a\u30da\u30fc\u30b8\u5185\u306eGoogleSheets\u30b0\u30e9\u30d5\u306b\u5bfe\u3057\u3066\u3001\u5168\u66f4\u65b0\u306e\u51e6\u7406\u304c\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002 GoogleSlidesRefresh\n - \u3082\u3057\u30da\u30fc\u30b8\u6307\u5b9a\u304c\u306a\u3044\u5834\u5408\u306f\u3001\u6700\u7d42\u30da\u30fc\u30b8\u306b\u5bfe\u3057\u3066\u5168\u66f4\u65b0\u306e\u51e6\u7406\u304c\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002\n - \u65e2\u306b\u5404\u30b0\u30e9\u30d5\u304c\u6700\u65b0\u7248\u306e\u72b6\u614b\u306b\u306a\u3063\u3066\u3044\u308b\u5834\u5408\u3082\u3001\u30a8\u30e9\u30fc\u3084\u30ef\u30fc\u30cb\u30f3\u30b0\u306f\u8a18\u9332\u3055\u308c\u307e\u305b\u3093\u3002\n- \u305f\u3068\u3048\u3070\u300c\u6708\u6b21\u58f2\u4e0a\u30ec\u30dd\u30fc\u30c8\u300d\u306e\u901a\u77e5\u696d\u52d9\u3092\u81ea\u52d5\u5316\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u696d\u52d9\u30d7\u30ed\u30bb\u30b9\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002\n - \u96db\u5f62\u30da\u30fc\u30b8\u304c\u81ea\u52d5\u8907\u88fd\u3055\u308c\u3001\uff08\u203bGoogle \u30b9\u30e9\u30a4\u30c9: \u30da\u30fc\u30b8, \u8907\u88fd\uff09\n - \u8cbc\u308a\u4ed8\u3051\u3089\u308c\u3066\u3044\u308b\u57cb\u3081\u8fbc\u307f\u30b0\u30e9\u30d5\u304c\u81ea\u52d5\u66f4\u65b0\u3055\u308c\u3001\uff08\u203bGoogle \u30b9\u30e9\u30a4\u30c9: \u30da\u30fc\u30b8, \u6587\u5b57\u5217\u5168\u7f6e\u63db\uff09\n - \u5831\u544a\u30c6\u30ad\u30b9\u30c8\u90e8\u304c\u5f53\u6708\u6587\u306b\u81ea\u52d5\u7f6e\u63db\u3055\u308c\u3001\uff08\u203bGoogle \u30b9\u30e9\u30a4\u30c9: \u30da\u30fc\u30b8, \u5168\u30b0\u30e9\u30d5\u66f4\u65b0\uff09\n - \u5f53\u8a72\u30b9\u30e9\u30a4\u30c9\u30da\u30fc\u30b8\u304cPNG\u753b\u50cf\u306b\u81ea\u52d5\u5909\u63db\u3055\u308c\u3001\uff08\u203bGoogle \u30b9\u30e9\u30a4\u30c9: \u30da\u30fc\u30b8, PNG\u753b\u50cf\u751f\u6210\uff09\n - PNG\u753b\u50cf\u304c\u6dfb\u4ed8\u3055\u308c\u305f\u30e1\u30fc\u30eb\u304c\u81ea\u52d5\u7684\u306b\u9001\u4fe1\u3055\u308c\u308b\u3002\uff08\u203b ThrowEmail \u30a4\u30d9\u30f3\u30c8\uff09\n- HTTP\u8a8d\u8a3c\u8a2d\u5b9a\u306e\u8a8d\u53ef\u30b9\u30b3\u30fc\u30d7\u306b\u300cGoogle\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u53c2\u7167\u6a29\u9650\u300d\u3092\u8ffd\u52a0\u3057\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002(Appendix\u53c2\u7167)\n - "presentations" \u3060\u3051\u3067\u306f "PERMISSION_DENIED" \u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002\n - \u6b21\u306e\u3044\u305a\u308c\u304b\u3092\u52a0\u3048\u307e\u3059\u3002 spreadsheets.readonly, spreadsheets, drive.readonly, drive, drive.file\n - API\u901a\u4fe1\u306e\u5185\u5bb9\uff1a presentations.batchUpdate > refreshSheetsChart \u30ea\u30af\u30a8\u30b9\u30c8\n - https:\/\/developers.google.com\/slides\/reference\/rest\/v1\/presentations\/batchUpdate#authorization-scopes\n\nAPPENDIX-en\n- FILE-ID\/PresentationID in Drive (Chars following "\/d\/")\n - docs.google.com\/presentation\/d\/1p33hGJFUNYixBmMeaV81nsOVYGUUrZIFyErinFp3CI8\n- Object-ID of Slide Page (Chars following "id.")\n - docs.google.com\/presentation\/d\/1p33hGJFUNYixBmMeaV81nsOVYGUUrZIFyErinFp3CI8\/edit#slide=id.g613777c84a_0_0\n- Setting example of "HTTP Authentication" (OAuth2)\n - Authorization Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force\n - Token Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/token\n - Scope:\n - https:\/\/www.googleapis.com\/auth\/presentations https:\/\/www.googleapis.com\/auth\/spreadsheets.readonly\n - Client ID, Consumer Secret:\n - ( from https:\/\/console.developers.google.com\/ )\n - Redirect URLs: https:\/\/s.questetra.net\/oauth2callback\nAPPENDIX-ja\n- FILE-ID\/PresentationID in Drive ("\/d\/" \u4ee5\u964d\u306e\u6587\u5b57\u5217)\n - docs.google.com\/presentation\/d\/1p33hGJFUNYixBmMeaV81nsOVYGUUrZIFyErinFp3CI8\n- Object-ID of Slide Page ("id." \u4ee5\u964d\u306e\u6587\u5b57\u5217)\n - docs.google.com\/presentation\/d\/1p33hGJFUNYixBmMeaV81nsOVYGUUrZIFyErinFp3CI8\/edit#slide=id.g613777c84a_0_0\n- "HTTP\u8a8d\u8a3c"\uff08OAuth2\uff09\u306e\u8a2d\u5b9a\u4f8b\n - Authorization Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force\n - Token Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/token\n - Scope:\n - https:\/\/www.googleapis.com\/auth\/presentations https:\/\/www.googleapis.com\/auth\/spreadsheets.readonly\n - Client ID, Consumer Secret:\n - ( from https:\/\/console.developers.google.com\/ )\n - Redirect URLs: https:\/\/s.questetra.net\/oauth2callback\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- \n
- Google-Slides-Page-Refresh-Charts-2021.xml<\/a><\/li>\n\n\n\n
- Google-Slides-Page-Refresh-Charts-2023.xml<\/a>\n
- \n
- 2023-08-15 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- for “GraalJS standard (engine-type 3)” on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Google-Slides-Page-Refresh-Charts-2026.xml<\/a>\n
- \n
- 2026-04-27 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- Due to the deprecation of the methods
authSetting(String)<\/code> at v18.<\/li>\n\n\n\n- https:\/\/support.questetra.com\/ja\/versions\/version-180\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
2021-05-17 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/google-slides-page-refresh-charts-2021\/<\/a>
<\/i> The Addon-import feature is available with Professional<\/strong><\/span> edition.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- \n
- All updates are executed for the Google Sheets charts in the specified page. GoogleSlidesRefresh\n
- \n
- If no page is specified, all updates will be executed for the last page.<\/li>\n\n\n\n
- No errors or warnings are recorded even if each chart is already up to date.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- For example, if you want to automate the notification of “Monthly Sales Report”, define as follows:\n
- \n
- The template page is automatically duplicated (Google Slides: Page, Duplicate)<\/li>\n\n\n\n
- The report text part is automatically replaced (Google Slides: Page, Replace Strings)<\/li>\n\n\n\n
- The embedded graph is automatically updated (Google Slides: Page, Refresh Charts)<\/li>\n\n\n\n
- The slide page is automatically converted to a PNG image (Google Slides: Page, Generate PNG)<\/li>\n\n\n\n
- The email with the PNG image attached will be sent automatically. (ThrowEmail Event)<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Add reference permission for Google Spreadsheet to the Scope of HTTP Authen Setting. (See Appendix)\n
- \n
- Only “presentations” will result in a “PERMISSION_DENIED” error.<\/li>\n\n\n\n
- Include one of the spreadsheets.readonly, spreadsheets, drive.readonly, drive, or drive.file scopes.<\/li>\n\n\n\n
- API communication: presentations.batchUpdate > refreshSheetsChart request<\/li>\n\n\n\n
- https:\/\/developers.google.com\/slides\/reference\/rest\/v1\/presentations\/batchUpdate#authorization-scopes<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"Refreshes](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/google-slides-page-refresh-charts-2021-workflow-en.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n![\"Refreshes](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/google-slides-page-refresh-charts-2021-config-en.png?resize=1010%2C514&ssl=1\")
<\/a><\/figure>\n\n\n\n<\/i> Appendix<\/h3>\n\n\n\n
- \n
- FILE-ID\/PresentationID in Drive (Chars following “\/d\/”)\n
- \n
- docs.google.com\/presentation\/d\/1p33hGJFUNYixBmMeaV81nsOVYGUUrZIFyErinFp3CI8<\/strong><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Object-ID of Slide Page (Chars following “id.”)\n
- \n
- docs.google.com\/presentation\/d\/1p33hGJFUNYixBmMeaV81nsOVYGUUrZIFyErinFp3CI8\/edit#slide=id.g613777c84a_0_0<\/strong><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Setting example of “HTTP Authentication” (OAuth2)\n
- \n
- Authorization Endpoint URL:\n
- \n
- https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Token Endpoint URL:\n
- https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Setting example of “HTTP Authentication” (OAuth2)\n
- Object-ID of Slide Page (Chars following “id.”)\n
- docs.google.com\/presentation\/d\/1p33hGJFUNYixBmMeaV81nsOVYGUUrZIFyErinFp3CI8<\/strong><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- FILE-ID\/PresentationID in Drive (Chars following “\/d\/”)\n
- https:\/\/support.questetra.com\/ja\/versions\/version-180\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
- Google-Slides-Page-Refresh-Charts-2023.xml<\/a>\n
- <\/i><\/span> A: Set FILE-ID in Drive *<\/span>#{EL}<\/sup><\/span><\/li>\n