Skip to main content
Best answer

How can I extract data from email and send to a google sheet?

  • December 20, 2021
  • 3 replies
  • 1309 views

Hi, how can I extract data from the body of an email and send it to a google sheet? At the moment I have connected two apps: (1) Email by Zapier and (2) google sheet

(1) Here I sent an email automatically forwarded by siteground webmail

(2) This is where I should extrapolate the data from the mail (1) and insert them divided by columns in the google sheet

(1) the email will contain these entries that will be dynamically filled in with lead data, for example: Name: {example1} - IP: {remote_ip} - Address {address}

 

finally, how can I individually extrapolate these entries from the body of the email? I hope I have explained myself well. Thank you in advance

Best answer by mzsadiekBest answer by mzsadiek

Hi @TR2A! I would advise you to use ‘Parser by Zapier’ for this.

First, you can set up an email address within ‘Parser by Zapier’ to forward your emails. Make sure the emails are sent in this format:

name(example)
IP(remote IP)
Addres(abc)

Then, set up a Zap with ‘Parser by Zapier’ as the trigger, and choose the ‘New Email’ trigger. You will then find that it recognizes the values in your email as separate values (name, IP, address, etc.).
I hope this helps!

​​​​​​​

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

mzsadiek
Forum|alt.badge.img+5
  • Zapier Expert
  • 89 replies
  • Answer
  • December 20, 2021

Hi @TR2A! I would advise you to use ‘Parser by Zapier’ for this.

First, you can set up an email address within ‘Parser by Zapier’ to forward your emails. Make sure the emails are sent in this format:

name(example)
IP(remote IP)
Addres(abc)

Then, set up a Zap with ‘Parser by Zapier’ as the trigger, and choose the ‘New Email’ trigger. You will then find that it recognizes the values in your email as separate values (name, IP, address, etc.).
I hope this helps!

​​​​​​​


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30916 replies
  • December 20, 2021

Hi @TR2A 

I’d recommend using Mailparser to parse emails as it’s much more robust and reliable than Parser by Zapier: https://zapier.com/apps/mailparser/integrations#triggers-and-actions

 

A custom Code step can be used to parse emails as well: https://zapier.com/apps/code/help


  • Author
  • New
  • 1 reply
  • December 21, 2021
mzsadiek wrote:

Hi @TR2A! I would advise you to use ‘Parser by Zapier’ for this.

First, you can set up an email address within ‘Parser by Zapier’ to forward your emails. Make sure the emails are sent in this format:

name(example)
IP(remote IP)
Addres(abc)

Then, set up a Zap with ‘Parser by Zapier’ as the trigger, and choose the ‘New Email’ trigger. You will then find that it recognizes the values in your email as separate values (name, IP, address, etc.).
I hope this helps!

 

 Thank you, I'll do so

 

Troy Tessalone wrote:

Hi @TR2A 

I’d recommend using Mailparser to parse emails as it’s much more robust and reliable than Parser by Zapier: https://zapier.com/apps/mailparser/integrations#triggers-and-actions

 

A custom Code step can be used to parse emails as well: https://zapier.com/apps/code/help

 

Thanks Troy, I use siteground webmail (business reasons). But I consider your solution for future projects.