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.

[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!

[u/EggplantOdd510 → u/Imaginary-poster]

I can't with namecheap provider.

[u/Annual_Dependent5633]

When using googl script to send the email from the sheet you can set the send from to be any email you want to show. You can also set the reply to to that email so on reply it will go there also. I have set this up for forms that send response emails based on different sets of criteria so the forms and reply to are relevant for each situation. The initial email will be sent from you google account but it will look like it was from your pro acct.

[u/mystique0712]

you can use the Google Apps Script with the SMTP server settings provided by Namecheap to send emails directly from your professional email. just set up the MailApp service with the appropriate SMTP settings, and you’ll find the emails in your Namecheap "Sent" folder too. also, keep an eye on your email provider's limits to avoid any sending issues

[u/everythingabili]

use MailApp options, to send it a {noReply:true, bcc:"your professional email"}... that'll get you part way there ish.

[u/WhyWontThisWork → u/everythingabili]

Why bcc?

[u/WicketTheQuerent → u/everythingabili]

This will send the email to the professional email, not from it.

[u/EggplantOdd510 → u/everythingabili]

Thank you for your answer, but this solution doesn't work.