Every morning, I'm three different automations, each of which attach a PDF of a different sheet from a dashboard an email. Ideally, all of these PDFs would actually be included in a single email.
However, when I tested this with the automations by generating several reports and attaching them all to a single email, the resulting email had no attachments.
Has anyone been able to generate multiple reports and include them all in a single email through an automation? If so, I would love any advice you may have to do this!
Do the sheets need to be in separate PDFs when delivered or can all three sheets be in the same PDF?
If the latter, then have you tried to use 'add sheet to report' for each separate sheet? (withing the same automation).
In the case of the former, does each report/attachment output have the same name or are the names dynamic? I'm thinking that you may be able to attached all 3 three to as separate automation that sends attachments only (if the report output names are the same) but I haven't tested that yet.
Kind regards...
Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
