Parsing Data from a Table in an Email to Google Sheets

Questions
1

Hey,

I want to parse a data table with multiple rows/columns from an email html to google sheets.

Describe the problem/error/question

The current output will only enable me to map the data to one row of the google sheet, not multiple rows.

What is the error message (if any)?

No error message

Please share your workflow

Schedule Trigger
Get Many Messages - Gmail
Ai Agent with OpenAi Chat Model and Output parser (following an example JSON)

Share the output returned by the last node

This is the output from the AI bot.

[
{
“output”: [
{
“DROPPED_BY”: “email 1”,
“task 1”: 0,
“task 2”: 15,
“task 3”: 0,
“task 4”: 0,
},
{
“DROPPED_BY”: “email 2”,
“task 1”: 0,
“task 2”: 24,
“task 3”: 0,
“task 4”: 0,
}
}
]

Information on your n8n setup

  • **n8n version:
  • **Database (default: SQLite):
  • **n8n EXECUTIONS_PROCESS setting (default: own, main): own, main
  • **Running n8n via microsoft edge browser
  • **Operating system: macOS Sonoma
2

You can either split this output by output and for each item execute add row to sheet or you can add a sheet tool and instruct your at agent to execute the tool for each row in the found table.

3

Thank you very much. How could I split the data output by output?

4

Like this: