Email helper

Questions
1

Hi everyone! I need some help with this automation. The idea is that I recieve a ton of emails and all of them contain excel tables and some info for the table. What I want to do is to extract only specific columns and rows from the table, create a quick summary of the text(message) from the email and then forward it to my team members. However Im having difficulties in excel table(dont know how to filter the data) and the to format the message appropriately. Any suggestions will be appreciated. :slightly_smiling_face:

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

image
image1292×196 29.3 KB

Share the output returned by the last node

image
image1455×415 52.3 KB

Information on your n8n setup

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

Use the AI agent node & do following.

  • Toggle on require specific format

  • Connect a structured output parser besides.

  • Specify the format you want to get from AI agent

    After this your AI will give better structured response

3

So I should swap the OpenAi with Ai agent?

4

May be something like this?

image
image2661×640 52.5 KB

5

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