Issue with PDF Generation from Bots in AppSheet

Hello everyone,

We would like to report an issue we are currently experiencing across multiple applications built in AppSheet.

We have several Bots configured to generate PDF reports using Google Docs templates. These PDFs are supposed to be sent automatically via email as attachments.

However, we have identified the following:

  • :cross_mark: Emails are not being sent because the PDF report generation is failing.

  • :bar_chart: The Bot audit log shows successful execution, but the process fails at the moment of generating the PDF file.

  • :repeat_button: This issue is occurring across multiple applications, not just a single case.

  • :busts_in_silhouette: Several of our clients have also reported the same problem.

Additional validation:

  • :white_check_mark: Reports generated as Google Sheets (Excel) are being sent successfully.

  • :cross_mark: The issue appears to be specifically related to the attachment template (Google Docs → PDF generation).

This issue is directly affecting our clients’ operations, as they rely on these PDF reports for their daily processes.

Is anyone else experiencing this issue recently?
Any insights or confirmations would be greatly appreciated.

Hello @sricse,

Thanks for bringing this to our attention, are you getting any error message?

We have recently seen a case where users were getting an API error: 429 which is caused by Apps Script’s 100 MB limit (not related to AppSheet). If you need help to address bandwidth usage limits with Apps Script please contact Apps Script Support.

Let me know please, thanks!

Thank you for your response.

Regarding your questions:

  • We are not receiving any error messages. From our side, everything appears to be working correctly, and the Bot execution is marked as successful in the Automation Monitor.

  • However, the emails are not being sent because the PDF attachment is not being generated.

Additionally:

  • Yes, we have already reported this issue to the support team.

  • :ticket: Ticket number: 3-0096000041488

At the moment, the behavior is:

  • The process completes without errors in the logs

  • But the PDF file is not created, and therefore the email is not delivered

Please let us know if you need any additional details such as App IDs, Bot names, or execution timestamps.

Got it, let me research and I will get back to you.

@sricse, the latest update is that the case has been further escalated for deeper investigation and the support team is actively working on it for its resolution.

Hello @sricse,

The support tram is requesting your help to provide the time frame when you have faced this problem?

Thanks!

Hi @sricse

Hi, have you checked the headers (columns) in the reference table that is converted into a PDF file with the columns in the Google Doc template? Make sure there are no differences to prevent the generation from failing.

However, if there are no errors, the PDF format fails because the data taken from the data source has not been entered into the table, so the PDF format fails. What I usually do is create it twice or in two steps. For example, I place an order. After the order is completed, I make the payment, and this is where the PDF formatting process is visible. Because the data from the order has been entered into the table, the PDF formatting failure caused by data that has not been entered into the table is resolved.

Like this

Hello @sricse,

Just wondering if you were able to determine the time frame requested here.

Thanks in advance!