About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Adding hyperlinks from Google Sheets to Google Doc template

  • 15 August 2023
  • 10 replies
  • 358 views
lburke

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! 

icon

Best answer by lburke 16 August 2023, 12:25

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

10 replies

Troy Tessalone
Userlevel 7
Badge +14

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>

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
lburke

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

Troy Tessalone
Userlevel 7
Badge +14

@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/

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
lburke

Unfortunately @Troy Tessalone it just prints that exactly

 

Troy Tessalone
Userlevel 7
Badge +14

@lburke 

Zap action: GDoc - Append Text to Doc

Supports HTML

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
lburke

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

Troy Tessalone
Userlevel 7
Badge +14

@lburke 

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

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
lburke

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. 

SamB
Rank
Userlevel 7
Badge +11

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! 🤗

KKelly

@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