Hello everyone,
I’m facing a persistent issue where my automation is generating a PDF that shows the raw HTML code as plain text instead of rendering it as a formatted document.
I have already followed the standard troubleshooting steps, but the problem remains:
-
I am using a Google Doc as the template file.
-
I have pasted the HTML structure directly into the Google Doc.
-
My “Create a new file” task is correctly pointing to this Google Doc template and is set to output a PDF.
-
I have also tried explicitly setting the HTTP Content Type to text/html, but it did not solve the issue.
No matter what I try, the result is always a PDF showing the raw tags (<table>, <h1>, etc.).
Here is the HTML/AppSheet code from my Google Doc template:
HTML
<h1>Reporte de Mes: <<TEXT([Mes y Año], "MMMM YYYY")>></h1>
<hr>
<h3>Resumen de Ingresos</h3>
<table border="1" style="width:100%; border-collapse: collapse;">
<thead>
<tr style="background-color:#f2f2f2;">
<th style="padding: 8px; text-align: left;">Concepto</th>
<th style="padding: 8px; text-align: right;">Monto</th>
</tr>
</thead>
<tbody>
<<Start: FILTER("REPORTES MENSUALES", AND([ID del Cierre] = [_THISROW].[ID Cierre], [Tipo] = "Ingreso"))>>
<tr>
<td style="padding: 8px;"><<[Concepto]>></td>
<td style="padding: 8px; text-align: right;"><<[Total por Concepto]>></td>
</tr>
<<End>>
</tbody>
<tfoot>
<tr style="font-weight: bold; background-color:#e6e6e6;">
<td style="padding: 8px; text-align: right;">Total Ingresos:</td>
<td style="padding: 8px; text-align: right;">
<<SUM(SELECT(REPORTES MENSUALES[Total por Concepto], AND([ID del Cierre] = [_THISROW].[ID Cierre], [Tipo] = "Ingreso")))>>
</td>
</tr>
</tfoot>
</table>
Here is a screenshot of my ‘Create a new file’ task configuration: (Please make sure the screenshot shows the Template path, Output Type, and the HTTP Content Type fields)
And here is the resulting PDF file:
This seems like very unusual behavior. Could anyone see what might be wrong with my setup or suggest what else I could check?
Thank you so much for your help!