Automate Emails Using Python! Build An Automatic Payment Reminder & Schedule Your Scripts Online

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
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.

🌍 𝗟𝗜𝗡𝗞𝗦:

⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 – Intro
00:56 – Project preparation
02:31 – Sending emails
07:52 – Accessing & querying Google Sheets data
12:44 – Testing the local Python solution
14:03 – Deployment to the cloud
19:30 – Testing the cloud solution
21:00 – Outro

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:

[CodingIsFun]

I hope you liked this Python automation project.
Here are the links to get started ⤵

*Happy Coding!* 🚀

[tqdam]

Excellent video! Thank you! I was looking for something like this and your explanation took me over the finish line.

[TimePasser]

You rock 👏👏👏👏 .. Thank you. Exactly what I needed in my organisation. Just got my SMTP settings last week. It's like you are living in my brain. Thank you very very much.

[faizan]

I've never been to the comment section; I usually only read. But for the first time, someone encouraged me to join. This is an excellent video; I never thought someone could explain the concepts this well. Great job! Hoping for growth in this channel! 💯

[ermalgashimramori]

As always you deliver gold, thank you!

[joernhahn]

Thanks for explanation and inspiration! Your videos are great!

[jmzh]

This is exactly what I’m looking for, thank you!

[vsddkkjjhgrreertyfdserrftyh]

I don't know much about python just start data mining with pandas but want to automatically run my script at particular time and send mail with attachment i was searching for code ..and u shared this.. little bit difficult for me because of new in this..but will definitely try this..thanks... 👍

[mustafakamal]

Hi. I am having some problem in deploying the app. I don't know how to set the environment variables and how to set the event scheduler ( I want to send emails every 15 minutes lets say). Can you please guide me on just the deployment part for the new data space?

[JD-kpdp]

Nice video, could this be used to send out emails each day (Monday to Friday) for X amount of weeks to people? e.g. a person is on a 6 week course and you want to send them a daily email with exercises/training to do? Thanks

[janneyens]

Great video! Do you think it is possible to make the same tool, but for an offline excel sheet?

[paololigori]

thank you, that was a great video and i learned a lot! just asking, is there a way to check if your email has been replied to using python? thanks

[brenttonhuey]

Hello, Is it possible to have this action be triggered with a checkbox instead of a yes or no as your video brings out. I have a spreadsheet that utilizes check marks, and would love if can use this method for it. Thank you for this video. It was very informative

[gbfd]

Hi thanks for the tutorial is there any other free alternatives you could recommend for deta as it looks like you cant host python code there anymore as the site layout has completely changed.

[jamilhassan]

Hi Sven,
Many thanks for your clear explanations, it's very helpful!
I'm trying to do the same using my Gmail account. As you explained, i tried to turn On the less secur apps access on my google account but unfortunately,
Google changed their policy regarding this option last May and now it's no more available...
So my question is, do you know if there is any why to get around this?
Is it possible to use additional Python code or specific libraries?
Thanks again

[pabs]

Thank you for the turorial! I did want to ask a question though. When I try to load my env vars to deta it returns me the name of the env var and says it has an improper name. I was wondering if you had an idea why that could be. Thank you for your time.

[Kipzo]

Hi there!
I've followed step-by-step, nonetheless, in Deta, when I run the micro, the following appears:

Traceback (most recent call last):
File "/opt/python/detalib/debugger.py", line 142, in wrap
result = func(event, context)
File "/var/task/_entry.py", line 12, in handler
import main # noqa
File "/var/task/main.py", line 2, in <module>
import pandas as pd
ModuleNotFoundError: No module named 'pandas'

I have made sure that I installed all the modules everywhere(cmd, pycharm and powersell)

Please let me know, thank you in advance

[vsddkkjjhgrreertyfdserrftyh]

Please Share code for automatic attachment download from the outlook of specific subject line store that data in folder and by using that data run another python script automatically...it will also helpful 😀👍

[arshkamran]

can I use css in my html file to make my email file more slick?

[captain_fatin]

How did you name the columns in spreadsheet? Mine is showing error raise ValueError(
ValueError: Missing column provided to 'parse_dates': 'from_date, to_date'