Библиотека / Автоматизация эл. почты
Автоматизация эл. почты
Отправка ежемесячных напоминаний о табелях учёта времени из CSV в SharePoint через Outlook
Запускается каждый месяц в первые рабочие дни, читает получателей-сотрудников из CSV в SharePoint, отправляет напоминания о табелях через Outlook с руководителями в копии, затем очищает столбцы получателей.
Что делает
## Send monthly timesheet reminder emails from a SharePoint CSV with Outlook On the first business day of each month, this workflow reads an employee list from a SharePoint CSV and emails each person a reminder to book last month's hours, with the manager in CC. Afterwards the recipient columns in the CSV are cleared. ## Who's it for Controlling and team leads who need complete timesheets at month end. ## How it works 1. A schedule trigger runs at 7:00 a.m. on the 1st, 2nd, and 3rd of each month. 2. A Code node continues only if today is the first business day (Mon-Fri, public holidays are not considered). 3. The CSV is downloaded from SharePoint and parsed. 4. A Code node builds the recipient list, drops rows without name or email, and calculates the previous month's name. 5. Outlook sends one reminder per employee, manager in CC. 6. In parallel, the recipient fields are emptied and the CSV is uploaded back to SharePoint. ## How to set up 1. Connect your SharePoint and Outlook credentials. 2. Select site, folder, and CSV file in both SharePoint nodes. 3. Match the column names in the Code node to your CSV. 4. Edit subject and text in the email node and test with your own address first. ## Requirements - Microsoft 365 account with SharePoint and Outlook - CSV with name, email, and manager email columns - A process that refills the CSV before each run, otherwise no emails are sent ## How to customize Change the schedule or email text, or swap SharePoint and Outlook for Google Sheets and Gmail. The schedule uses the workflow time zone. Test with dummy data first. The workflow emails real people.
Шаги
- Schedule Trigger
- Download file
- Read CSV
- Employee List
- Send Reminder Email
- Loop Over Employees
- Convert to File
- Upload file
- First business day?
- Clear recipients in data.csv
Похожие автоматизации
Автоматизация эл. почтыИИ-рассылка с видео для HubSpotШагов: 43Серверы и инструменты MCPУправление файлами и списками SharePoint как MCP-серверШагов: 12Написание и генерация контентаПревращение таблицы трендов в SEO-рассылки с согласованиемШагов: 42Синхронизация данных и ETLПолучение данных списка SharePoint с токеном OAuthШагов: 4