How to output the URL a Google Sheet cell text is linked to in the Respond action of Glean agent?

luwang

Hi.

I'm working on a Glean Agent. In the read step, I selected a few Google Sheets docs, and each of the Sheet contain information sessions' names with a link to the session recording URL. In the Response step, I wanted to output a table that includes the URLs to the sessions (not just the session names). I've tried many different prompts, and it seems like my Glean agent wasn't able to output the URLs in the Respond step. Any thoughts on how I can get over this issue?

Thanks.

ilianaportugal

Hi @luwang, is the session URL linked to a text value or does the URL appear as text in a cell? Glean currently doesn't index hyperlinks for google sheet documents which might be why the Agent is unable to output the URL. If the session URL appears as text in a cell I had luck generating a table in Glean that shows the URL with the following Respond instructions. Hope this helps!