Weekly report to take into account previously generated reports

[Andres_Olivares]

The problem/error/question

I am generating a weekly report and every new week, I want to feed the reports from previous weeks as context to the GPT -node

Please share your workflow

Information on your n8n setup

• n8n version: 2.11
• Database (default: SQLite): SQLite
• Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud

Thanks a lot in advance!

[Parintele_Damaskin]

Love this gif…

Anyway, you can achieve that in 2 simple ways:

1. AFTER generating your report, save SOMEWHERE internal/external (Data Tables, Sheets, any DB) using the respective node, and BEFORE the Ai agent a node to “feed” from that DB.
2. Or use an AI agent with memory(possible RAG as well), and instruct in system prompt what you want to achieve(format , timebased etc…).

[Andres_Olivares]

Thanks a lot!! I like the second option, do you know of any guides to do that within n8n??? Or do I need to use an external tool? Thanks!

[Parintele_Damaskin]

Hey @Andres_Olivares , once I get to PC, I will take a look at your workflow (it didn’t see it in first time… or maybe you just attached it).

BTW, the 2nd option it needs extra skills since the setup is not just “plug & play” and usually is used with “general” information , and the 1st option is just “feeding” directly the report/report or summary of them(and the data is fresh and fixed)

[Andres_Olivares]

Thanks! No rush! Fair! I am confortable with additional configurations, specially if I can follow a guide haha but agree first option might be “"easier”” I just find it more static thanks!

[Parintele_Damaskin]

Hey @Andres_Olivares !

Here is a summary that uses a conbination of multiple ways to fetch/save, and and make the AI “aware” of what he/you have done.

This isa good starting point, and it covers all your needs(you have to check the report format you wanna save).

Cheers !

[Andres_Olivares]

amazing thanks a TON! I will review it and see if I can make it work!