The script runs every five minute by a cronjob (*/5 * * * *).
#! /usr/bin/python3
import os
PROJECT_DIR = os.path.dirname(os.path.realpath(__file__))
smtp_server = 'smtp.gmail.com'
sender_displayname = 'Name shown to recepient'
sender_username = '[email protected]'
sender_password = 'yourpassword'
# Spreadsheet credentials
CREDENTIAL_PATH = PROJECT_DIR + '/service_account.json'
# Spreadsheet
ID_SPREADSHEET = 'Googlespreadsheet ID from URL'