google script - send table by email with values from a loop

Question

I have a web app which take some inputs and I need to write those inputs in a sheet and then send an email with those inputs.

My code is below, I removed some lines in the code because they are not relevant. Assume pnArray and qArray are two arrays with values (strings and numbers).

The problem statement is how to create a HTML table in the loop below and then send that table by email.

function submitInfo() {
    
  var table = "<table><tbody><tr><td>Part Number</td><td>Packs</td></tr>";
  var pnArray = ["string1","string2"];
  var qArray = [1,2]; 
    
    for(var i =0;i<pnArray.length;i++){
    
    var pn = pnArray[i];
    var q = qArray[i];
      
    table += Utilities.formatString('<tr><td>%s</td>', pn);
    table += Utilities.formatString('<td>%s</td></tr>', q);
     
      
    }
    table+="</tbody></table>";
    GmailApp.sendEmail("[email protected]", "test", null, {htmlBody:table});
}

I need a minimal reproducible example with no undefined variables. — Cooper
– Cooper, Commented Jul 1, 2020 at 21:29

Cooper · Accepted Answer · 2020-07-01 22:24:27Z

1

function submitInfo() {
  var html = "<table><tr><td>Part Number</td><td>Packs</td></tr>";
  var pnArray = ["string1","string2"];
  var qArray = [1,2]; 
  pnArray.forEach(function(pn,i){html+=Utilities.formatString('<tr><td>%s</td><td>%s</td></tr>'pn,qArray[i]);});
    table+="</table>";
    GmailApp.sendEmail("[email protected]","test",null,{htmlBody:html});
}

edited Jul 1, 2020 at 22:24

answered Jul 1, 2020 at 21:54

Cooper

64.2k7 gold badges29 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Filippo Over a year ago

Thank you for your answer, I kept my loop format as I am having other code in my script, it does send the email, but the format of the table is off. Even with your code, there are no borders. How can I change the style?

Cooper Over a year ago

try using an inline style attribute in the th and td

Filippo Over a year ago

not sure how.. I added <table style="border-color: #d8d3db;"> but still no showing the border. I used similar syntax to center the text and it works. So the issue seems only for the borders?

Cooper Over a year ago

I don't really send any html email. But my guess is may style='border: 1px solid #d8d3db'

Collectives™ on Stack Overflow

google script - send table by email with values from a loop

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related