Email Body Template - How do we execute the generated HTML?

AppSheet AppSheet Q&A
1

I have been using HTML Email Bodies for a while now but they have been very simplistic - just text and a few columns of data. Mostly for notification of app activity.

I have a use case now where I want to create a table of rows using START/END expressions.

I have found that I need to place the constructed HTML into a template for it to properly recognize the START/END portion. It does indeed generate the expected HTML but that is what is delievered in the Email Body - the raw HTML. See first image.

Trying to use the template for an Attachment produces the same raw HTML.

However, if I simply copy the HTML from the resulting email and insert that in the Email Body of a second Bot step and re-run the bot - then I get the properly formatted HTML table. See second image.

I would expect that the generated HTML from the template would also be executed to generate the HTML formatted table.

Am I missing something? Do I need to include something in the HTML, format it differently or am I missing some Bot Step setting?

************************************************************************

Using Email Body Template - Raw HTML is sent as the email body
(NOTE: Critical information was whited out - should just grey it to be more clear)

Screenshot 2026-05-06 at 4.15.31 PM
Screenshot 2026-05-06 at 4.15.31 PM1374×1340 72.5 KB

Copying raw HTML above into a second Bot step Produces this HTML Table
(NOTE: Critical information was whited out - should just grey it to be more clear)

Screenshot 2026-05-06 at 4.19.29 PM
Screenshot 2026-05-06 at 4.19.29 PM1576×720 46.8 KB

2

Yikes!

3

I just realized that some might think what I am showing is what was actually produced. I whited out all the client specific details. It’s more the overall result I am focusing on - raw HTML in one instance versus the actual HTML table in another.

So, I hope your “Yikes!” wasn’t wasted on the presented format of the presented data??

4

Directed at the problem, not the presentation. :slight_smile:

5

Try converting your template file to a plain-text .html file.

Alternatively, don’t produce an entire HTML document (no <HTML>, <HEAD>, <BODY>, etc.), just produce the specific HTML you need.

6

I did create a text file and then exported that into an html and uploaded that file - it generated a full blown out html file. That is what produced the “problem” noted above.

I had tried simply changing the extension from txt to html. When that file was uploaded and ran as a template, I got an “incorrect mime-type” message. But maybe having all the extra “stuff” was the issue?

I’ll try it again later today.