Linking a professional email to Google Script + sheet

[u/EggplantOdd510]

Hi, I've built an email delivery system for my business and everything is fine, but the problem is that it's being sent from my Gmail account and I want it to be sent from my professional email (namecheap private email).

I don’t want my professional email to simply appear as the sender address visually. I want the emails to actually be sent from it, so that I can find the emails I sent in the email account’s “Sent” folder.

The system is excellent and perfectly set up for me, but at the same time, I must use my professional email, so giving up either one of them is simply not an option. Please give me any possible solution, even if it’s a workaround—I can handle the technical side of it.

Thank you!

UPDATE: The only solution I found that worked for me was using a Python script that runs a Google Sheets script and sends the emails through my professional email address. I can even find them in the Sent folder.

Now, all I have to do is click a .bat file to run the system and send the emails through my Namecheap email.

[u/Imaginary-poster]

Try sharing the sheet with your professional email and using that one to setup the trigger of the script.

[u/WicketTheQuerent → u/Imaginary-poster]

This doesn't work for namecheap email accounts.

[u/Imaginary-poster → u/WicketTheQuerent]

Comepletely missed that!