Skip to main content

The workflow I created does the next:

  1. Schedule: for sending emails automatically, every day.
  2. Lookup emails in some Google sheet tab.
  3. Lookup Open Positions information in another Google sheet tab.
  4. With a Python script I extract the information of step 3 and add some format to the email related to my company.
  5. Send-Create a draft email with all the data collected!

 

You can send emails like this one:

 

 

Sending emails automatically with Python can be achieved using the built-in smtplib library for handling email protocols and the email library for creating and formatting email messages. Additionally, you may use libraries like selenium to extract information from web pages if needed.