About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

  • Home
  • Get Help
  • How Do I
  • How to extract numbers and status from an email and output into separate lines in Google Sheets?
Question

How to extract numbers and status from an email and output into separate lines in Google Sheets?

  • 11 March 2022
  • 1 reply
  • 42 views
L

Hi All,

I have a basic zap set up where I have some simple regex (I don’t know Python) to extract any 12 or 13 digit numbers found in an email - this could be up to 1000 potentially in a single email.

 

I have an issue with writing this to a google sheet as I can’t make it put each of those in a new line without me having to specify each individual Output name from Formatter in the Google Sheet stage? How do i get around this?

 

Secondly - each of those numbers has a status next to it which i also need to extract and add in a secondary column. Am i right in saying i write something to extract the number plus its status, then use formatter to separate the two out?

 

Any help appreciated, i’m a complete beginner

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

1 reply

Troy Tessalone
Userlevel 7
Badge +14

Hi @luke-b 

You may want to consider using a proper app for email parsing such as Maliparser: https://zapier.com/apps/mailparser/integrations#triggers-and-actions

 

Then you can try these options:

GSheets Create Row(s)

 

Looping to handle line items: https://zapier.com/apps/looping/integrations#triggers-and-actions

NOTE: There is a 500 line item limit.

 

Concept of how to create a looping Zap:

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions