Send Multiple Charts With Email

   How to Automatically Send Multiple Charts/Graphs on Gmail with Google Sheets?

Click Here For Video Explanation

function sendCharts() {

  var spSheet = SpreadsheetApp.getActiveSpreadsheet();

  var chartSheet = spSheet.getSheetByName("Data");

  var bodyEmail = "Hi All, <br> Please find the latest sales report. <br> "

  

  var charts = chartSheet.getCharts();

  var emailCharts = {};

  var bodyChart = "";

  var temp = charts.length

    for(var chartNo=0;chartNo <=temp-1;chartNo++){

        var img = charts[chartNo].getAs("image/png");

        emailCharts["chart" + (chartNo+1)]=img

        bodyChart = bodyChart + "<br><p align='center'><img src='cid:chart" + (chartNo+1)+"'></p>"; 

    }

    bodyEmail = bodyEmail + bodyChart;

    GmailApp.sendEmail("gosdet21@gmail.com", "Latest Report","", {htmlBody:bodyEmail,inlineImages:emailCharts})

    

}