Skip to main content
Best answer

Why is Zapier transferring HTML instead of plain text from Outlook email body to Smartsheet?


smccms

Hi All,

I’m relatively new to using Zapier. I’d like to automate cataloging emails received from an outlook inbox to a Smartsheet. 

I’ve successfully connected the two apps and it’s working pretty well- the issue that I’m having is with the body of the email. The Zapier pulls over the HTML code to the Smartsheet, rather than just the plain text. Currently I can pull over a “body preview” and that is working well, but the problem is not the entire message is transferred. 

 

I’ve tried using the Zapier template and having emails forwarded to the Zapier email address. That didn’t work because columns such as the original sender are then changed. 

 

Are there settings in my outlook that should be changed in order for the body text to be transferred? Any other recommendations to solve this? 

 

Thank you,

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi @smccms 

Good question.

Try adding this Zap action: Formatter > Text > Remove HTML Tags

View original
Did this topic help you find an answer to your question?

4 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30948 replies
  • Answer
  • August 4, 2023

Hi @smccms 

Good question.

Try adding this Zap action: Formatter > Text > Remove HTML Tags


smccms
  • Author
  • Beginner
  • 2 replies
  • August 4, 2023

@Troy Tessalone thanks for the quick response.

 

This is going to show my lack of Zapier skills. Where do you add the Zap actions? 

 


smccms
  • Author
  • Beginner
  • 2 replies
  • August 4, 2023

disregard I think I found it. 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6380 replies
  • August 8, 2023

Hi @smccms,

Cool beans! I’m glad Troy was able to help you out!

If you have any other questions, please don’t hesitate to reach out. We’re always happy to help! 😊