Chatbot hyperlink bugs and retrieval issues

I am having a buggy experience with chatbots thus far. I am creating bots that return custom email content for our support team to save time. In our bot, I am trying to return links so that the customer can have a great buying experience.

I have two issues:

  1. Hyperlinks are incorrect: Hyperlinks are not retrieving correctly from a simple two column spreadsheet, whereas the first column is the product code and second is the hyperlink. The bot is changing the hyperlink.
  2. Hyperlinks are not clickable. When it outputs the link, they are non-clickable.

Anyone else have this experience?

Bot Link:
g-4U6tdtDXI-nutritional-assessment-email-generator

Initial Prompt:
Supplements - Costs and Quantities

Product

Code

Daily

Dosage Day Week Month

# of

Bottles

Bottle

Size

Unit

Price

(for a 30 day supply)

Total

Price

---- Cost Per ----

Ashwagandha Complex M1635 3 $3.94 $27.59 $118.25 1 120 $118.25 $118.25

Cataplex® B-Core 1260 2 $1.49 $10.40 $44.55 1 120 $44.55 $44.55

Gymnema M1320 2 $1.91 $13.35 $57.20 2 40 $28.60 $57.20

7 $7.33 $51.33 $220.00 4 $220.00