Best answer

Parse an email in Gmail to create rows in Google Sheets

  • 2 June 2021
  • 2 replies
  • 124 views

Hello,

 

I would like to know if, for example, when I receive an e-mail in Gmail with some data from a person (name, surname, address, phone, e-mail), I can create a Google Sheets sheet that has those headers (name , surnames ...) and include the data in each corresponding cell.
I receive the data in the body of the email separated by "/" for example: name / surname / address / telephone
Could this be done? What would be the best way to configure it?

I have also tried to see if I can do it from Email Parser by Zapier

 

Thanks in advance.

icon

Best answer by robschmidt 2 June 2021, 13:35

View original

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

2 replies

Userlevel 7
Badge +9

Hi @Inka 

Email Parser by Zapier is the right app that you can use to extract the data out of an email. Check out it’s tutorial here: https://parser.zapier.com/

If you feel like Email Parser by Zapier isn’t doing a good job, you can consider using this professional grade tool to extract data: https://mailparser.io/

Additionally, you can also use direct gmail trigger and formatter>split (by ‘/’) to get the data. Although, stability may suffer when using this method.

Hi @robschmidt

it took me a bit until I identified each field correctly, but I think I have succeeded.

At least I already know how this works and it is already testing and changing.

 

Thank you very much for your help.