Function transferCharts

EndtoEndAutomatedDecks.js:179–245

()

function transferCharts() {
  // Open the Google Slides deck where you want to transfer the charts
  var slidesDeck = SlidesApp.openById("1zS2VBQwungFdf-pktG1qdNiHzmeXPlgTO18CKe903bU");

  // Open the 'Output' sheet from the active Google Sheet
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Output');

  // Get the first slide
  var slide = slidesDeck.getSlides()[0];

  // Clear existing images and text boxes on the slide except the header icon
  var elements = slide.getPageElements();
  elements.forEach(function(element) {
    var topPosition = element.getTop();

    if (element.getPageElementType() === SlidesApp.PageElementType.IMAGE) {
      // Remove images that are below the header (assuming header is within top 150 pixels)
      if (topPosition > 99) {
        element.remove();
      }
    } else if (element.getPageElementType() === SlidesApp.PageElementType.SHAPE) {
      // Remove text boxes that are below the header
      if (topPosition > 99) {
        element.remove();
      }
    }
  });

  // Get the chart from the sheet and insert it into the slide
  var charts = sheet.getCharts();
  if (charts.length > 0) {
    var chart = charts[0]; // Get the first chart (assuming it's the only one)

    // Get the chart as a blob image
    var image = chart.getAs('image/png');

    // Insert the image into the slide
    slide.insertImage(image).setLeft(30)
         .setTop(100)
         .setWidth(400)
         .setHeight(250);;
  } else {
    Logger.log('No charts found on the sheet.');
  }

  // Get the narrative from cell J3
  var narrative = sheet.getRange('J3').getValue();

  // Insert the narrative into the slide as a text box
  if (narrative) {
    var textBox = slide.insertTextBox(narrative);
    // Adjust the position and size of the text box as needed
    textBox.setLeft(450);
    textBox.setTop(140);
    textBox.setWidth(200);
    textBox.setHeight(150);

    // Optional: Set text style