Send monthly timesheet reminder emails from SharePoint CSV with Outlook

Description

Quick overview This workflow runs on a monthly schedule, downloads an employee CSV from Microsoft SharePoint, and sends time-tracking reminder emails via Microsoft Outlook to each employee (CC’ing their manager) for the previous month, then clears the recipient columns and uploads the updated CSV back to SharePoint. How it works Runs at 07:00 on the 1st, 2nd, and 3rd calendar day of each month. Checks whether today is the first business day (Mon–Fri) of the month and stops if it is not. Downloads the employee CSV file from Microsoft SharePoint and parses it into records. Builds a recipient list by extracting name, employee email, and manager email, filters out incomplete rows, and calculates the previous month label for the email text. Loops through the employee list and sends a Microsoft Outlook email reminder to each employee with their manager in CC. Clears the email-related columns in the CSV content, converts the updated data back into a CSV file, and uploads it to Microsoft SharePoint. Setup Add Microsoft SharePoint OAuth2 credentials and select the correct SharePoint site and CSV file in both the download and upload steps. Add Microsoft Outlook OAuth2 credentials with permission to send emails from the mailbox you want to use. Ensure your CSV has the expected columns (e.g., MA, CROSS_MA.email, CROSS_MA.VG_email) or update the column mappings used to build the recipient list. Review and adjust the email subject/body text, recipients, and CC logic, and test with a safe address before enabling the workflow. An n8n automation workflow template by Christoph Dibbern.

Community Metrics

Categories

• Automation

Tags

• n8n
• workflow
• microsoft-outlook
• code
• microsoft-sharepoint

Capabilities

• 3 nodes

Information