Need help on sending reminder mail for not filling up timesheet

I am developing timesheet for my team, here is it's screenshot. My team are supposed to fill up the time they have worked daily in it.

Through Pabbly connect I want to send a reminder mail at 11:30pm IST to those who have not filled their timesheet.
i.e.

1. If today's date is not listed in the spreadsheet date (column A) send a reminder mail or
2. If today's date is equal to spreadsheet date (column A) but duration (column D) is empty send a reminder mail

I am stuck here.

I don't know if I am doing things right? Please help me, I understand that for loop is not required when iterator is used.
But I don't want to send email against every record matching in the sheet, I want to send one email per day.
How to I do it? Please help ?

- Arun

Attachments

Hey @arunkw

We have made some changes in your workflow and in the filter condition according to your use case. Please check your workflow - (Timesheet Reminder Arun Get Rows ) and give it a try and let us know if that works for you.

Thanks!!

I got two email, I was expecting just one

Consumption of 31 Free tasks it too high, how can it be reduced.

Hey @arunkw

We cross-checked your respective workflow and it is working according to your use case. Although you need to map the email id in the Gmail action step inside the router condition accordingly.

Further, the task consumption is according to the steps which are used and only Google's Get Row and Gmail action step is counted for each entry present in your workflow. Though we have reset all your tasks for your further trials and to test your conditions.

Hey bro @Supreme Verma - Thank you for resetting the tasks for me.
I got two emails again, you did not get my use case, to give clarity here is what I am looking for

    
sendmail = true
For loop i=1 to last rows
     If current.date = date.in.cell then
              sendmail = false
              Exit for loop
     else
     endif
End for loop
   
If sendmail = true then
        shoot email once
else
endif

We have made some changes based on your requirement and created another workflow name as "CLONE - [Timesheet Reminder Arun Get Rows]".

Please check this workflow and test it. You will receive the email notification once.