How do I add a hyperlink to a cell in Google Sheet?
Trigger: In a Google Sheet, when Col D is set to "No" then run the Zap
Action: Create a Google Doc then add the link of the newly created doc to the trigger row.
I have attached a screenshot of my set up to this post.
I have also tried setting up the Action to add just the alternate link but in both cases, what Zapier adds to the trigger row is just the link in text format, it's not hyperlinked. I will then have to manually convert it to a link which kind of defeats the purpose of creating an automation in the first place. Is there a way for Zapier to add the hyperlink automatically and not just a string of text?
Need help. Thanks!
If you change the mapped field in the second part of your formula to a different field, or just type in some text like I did, does it work correctly then?