Skip to main content
Question

The Formatter is not splitting text into line items, no matter what I try

  • August 5, 2025
  • 2 replies
  • 9 views

If anyone can help me I’d appreciate it.  I’ve been trying every which way to get the Formatter to split text and the output always comes out as a giant block of text.  I’ve tried all the syntax combos, and segmentations and retested and retested.  I can’t get it to work.  

All I want to do is have take the data from an email, which came from a form submission, and copy the answers in each field into a Google Sheet.  

Has anyone had this experience or know what I can do?  Thanks so much.  

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

DennisWF
Forum|alt.badge.img+5
  • Zapier Solution Partner
  • 153 replies
  • August 5, 2025

Hi ​@Heatherbee , can you share some screenshots showing where the data is coming from and how you’re trying to split it with Formatter?


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 9736 replies
  • August 20, 2025

Hey there, ​@Heatherbee 👋

Did you manage to get that Formatter action working? If you found a solution, it would be great if you could share what worked - I'm sure other community members facing similar challenges would really benefit from knowing how you solved it! 🙏

If not, perhaps you could try using an Analyse and Return Data (AI by Zapier) action to reformat the email text into separate fields. You can learn more about how to use that type of action here: Use AI by Zapier to analyze and return data

If you're still stuck, feel free to share some screenshots as DennisWF mentioned and we’ll be happy to lend a hand. 🙂