Parse an email in Gmail to create rows in Google Sheets

Question

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.

robschmidt · Accepted Answer

Hi @InkaEmail 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 likeEmail 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.

Inka · Answer

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

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded