Send emails automatically with Python code to extract info and format the email

  • 4 July 2023
  • 1 reply

Userlevel 1

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:


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply


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.