Skip to main content

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.  

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


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