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.

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

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

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:

 

Terms & Conditions