How to extract information in html from a gmail email?

Questions
1

Hello!
Gmail receives notifications of transfers. I need to take information from these emails and save it in a Google Drive spreadsheet. I use a first node (Gmail Trigger) and get HTML as the output. All the information is in the same HTML field. One of the pieces of information I need to extract is the transferred amount, which I should be able to extract from here (in this case: $10000.00):

… <tr height="30px;"style=“border-bottom:1px solid #ccc;margin-top:10px;margin-bottom:10px”> Importe $ 100000.00 <tr height="30px;"style=“border-bottom:1px solid #ccc;margin-top:10px;margin-bottom:10px;”> …

I don’t know which node to use or how to configure it. Could someone help me?
I’m using n8n on the web
Thanks

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hi @Pablo_Carranza ,

You could use an expression to select for the characters between the Importe word and the < character after the value.

Something like this:

Let us know how you get on! :dizzy:

1 Like
4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.