Google Sheets – How to Set Links in Email Body

gmailgoogle sheetsgoogle-apps-script

I have script that sends an email from google sheet and want to have link in the email's body
but code like

var html_link = "google.com";
var body = "<a href=" + html_link + ">Google</a>"
MailApp.sendEmail(email1,subject ,body, {attachments:[{fileName:"RdS "+datet+ ".pdf", content:contents, mimeType:"application//pdf"}]});

give me same code in email body, not the link. So email body looks like this
Google

Where I am wrong?

Best Answer

ok, I learned that you need to apply htmlbody like

var contentHTML = "<body> <font color='red'> <b>SUPERVISOR!</b> \n \n <p> <b> REVISA EL PLAN/FACT DE LA SEMANA</font></b> </p><br> <a href='" + urlsheet + "'>CLICK PARA SIGUIR A LOS REPORTES DEL TURNO</a> </p><br> </body>"
GmailApp.sendEmail(email1,subject ,body, {htmlBody: contentHTML});

now it works

Related Solutions

Google-sheets – How to personalize HTML emails using Mail Merge and Google Spreadsheets

Data from a spreadsheet can be inserted into a Gmail draft email (which can contain HTML) by using the Yet Another Mail Merge add-on in Google Sheets.

Gmail – Automating Predictable Received Gmail Attachments

You can get part of the way there with just Gmail. Add in something like IFTTT and you can get a little further. Note, however, that it's probably not going to be as intelligent as you'd like it and you may occasionally get false matches.

Here's my take on it:

Send an automatic received receipt exclusively to emails that send time-sheet type image or pdf attachments.

You'll need to turn on the "Canned Responses" Gmail Lab. Create a canned response with your response text ("Received").

Then, adjust or create a filter:

to:myEmail@gmail.com has:attachment .pdf

That should pick up any PDF file that's sent to you. (You could get a false match if someone sends some other sort of attachment and puts the string ".pdf" somewhere in their message.)

If you want to match on more file types, you can do something like

.png OR .jpg OR .gif OR .tiff OR .jpeg OR .tiff

For the action, choose "Send a canned response" and, obviously, choose the canned response you created earlier.

Label the gmail with 1 or 2 separate labels like "time-sheets" and "downloaded" (read next part)

In order to label a message via filter with two separate labels, you'll need to have two separate filters. Just copy the criteria for one filter to the other. (If you're ambitious, you can export your filters, edit the resulting XML, then re-import them.)

send the attachment to a specific google drive folder

You can easily do that with an IFTTT recipe. The Gmail channel lets you trigger on a Gmail search and then you can use that to save to Google Drive. Here's a recipe that's similar to what you'd want to do.

The trouble is, this probably isn't going to be sufficient.

You need to check that the attachment is an actual timesheet and that it's signed. You'll need human intervention for that. It'll also be easy to get messed up when someone sends a PDF that's not a timesheet. You might be able to ameliorate that a bit by having your senders put a specific keyword in the subject which you can use in your filter, but then you still have plenty of potential for false-positives (when they use the keyword incorrectly) or false-negatives (when they forget to use it).

You probably need to find some sort of process flow system that can automate your process, but if that's the nature of your question I'm afraid it's outside the ken of this site. (This site is for questions about apps you're already using, not help in finding an app to use.)

Best Answer

Related Solutions

Google-sheets – How to personalize HTML emails using Mail Merge and Google Spreadsheets

Gmail – Automating Predictable Received Gmail Attachments

Related Topic