• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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

Speaker

Member
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.
 

Attachments

  • WhatsApp Image 2025-03-04 at 16.52.36.jpeg
    WhatsApp Image 2025-03-04 at 16.52.36.jpeg
    40 KB · Views: 49
  • Screenshot 2025-03-04 at 5.02.40 PM.png
    Screenshot 2025-03-04 at 5.02.40 PM.png
    43 KB · Views: 49

Preeti Paryani

Well-known member
Staff member
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.

1741089526605.png
 

Speaker

Member
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.
 

Attachments

  • WhatsApp Image 2025-03-04 at 16.52.36.jpeg
    WhatsApp Image 2025-03-04 at 16.52.36.jpeg
    43.7 KB · Views: 46

Preeti Paryani

Well-known member
Staff member
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.

1741090920282.png
 

Preeti Paryani

Well-known member
Staff member
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.

1741155658506.png


1741155671898.png
 

Preeti Paryani

Well-known member
Staff member
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.
 
Top