I am trying to pull rows from a Google Sheet and then input that info into an html formatted email. I am able to pull the rows from Google Sheets by using the Lookup Spreadsheet Rows (output as line items) and then format them using the Format Utility, Line-item to Text. Then I can input the Output/text line into the email. But when I send as a plain email the entries are on separate lines, however when I send as an html formatted email all the entries are on one line. Is there a way to have them all on separate lines in the html formatted email (which is what I need to use)?
This article got me most of the way there, but it looks like I am not the only one with this question.
Best answer by cpzapView original