Question

Create a Google Doc from a template, how to convert HTML content (tables) when injected in markers

  • 10 April 2024
  • 4 replies
  • 33 views

 

Hello !

Use case is quite simple : 

  • every month airtable export HR counters (table of 6 rows), list of days off and list of worked days.
  • an automate performs a 3 “Find records”, one per table, and trigger a Zap with a webhook
  • webhook contains the tables in html format : 

 

 

  • the Zap use a Google Docs Template as below and should insert the html code provide by the webhook inside each markers : {{compteur}}, {{absence}}, {{travail}}

 

Issue is that the HTML is not converted into table and displayed “as-is”, making the doc useless.

Is there a way to manage this case ? I’d like to avoid the “Append doc” which is not working well.

 

Thanks


4 replies

Userlevel 7
Badge +14

Hi @DEEDA 

That would likely involve using the GDocs API: https://developers.google.com/docs/api/reference/rest

 

Thank you Troy for the suggestion. It’s always a kind of failure when the answer to do something with a no code tool is developp with the API… sounds like there is a loophole for such a simple topic :(

Userlevel 7
Badge +11

Hi @DEEDA 👋

Perhaps you could try using the Create Document from Text (Google Docs) action? I’ve used that action to create a document that had HTML tags in it before and it worked.

Can you give it a try and let us know if that does the trick?

Userlevel 7
Badge +11

Were you able to get this sorted using a Create Document from Text action, @DEEDA? If you’re still in need of some help on this at all please let us know - happy to help further! 🙂

Reply