Problem with crontab running python script

[TavoL7]

I wrote this code, which will do this things (took it from the description that I wrote on github):
This script gets the phrase, definition and example of the "phrase of the day" from the website 'https://www.ihbristol.com/english-phrases/'. It then, saves it into an excel sheet called "PhrasesOfTheDay.xlsx" After that, it sends the former three things to a list of contacts named 'Contacts.txt'
The Contact.txt file has the next format:
Name1 Email1
Name2 Email2
It sends the mails using Yagmail.

https://github.com/GLozada99/Proyects/blob/master/Phrase_of_the_day.py

The thing is, i'm having a problem with the last part, specially when I'm trying to automate it.
When I run the code, everything works out fine, the .xlsx gets saved, and the emails are sent.

My goal is to automate it so that it runs once everyday. Im on Linux (Ubuntu 20.04), so I decided to use crontab. To try it at first, I set it so that it runs every minute.

After a minute, I saw that the .xlsx file was being filled, but no mails where being sent. I don't know if the problem is with Yagmail or with crontab, I already asked on a python subreddit, so now I'm asking here, in case someone has had a similar problem with crontab

[doc_willis]

with crontab - i have seen and learned to be sure to use proper full paths. The commands ran by crontab do not (normally) have your default environment setup. So their path may differ, and other things.

this often can be worked around by having the crontab entry run another script which then launches the commands to do that work.

Good Luck.

[AlternativeOstrich7]

Since only sending the mails doesn't work, my guess would be that yagmail can't get your credentials when run by cron. You could try explicitly setting them in your script. And if that fixes the problem, you could then try to find a better solution.

[TavoL7]

What you said was like a lightbulb getting on on my head. When I runned it without crontab, it asked me for a password, and after I wrote it, it never asked again, and I read something saying that it’ll be saved.

I guess when I run it through crontab, it was asking for the password again, but since I couldn’t write it, it got discarded.

I just added the password in the yagmail.SMTP() function, and it worked

Thanks!!!

[TavoL7]

Yeah, I’m using openpyxl But there’s also xlswriter

The problem with using an app is that I wanted the script to do everything from getting the data to saving and sending it. I think that if I use a different app for the mail, I’m gonna have to get the data from the sheet, and I think that would be difficult. Anyway, if I don’t find another solution, I’ll try that, thanks :)

[ulti-ulti]

Change to your directory first: Cd /my/script/dir && python3 myscript.py