Skip to main content
Question

How do I extract specific email data into Google Sheets each month?

  • Oct 16, 2024 10:36 AM UTC
  • 7 replies
  • 109 views

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?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Oct 16, 2024 2:42 PM UTC

Hi @rjames26 

Resources for email parsing:

 


  • Author
  • Beginner
  • Oct 24, 2024 11:03 AM UTC

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.


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Oct 24, 2024 3:15 PM UTC

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


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • Oct 25, 2024 3:17 AM UTC

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.


  • Author
  • Beginner
  • Oct 25, 2024 10:12 AM UTC

@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?


  • Author
  • Beginner
  • Oct 25, 2024 10:14 AM UTC

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


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • Oct 30, 2024 6:28 AM UTC

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.