Skip to main content
Best answer

Adding hyperlinks from Google Sheets to Google Doc template

  • August 15, 2023
  • 10 replies
  • 759 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! 

Best answer by 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. 

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34005 replies
  • August 15, 2023

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> 

 


lburke
  • Author
  • Beginner
  • 4 replies
  • August 15, 2023

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


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34005 replies
  • August 15, 2023

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


lburke
  • Author
  • Beginner
  • 4 replies
  • August 15, 2023

Unfortunately @Troy Tessalone it just prints that exactly

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34005 replies
  • August 15, 2023

@lburke 

Zap action: GDoc - Append Text to Doc

Supports HTML

 

 


lburke
  • Author
  • Beginner
  • 4 replies
  • August 15, 2023

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34005 replies
  • August 15, 2023

@lburke 

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

 


lburke
  • Author
  • Beginner
  • 4 replies
  • Answer
  • August 16, 2023

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
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 9662 replies
  • August 16, 2023

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
  • New
  • 1 reply
  • August 17, 2023

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