I'm new to SharePoint Designer and I wondering if there is a way to trigger a List Workflow to execute on 1st of every month to loop through a SharePoint to create an email notice of files added in previous month. There seems to be two challenges.
1) Trigger workflow on the first of every month. OOTB triggers are based on created or modified date. I'm guessing windows task manager if it's not doable in the workflow.
2) Have the workflow loop through sharepoint and pull the file names/descriptions that were added the previous month based on create date. then add those file names, description, etc into an email. Can be HTML email.
Basically, an email notice on the first of every month on what files were added to the SharePoint the previous month.