How to check and log if a employee has worked their min. Weekend Shift

Questions
1

This is rather a special situation.

We are running a Business that is operatin 7 days a Week and we have a mandatroy 1 Shift on a Weekend per Month Policy.

At the moment we are doing this task by hand checking if a Employee has done its mandatory weekend shift for this month.

Iam a bit at a loss hier how we could automate it with N8N.

I have a Webhook that is already transfering the daily Timesheets to a google sheet.

My thought was to check this sheet as a source.

Now my question is

  1. can N8N determine if a date is on a Saturday or Sunday? If so which function do i need to use?
  2. How can i log or mark an employee as mandatory shift completed?
  3. Last but not least on thursday before the last Weekend of the month all Employees which have not completed the Mandatory Shift should recieve a Slack Message

Thanks for your help

2

Hi,

Changed it to a question, as you had it set to be “tips and tricks” which it clearly isn’t. :slight_smile:

1 Like
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.