{"product_id":"n8n-workflow-sharepoint-csv-weekly-timesheet-reminders","title":"n8n Workflow: SharePoint CSV Weekly Timesheet Reminders","description":"\u003ch3\u003eSend weekly SharePoint time-tracking reminders automatically—every Monday \u0026amp; Wednesday\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow downloads an employee CSV from \u003cstrong\u003eMicrosoft SharePoint\u003c\/strong\u003e, sends each employee a \u003cstrong\u003eMicrosoft Outlook\u003c\/strong\u003e time-tracking reminder email (with their manager CC’d), then clears the recipient fields and uploads the updated CSV back to SharePoint.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e triggers every \u003cstrong\u003eMonday and Wednesday\u003c\/strong\u003e at \u003cstrong\u003e13:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads and parses the CSV:\u003c\/strong\u003e pulls the target CSV from Microsoft SharePoint and converts it into structured rows for processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a recipient list:\u003c\/strong\u003e extracts \u003cstrong\u003eemployee first name\u003c\/strong\u003e, \u003cstrong\u003eemployee email\u003c\/strong\u003e, and \u003cstrong\u003emanager email\u003c\/strong\u003e from the CSV. Rows missing a name or email are filtered out.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends reminder emails:\u003c\/strong\u003e iterates through the recipient list and sends a reminder email to each employee using \u003cstrong\u003eMicrosoft Outlook\u003c\/strong\u003e, with the \u003cstrong\u003emanager included in CC\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents repeated recipient data:\u003c\/strong\u003e clears recipient-related columns in the original CSV data, converts it back to CSV, and uploads the updated file to Microsoft SharePoint.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate \u003cstrong\u003eweekly timesheet reminder\u003c\/strong\u003e emails for distributed teams.\u003c\/li\u003e\n  \u003cli\u003eEnsure managers are consistently \u003cstrong\u003eCC’d\u003c\/strong\u003e for visibility and follow-up.\u003c\/li\u003e\n  \u003cli\u003eUse SharePoint as the single source of truth by updating the CSV after reminders are sent.\u003c\/li\u003e\n  \u003cli\u003eReduce manual admin work for SaaS operators managing recurring workforce communications.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Microsoft \u003cstrong\u003eSharePoint\u003c\/strong\u003e (download\/upload) and Microsoft \u003cstrong\u003eOutlook\u003c\/strong\u003e (email sending) via OAuth2.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e set, code, sticky note, convert to file, split in batches, extract from file.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCSV mapping:\u003c\/strong\u003e expects columns such as \u003cem\u003eMA\u003c\/em\u003e, \u003cem\u003eCROSS_MA.email\u003c\/em\u003e, and \u003cem\u003eCROSS_MA.VG_email\u003c\/em\u003e (or you can update mappings to match your headers).\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup tips:\u003c\/strong\u003e confirm your SharePoint site and file for both download and upload, connect Outlook credentials, and test email content with a safe address before enabling the workflow.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46196327153843,"sku":"N8N-20701","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/qhbSoZnBq4aJ4NBh8ffbi_CnJhOS3L.png?v=1791623677","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-sharepoint-csv-weekly-timesheet-reminders","provider":"N8N Commerce","version":"1.0","type":"link"}