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.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/f696586f-c0aa-41af-b6d0-7317b1efb3a3.png)
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.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/23b13322-d0f6-46f8-8db1-8e8af8c53cdc.png)
If google docs.. where/how? Like this below? Or do I need to do some sort of fancy formatting? not my area of expertise.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/57162508-0e01-4590-9bb7-b7ad815de08a.png)
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.
Best answer by ken.a
View original