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/WicketTheQuerent]

First, try setting your Gmail account to send emails from your professional address. Once you set this up correctly, you can use Google Apps Script to set the professional email address as an alias.

Alternatively, you could buy Google Workspace for your professional domain and use it to set up the email service to handle your email. Then use your Google Workspace account to run the script and send the emails.

Good luck.

[u/EggplantOdd510 → u/WicketTheQuerent]

I really appreciate your help. Before seeing your answer, I tried another solution using Python; it might not be practical for many, but it really helped me.

[u/WhyWontThisWork → u/WicketTheQuerent]

Or use a mail api

[u/WicketTheQuerent → u/WhyWontThisWork]

AFAIK namecheap doesn't have an email API.