how to create a workflow to send daily summary emails? OOTB SharePoint Alerts doesn't have capacity to include all the required columns from the list. it just shows what, when and who. this doesn't meet what i want to achieve. to be more detailed, in a forms lib, when a new item is added, all the fields of the forms are included in the summary email, but for items that are modified it shows only the specific column and what when who information of the modified field. Please let me know if you want me the explain more.
This would be really challenging for a workflow. Workflows are designed to be run based on an event, such as adding or modifying an item in a list. Personally, I'd go the powershell route, or if you're in office 365, the Azure Function route. Both of these can be set to run on a schedule, and can easily query a list for changes, and email any metadata in any format to any set of users.