How to attach Excel as attachment in Notification

[Dharaneetharan]

I have a requirement to send an email with an excel attachment containing the records based on a query in a custom table.

 Detailed Explanation:

1) Email should be triggered to Department head after 35 days when users in that department doesn't made response to tasks in custom table.

2)There are multiple departments and each department head to receive an email with attachment containing the users from their department.

Kindly advice if there is a way to achieve this.

[Ankur Bawiskar]

@Dharaneetharan 

you cannot generate excel as an attachment and add to record

why not use CSV?

how is your flow configured to run now?

you can use custom flow action and use script to create CSV file and then attach it to your record and then send email using Notification and in that notification use "Include attachment" checkbox

Generate CSV file through script

If my response helped please mark it correct and close the thread so that it benefits future readers.