{"product_id":"n8n-sharepoint-csv-timesheet-reminder-emails-via-outlook","title":"n8n SharePoint CSV Timesheet Reminder Emails via Outlook","description":"\u003ch3\u003eAutomate Monthly Timesheet Reminder Emails from SharePoint—Delivered via Microsoft Outlook\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls your employees’ timesheet CSV from \u003cb\u003eMicrosoft SharePoint\u003c\/b\u003e, then automatically sends \u003cb\u003eOutlook reminder emails\u003c\/b\u003e to each employee for the \u003cb\u003eprevious month\u003c\/b\u003e (CC’ing their manager). After sending, it clears the recipient-related columns in the CSV and uploads the updated file back to SharePoint.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eMonthly schedule:\u003c\/b\u003e Runs at \u003cb\u003e07:00\u003c\/b\u003e on the \u003cb\u003e1st, 2nd, and 3rd calendar day\u003c\/b\u003e of each month.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eBusiness-day guard:\u003c\/b\u003e Checks whether today is the \u003cb\u003efirst business day (Mon–Fri)\u003c\/b\u003e of the month; if not, it stops.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDownload \u0026amp; parse CSV:\u003c\/b\u003e Downloads the employee CSV from \u003cb\u003eMicrosoft SharePoint\u003c\/b\u003e and parses it into records.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eBuild recipient list:\u003c\/b\u003e Extracts name, employee email, and manager email, filters out incomplete rows, and prepares a \u003cb\u003eprevious month label\u003c\/b\u003e for the email text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSend reminders:\u003c\/b\u003e Loops through employees and sends a \u003cb\u003eMicrosoft Outlook\u003c\/b\u003e email reminder to each employee, with their manager \u003cb\u003eCC’d\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUpdate \u0026amp; re-upload CSV:\u003c\/b\u003e Clears the email-related recipient columns, converts the updated data back into CSV, and uploads it to \u003cb\u003eMicrosoft SharePoint\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTeams that manage timesheet tracking centrally in SharePoint and need consistent monthly reminders.\u003c\/li\u003e\n  \u003cli\u003eHR\/Operations workflows where employees must receive reminders while managers are kept in the loop via CC.\u003c\/li\u003e\n  \u003cli\u003eOrganizations standardizing communications for timesheet completion without manual email sending.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e Microsoft SharePoint (OAuth2) + Microsoft Outlook (OAuth2, send permissions).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003en8n workflow nodes used:\u003c\/b\u003e \u003ci\u003eset\u003c\/i\u003e, \u003ci\u003ecode\u003c\/i\u003e, \u003ci\u003esticky note\u003c\/i\u003e, \u003ci\u003econvert to file\u003c\/i\u003e, \u003ci\u003esplit in batches\u003c\/i\u003e, \u003ci\u003eextract from file\u003c\/i\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCSV mapping requirement:\u003c\/b\u003e Your CSV should include expected columns (e.g., \u003cb\u003eMA\u003c\/b\u003e, \u003cb\u003eCROSS_MA.email\u003c\/b\u003e, \u003cb\u003eCROSS_MA.VG_email\u003c\/b\u003e) or you must update the column mappings used to build the recipient list.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46236464218291,"sku":"N8N-21004","price":10.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Y5lTwn51JsoVeIhtckSck_k0zKwf8d.png?v=1792227976","url":"https:\/\/buyflowscripts.com\/products\/n8n-sharepoint-csv-timesheet-reminder-emails-via-outlook","provider":"N8N Commerce","version":"1.0","type":"link"}