Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Automation Bot Fails to Process <<Start>> Expression in PDF Template

Hello, I have an Automation Bot that is triggered by new rows in my 'Reportes' table. The bot has a step to create a PDF from a Google Docs template.

The bot runs successfully according to the Audit History, but the generated PDF body is always empty because the <<Start>> expression is not being processed. The PDF only shows data from the parent 'Reportes' row.

We have already debugged and verified the following:

  • The data structure in Google Sheets is correct.

  • The Ref relationships, Keys, and Labels are correct.

  • We have completely revoked and re-granted all account permissions, including Google Drive access.

  • We have tried multiple <<Start>> formulas, including SELECT() with a DATE() condition, and also a direct reference to a Virtual Column [ArticulosDelReporte].

  • The virtual column [ArticulosDelReporte] correctly shows a list of IDs when displayed in the app's detail view.

This seems to be a platform bug. My App ID is 3e5ef532-2ca9-45f4-a3e5-f24d82e14e0e.

My template <<Start>> expression is currently: <<Start: [ArticulosDelReporte]>>

Please advise. Thank you.

0 2 85
2 REPLIES 2
Top Labels in this Space