Best answer

Sending a whitespace character as a google doc template value

  • 14 July 2021
  • 2 replies
  • 19 views

I am creating a new google doc from a template.

 

One of my variables, {{adv_url}}, is sometimes populated (from an earlier step) as a full URL (i.e. “www.google.com”) and sometimes it’s populated with just a single whitespace character (“ “). I’m storing this variable in google sheets, and I can confirm that google sheets is reading it as a 1-char long string rather than blank.

 

But, when I send this whitespace character to google docs, the template does not replace {{adv_url}} with the whitespace. Even if I append a whitespace character to the variable field in the “set up” part of the Zap, a string that only contains whitespaces still shows up in the produced gdoc as {{adv_url}} rather than its new value.

 

I think this is something I need to figure out with gdoc templates, not with Zapier, but I’m not sure what the solution is.

 

icon

Best answer by Cassie 14 July 2021, 22:59

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.

2 replies

Userlevel 7
Badge +11

Hi @Cassie 

Try adjusting this setting in the Zap:

 

I set it to “remove” and that fixed it!! Thank you so much.