Retrieve table data in gmail

Questions
1

hello everyone. How do i get a table data in gmail forwarded message? i used gmail trigger and gmail get message node then i want to convert the table data to json. how will i do it?

here’s an example table data in gmail forwarded messgae:

image
image783×119 4.94 KB

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

Hello! I wanna know if is it possible to grab a data specifically a table from email to n8n? if so, how can i do it? thank you.

4

Absolutely. Depending on the structure of the email, you might be able to achieve this using the ‘Extract HTML content’ option from the HTML node, or - a bit more hardcore - use a regular expression to parse the email and grab the data you need.

5

it seems that gmail node only reads the details of the person who forwarded it. not the actual forwarded message…

6

You need to disable the ‘simplify’ option in the Gmail/get message node:

image
image376×485 15.3 KB

7

oohhh! i see. thank you!