Best answer

From Gmail to spreadsheet

  • 10 October 2020
  • 3 replies
  • 93 views

Userlevel 1

Hi,

I created an automation that send my data from received email in Gmail to a spreadsheet creating a new row.

 

Now I would like to select certain piece of gmail html and not the whole body of the email for ex.

How can I do it?

Thanks

icon

Best answer by nicksimard 14 October 2020, 02:29

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.

3 replies

Userlevel 7
Badge +14

Options:

  1. Formatter:https://zapier.com/apps/formatter/integrations 
  2. Parser: https://zapier.com/apps/email-parser/integrations
  3. Code: https://zapier.com/apps/code/integrations
Userlevel 1

Hi Troy, thanks for the answer.

Can you tell me the spet by step procedure please?

In the body of the email i have: 

From name: Mario Rossi From email: [xxx@gmail.com] 

and I want this data to be sent to a spreadsheet

Thanks a lot in advance

Userlevel 7
Badge +11

Hi @etksy!

In this case, I think your best bet is to use an email parser (like this one by Zapier: https://zapier.com/apps/email-parser/integrations).

You have those emails forwarded to the parser, you indicate which parts you want to extract and then on later steps of your Zap you can map those into fields.

More info on the Email Parser: https://zapier.com/help/create/email-and-text-messages/set-up-your-email-parser-account-in-zapier

It’s not super straightforward to use email parsers, so make sure you read those help docs carefully (there’s a video as well).