3 votes

How can I insert formatted links in Google Sheet concatenations?

As the OP already realized, getValue() and getValues() return a string object for cells containing an hyperlink and the value returned when the object is concatenated is the link text that the OP ...
Rubén's user avatar
  • 44.6k
1 vote

How can I 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.
Michelfrancis Bustillos's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible