How add an inline chart pulled from a spreadsheet

Question

Goal: take an existing chart from a Google Spreadsheet, add inline to an email and send. I believe the GetChart class may help, but cannot figure out how.

Answer 1

You can get chart as image and embed it to message

Simple example

function sendChart(){
  var dataTable = SpreadsheetApp.getActiveSpreadsheet()
                                .getDataRange()
                                .getDataTable(true);

  var chartImage = Charts.newPieChart()
                    .setTitle('Title')
                    .setDataTable(dataTable)
                    .build()
                    .getAs('image/jpeg'); //get chart as image

  MailApp.sendEmail({
    to: "[e-mail]",
    subject: "Chart",
    htmlBody: "Chart! <br> <img src='cid:chartImg'> ! <br> Wow",
    inlineImages: {
        chartImg: chartImage,
    }
  });
}

I hope it helps =)