Google app script to send email with same format as my table

Question

Im currently using this script to send emails from my sheets

My problem is that im not getting the emails with the same format as my table

Any way to send email with the exact format as I have on the sheet ?

Thanks !

This is the code

function Reminder() {
  var ss = SpreadsheetApp.getActive();
  var sheet = ss.getSheetByName("Sheet1");
  var range = sheet.getRange(1,1,sheet.getLastRow(),sheet.getLastColumn()-1);
  var valueToCheck = sheet.getRange("F1").getValue();

 // Optional init, to ensure the spreadsheet config overrides the script's
  var conv = SheetConverter.init(ss.getSpreadsheetTimeZone(),ss.getSpreadsheetLocale());

  // Grab an array for formatted content
  var array = conv.convertRange(range);
  Logger.log(JSON.stringify(array));

  // Get a html table version, with all formatting
  var html = conv.convertRange2html(range);
  Logger.log(html);

//Enter your condition below
  if(valueToCheck != 'OK'){
    MailApp.sendEmail("test@gmail.com", 'Reminder','' ,
    {name: 'Sen',htmlBody: 
    "Message " + "</br></br>" +
    html + "</br></br>" +
     })

}
}

The Sheet converter is a library for the script that should work https://sites.google.com/site/scriptsexamples/custom-methods/sheetconverter

What is the format of your table? – Rubén Feb 09 '21 at 00:57 — Rubén, Feb 09 '21 at 00:57

score 0 · Answer 1 · answered Mar 24 '19 at 15:20

0

This: if(valueToCheck = 'OK'){ should be this: if(valueToCheck == 'OK'){

answered Mar 24 '19 at 15:20

Cooper

59,616
6
23
54

Hi, yes, typo mistake, actually is != – SATH59 Mar 25 '19 at 02:42
1

What does this `conv.convertRange2html(range)` do? – Cooper Mar 25 '19 at 03:16
The Sheet converter is a library for the script that should work https://sites.google.com/site/scriptsexamples/custom-methods/sheetconverter – SATH59 Mar 25 '19 at 04:07
Hi, any help on thus plssss – SATH59 Mar 26 '19 at 05:14
I think your either using the SheetConverter incorrectly or it doesn't work. – Cooper Mar 26 '19 at 05:53

Rubén · Answer 2 · 2021-02-09T01:22:25.177

Not all the Google Sheets formatting features, i.e. cell borders, can be read by using the Spreadsheet Service from Google Apps Script. You might try to use the Sheets Converter as a starting point and complement it with Google Sheets Advanced Service.

If you use the Sheets Converter library you might have to change the default formatting settings to make it to be able to reproduce the formatting of your table. Among other things you might have to extend this library to support cell rich text formatting.

From https://github.com/mogsdad/SheetConverter/

This script is incomplete, ignoring some types of formatting. (Feel free to fork and enhance it, if you wish! Broadly applicable enhancements can be merged and the library updated) There are also some known issues:

(please read the details on the source)

It's worthy to note that the code was updated 25 days ago (Jan 14, 2021)

Google app script to send email with same format as my table

2 Answers2