Create a new file via BOT (PDF based on google doc template)

[Thibault]

Hello,

I am facing margin issues when generating a PDF from a Google Docs template.

My Google doc template looks like that:

My template is formatted correctly in Google Docs. When the content generated by my application results in a single-page document, everything looks fine (although for some reason the page number is not printed, but this is not critical):

However, when the document extends to 2 or more pages, the formatting no longer respects the defined margins and the footer is pushed onto the next page:

I have already tried several approaches with the support of Gemini, but nothing has resolved the issue so far.

I also tested generating a very simple Google Docs template without header or footer, but the same behavior occurs.

Has anyone experienced a similar issue or has any idea what could be causing this?

Thank you in advance for your help,

Thibault

[WillowMobileSys]

AppSheet’s PDF generation only supports the header on the FIRST page and a footer on the LAST page. Sadly, It will not provide a header and footer on each page.

If such formatting is important on your generated documents, there is one other approach to generating PDF’s that has been detailed by one of our other contributors @SkrOYC (Oscar). In the post below, I have provided links to the 3 articles he has written. There is a learning curve which I personally have not yet needed to pursue but my understading is that it is a MUCH MAUCH better way to create excellent PDF’s

Generating PDF with different tables for the event triger and the file data

Here are the links. There is a learning curve and as such I have yet to try it out. According to the original poster, Oscar, it is better way to produce the reports as you have more control. He seems to be a detailed oriented person so I believe him. It’s worth trying it out and assessing for yourself. Pixel Perfect reports…. Part 1 - Almost Pixel perfect pdf reports from automation Part 2 - Pixel perfect paginated reports Part 3: Pixel perfect reports with Skia (AppSheet’s PDF generator) …

I hope this helps!!

[Suvrutt_Gurjar]

Alternatively, if you are willing to use Google Apps Script, please take a look at the following tip.

Use GAS : Create reports having different background cell colors, headers, footers and page numbers

This tip is mainly extension of a few tips that make use of Google Apps Script(GAS) for various reporting options earlier shared and referred in the post below. Overview: The tip basically uses Google Apps Script to create the PDF report. The approach in tip demonstrates two main benefits listed below Show More Salient Point of implementation Show More Report Images GAS Based report We can see that the backgrounds of the table cells are colored as per status of that attribute. So also th…

[Thibault]

Thank you for your answers.
”AppSheet’s PDF generation only supports the header on the FIRST page and a footer on the LAST page. Sadly, It will not provide a header and footer on each page.”

This is exactly what I needed to understand.

And I found a way to correct the margin issue thanks to this article: Margin not honored in creating PDF from AppSheet

Since the Header/Footer are not that important to me, the solution found is satisfying.

Thanks again for the support.