What's the process to continually have this updated on a scheduled basis? Say I want to update the values each month or week and have them reflected on the google slide. How do I do this?
Do you know how I can discover the names of objects to use in extension scripts? I want to do the reverse process: Use an already existing slide and update its data through the spreadsheet. For this, I will use a script that I have, but I can't find the names of the objects.
function fillTemplate() { var presentationId = "1ruevk26xw0soIf51Samgw1sSimxz8-knPhiOLMxdEFQ"; var presentation = SlidesApp.openById(presentationId); var values = SpreadsheetApp.getActive().getDataRange().getValues(); values.forEach(function(row){ var templateVariable = row[0]; var templateValue = row[1]; presentation.replaceAllText(templateVariable, templateValue); }); } no errors
function fillTemplate() { var presentationId = "1ruevk26xw0soIf51Samgw1sSimxz8-knPhiOLMxdEFQ"; var presentation = SlidesApp.openById(presentationId); var values = SpreadsheetApp.getActive().getDataRange().getValues(); values.forEach(function(row){ var templateVariable = row[0]; var templateValue = row[1]; presentation.replaceAllText(templateVariable, templateValue); }); }
