Are you still manually sending emails to your customers and clients? In this video, I'll show you how to send automated reminders. In particular, I will show you how to send emails with Python. Afterwards, we are going to host our Python script. You can then determine when exactly you want to run your script. This solution might be helpful if you do not want to spend a dime on any expensive email automation solution. You can build your email automation solution for free if you follow this video.

Install the dependencies with pip

pandas
python-dotenv

[FOR WINDOWS] Install the Deta CLI, open PowerShell and enter:

  iwr https://get.deta.dev/cli.ps1 -useb | iex

Here you find the Google Sheet I have used in the video: ⤵
https://pythonandvba.com/sheets-invoice-data

Official Documentation: https://docs.deta.sh/docs/micros/getting_started

[FOR WINDOWS]
To deploy this project you:

1. login via the deta CLI

  deta login

2. create a new micro (only once!)

  deta new --python first_micro

3. upload your environment variables

  deta update -e <env_file_name>

4. deploy your app

  deta deploy

5. set the cron job
   Example: Run every minute

  deta cron set "1 minute"

To run this project, you will need to add the following environment variables to your .env file
EMAIL PASSWORD

Explore my tools and templates for Excel, automation, and more.

View all solutions

• YouTube: CodingIsFun
• Website: PythonAndVBA
• LinkedIn: Sven Bosau
• Contact: Get in Touch

If you find this project helpful, consider buying me a coffee.