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 ...
- 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.
- 1,234
Only top scored, non community-wiki answers of a minimum length are eligible