I have 6 different PDF email distribution automations set up to run daily at staggered times between 9:00am CST and 9:05am CST for 6 different apps. On an intermittent basis one of the 6 will fail with an error message generated at the PDF generation block stating there are no public sheets, however all the sheets in the app are public. Each time I do a manual run of the automation and it completes successfully, with no changes being made to the app or to the automation. What could be the reason this is happening?
