Skip to main content

Hi there.

I have a zap working like this:

  1. Receive responses to Typeform survey
  2. Create record in Airtable
  3. (Airtable looks up formatted text associated with response - eg. Answer A = Text 1)
  4. Create doc from text in Google Docs

The problem is, when Zapier pulls the Airtable text into the Google Doc it looses its formatting (headings, bold, bullets, etc).

Is there a solution that brings the formatting with? Or can I do something to reformat the text after it’s inserted into the Google Doc?

I looked at the Formatter but its capabilities are too limited for this task.

Thank you

Hello @itsame 

Interesting usecase. Did you try customizing the Google Doc Template with the fonts/Bold,etc with the merge tags you add ?


Thanks for the reply @Satya09 

It’s not using merge tags. Rather it’s pulling the formatted text from within an Airtable cell and inserting that into the Google Doc.

For reference, the text looks a bit like…

 

Heading

Paragraph of text

  • Bullet point 1

 

I’m not sure if I could achieve the same result with merge tags, but I’ll look into this.


Hi @itsame 

The Zap action GDoc Create Doc from Template does not support HTML, but the Zap action GDoc Create Doc from Text does support HTML.

 


Hi @Troy Tessalone 

It’s currently using the Create Doc From Text action.

If I format the Airtable cell text in HTML (assuming I can do that), will it show the HTML code in the Google Doc when inserted, or will it format it automatically? I’m unfamiliar with this (and an HTML novice).

Thank you


@itsame 

The HTML would have to be configured in the Airtable Long Text field and/or in the Zap step.

Resource about HTML: https://www.w3schools.com/html/


Okay, will give it a go. Thanks @Troy Tessalone 


I formatted the Airtable text using HTML and it successfully appeared in the Google Doc as formatted text.

Thanks @Troy Tessalone!