Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I get emails each month set up in this format and I’m looking to pull specific parts of the body of the email into Google Sheets - specifically ‘Serial Number’, ‘Total Colour Counter’ and ‘Total Black Counter as well as the date.  Can anyone advise how i can do that?

Hi @rjames26 

Resources for email parsing:

 

Thanks for your reply but unfortunately this hasn’t really helped - I have tried using Formatter and Utilities but seem unable to extract the data i just get the text in full in a cell in Google Sheet when ideally I’m looking to either extract 3-4 lines of data only with a new cell for each or if that’s not possibly then each line is given a separate sell and i can just hide the ones i don’t need.

@rjames26 

For us to have more info, post screenshots showing how your Zap steps are outlined and configured in EDIT mode so we can see the field mappings.

Hi @rjames26,

 

Just to advise, when posting a screenshot to the Community, it is essential to obscure any sensitive information within the screenshot for security purposes. Thank you. We're looking forward to troubleshooting your issue further.

@rjames26

For us to have more info, post screenshots showing how your Zap steps are outlined and configured in EDIT mode so we can see the field mappings.

The biggest issue seems to be that at this point the data being pulled is not in the correct format, for example line 1 should read Model name externroscorvillage but the later appears on line 2 and then I’m unable to publish even though there are no active errors?

Hi @rjames26,

 

Just to advise, when posting a screenshot to the Community, it is essential to obscure any sensitive information within the screenshot for security purposes. Thank you. We're looking forward to troubleshooting your issue further.

There is no sensitive info within the screenshot, the serial numbers are just for internal use and will not reflect to anything outside of the business

Hi @rjames26,

I believe you would require to add multiple formatter steps for your workflow to be possible. However, have you tried utilizing Code by Zapier? Code by Zapier has a “Generate with AI” button that can help you generate code for the output that you want.

Hopefully, this helps.

Terms & Conditions