Pabbly Connect adds random lines in automated emails sent using Google Sheets

[Speaker]

Your Task History ID

IjU3NjUwNTZlMDYzNzA0Mzc1MjZlNTUzNzUxM2E1MTZiNTQzOTBmMzEi_pc

Task History ID -

IjU3NjUwNTZlMDYzNzA0Mzc1MjZlNTUzNzUxM2E1MTZiNTQzOTBmMzEi_pc​

When a message is added in the trigger column of google sheets, the email is sent properly via Pabbly Connect. However, there are random line breaks added in the email received. No such thing is seen in the response window of Pabbly Connect workflow.

The text formatter is of no use here. The paragraph adds new line randomly. I have tried everything including HTML. It still shows the same issue.

 

[Preeti Paryani]

Hello @Speaker,

Upon checking, we noticed that the line breaks originate from the Google Sheets trigger response, which is why they are also appearing in the email body.

 

[Speaker]

I am not talking about the intentional lines. I am talking about the others. Check the screenshots.

The text 'Don't take any chance' is a single line in the excel sheet. However, the email generated through Pabbly connect shows two lines. Also, look at the last paragraph. 'analysis of your performance' and 'absolutely free'. I have highlighted it in the screenshot in red color.

 

[Preeti Paryani]

Hello @Speaker,

Please try sending the email with the content type set to HTML, then map the response from the trigger. If the issue persists, kindly provide the task history where you have selected HTML as the content type for further analysis.

 

[Speaker]

It did not work.

Task History ID - IjU3NjUwNTZlMDYzNzA0MzA1MjZhNTUzNTUxMzA1MTYyNTQzNDBmMzgi_pc​

 

[Preeti Paryani]

Hello @Speaker,

To resolve this issue, you can use a text formatter to replace \n with <br>. Then, in the Gmail step, set the content type to HTML and map the response from the text formatter step into the body field.

Please try this approach and let us know if it works for you.

 

[Speaker]

I already tried that by following a similar thread here. It did not help.

 

[Preeti Paryani]

Hello @Speaker,

It looks like you have successfully resolved the issue on your own. If you encounter any issues in the future, please feel free to reach out to us.