Now my current workflow is like this:
- User uploads an image: The image contains: trainee name, course title, date of training, and name of the managing director.
- AI processes the image: AI analyzes the image but only extracts trainees who have signatures (ignores others without signatures).
- Append row (individual trainee record sheets): Each signed trainee’s details are appended into their respective individual record sheet(s) (Google Sheets, Sheets1, Sheets2).
- Get row (training plan sheet): The system retrieves rows from the training plan sheet to check if the training info from the user’s image matches an existing plan.
- Update row (training plan sheet): Once a match is found, the training plan’s actual completion date is updated based on the uploaded image.
And now I want to some new functions:
- Send Email to HOD: Once the trainee record is appended and the training plan’s actual completion date is updated:
An email is automatically sent to the respective Head of Department (HOD). The email will state: “You need to evaluate the employee’s performance based on the subjects covered in the trainee record.” Timeline: within 3 months from the training date.
**The evaluation form is a google docs format**
- Monitor Training Evaluation Form The AI will check if the HOD has filled in the evaluation form:
If NOT filled after 1 month → send 1st reminder email.
If NOT filled after 2 months → send 2nd reminder email.
If NOT filled after 3 months → send final reminder email.
If HOD fills it before 3 months: Stop reminders immediately. (Example: if filled in month 2, no reminder for month 3.)
How can I solve this kind of problem?? Have anyone can help me?? Thanks so much