Hello!
I am automating a communications process. Happens quarterly and takes sooooo much time.
Zap 1 captures form details from clients into google sheets. I populate some info using some vlookups like their website urls, products they have with us and UTM links.
Zap 2 creates a google doc from a template based on the data in the sheets row.
We have 4 different url and utm fields that need to appear as links. One of the fields is a company url another is a link to a company specific comm etc. When the doc is created it is appearing as plain text and not a link.
For the utms, we need them to appear as home.company.com but have the full utm with campaign stuff underneath it like a usual link in docs.
None of the other articles on here seems to help. Someone suggested a href but didn’t say if i put it in the field in zapier with the data column included in there or how to get it to be row specific or in google docs.
If google docs.. where/how? Like this below? Or do I need to do some sort of fancy formatting? not my area of expertise.
Google append was another suggestion but I’ve 250 docs to do with 4-8 different links os not sure if that would even work or be the best way of doing it.