All lists have the "Export to Excel" button in the ribbon and it creates a nice spreadsheet. I would like to automate that process. I want to create a site workflow that will export the entire list to excel, save the file as an attachment, attach it to a notification, and email the notification out once a week.
Has anyone created this before? I have to imagine it's possible. Just not sure where to start.