Links in automation email not clickable

Hmm, I think you might need to modify your email automation to accommodate hyperlinks.  The syntax is:

And so you could do something like:

Resulting in this:

---
For your use case, you'd want to just use the same value twice like so:

Data:

Automation: 

Preview:

Link to base

Create two separate fields: one for the link name and one for the link itself. Then, inside the email automation, use [Link Name](link). 

You more information, you can check out the article here.