Google apps script guru.. I can write a script, that will scan the list of given spreadsheets, every Monday, and send the email, to the mentioned email addresses, if they are expiring, as requested.
I have written several Google apps Script, and can do this for you, with absolutely best optimized code.
ZERO ERROR GUARANTEED!! Please read my 350+ reviews. I am here to impress you with my work.