When I create Google Docs from a template using Zapier, I continuously get strange formatting. There is an added line break after each variable which is placed in the document.
All the variables are coming in which is great, but it’s quite annoying to have to go through and format the doc after it is created by the automation each time.
Has anyone else had this problem or know how to solve it?
Best answer by Troy Tessalone
Appears the data being sent in on the Webhook has line breaks for the data points. (see screenshot has extra rows before and/after the value)
Would need to run the data points thru a Code step to TRIM the extra whitespace (https://www.w3schools.com/jsref/jsref_trim_string.asp) OR Formatter steps to Trim Whitespace.
Also, might be able to fix the root cause in the system that is sending the webhook.