The workflow I created does the next:
- Schedule: for sending emails automatically, every day.
- Lookup emails in some Google sheet tab.
- Lookup Open Positions information in another Google sheet tab.
- With a Python script I extract the information of step 3 and add some format to the email related to my company.
- Send-Create a draft email with all the data collected!
You can send emails like this one: