Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi there

I have created a Google Doc template in my gsuite.

I have a Google Sheet that when a row is added I want Zapier to create a new Google Doc from the Google Doc Template I assign.

 

 

It creates the document and puts the document into the folder i assigned in my google drive, however, in my template I want to add hyperlinks. I can’t figure out how to do the equivalent of =hyperlink(“https://sample.com”, “here.”), the link changes for every person that gets added to the sheet.

 

Any help would be really appreciated! 

Hi @lburke 

Good question.

Try adding a link.

https://www.w3schools.com/tags/att_a_href.asp

 <a href="https://www.w3schools.com">Visit W3Schools</a>

 

Thank you for your response @Troy Tessalone do I add it under “Create Document from Template in Google Docs” actions? 

@lburke 

It would be in the GDoc Template field you’ve configured that shows up in the Zap action step.

e.g. {{URL}} in the GDoc Template

Help: https://zapier.com/blog/create-autopopulate-google-docs-template/

Unfortunately @Troy Tessalone it just prints that exactly

 

@lburke 

Zap action: GDoc - Append Text to Doc

Supports HTML

 

 

Yes this works but the Append text to document action will only add text to the bottom of a document, it can’t add text to other areas of a document. So it doesn’t really work on it’s own

@lburke 

If you are trying to do esign, then you may want to look into using a proper esign app.

 

Hey Troy, 

 

No this isn’t an e-sign task, it’s to add unique links in a doc.

 

A different solution I’ve chosen to go with is a Google Script in the template doc, hoping to get it to trigger on duplication of the doc. 

Thanks so much for sharing how you solved it, @lburke. Really appreciate you taking the time to circle back in here and share this information with the Community! 🤗

@lburke could you share the shell of your google script?  I am trying to do something similar, I am creating google slide doc earlier in the zap and i want to insert the alternate link from that step as like “Click Here” in the google doc.  Do you think your use-case would help with mine?

Terms & Conditions