I have a social networking site where people connect, meet and build network. User created their profile based on there interest. Users can visit others people profile and send connection request to them. I wanted that user who visited other profile that user will recevied the email that hey this user is viewed your profile go check it out.
I want high level plan for the project in three steps

1.⁠ ⁠Router that invokes the members pulling from the DB

2.⁠ ⁠Operate on the records and pull list of viewers, build the template based listing of members and store into the Bull or Redis

3.⁠ ⁠A consumer that reads from the Bull queue and send email using google SMTP.

guide me to how to approach for this project.