How to compare two sheets and find difference with AI

[Frederik_Nielsen]

Hi all

I just started using n8n, so I am super rookie, with only a few days of learning the tool.

I am in a situation that I want to make a tool that can compare two sheets with each other and point out the differences of the sheets, but I am not sure how to structure it, or if it’s even possible.

let us take an example that are similar to the issue I am trying to solve:
I have two differenet data sheets in google sheet.

sheet 1 = is my actual bank transaction, that are in my bank.
Sheet 2 = my bookkeeping in my accounting software.

I want to some how be able to ask the AI for similarities and remove those rows so I am only left with the differences, so I know which one to bookkeep.

How would you structure it? or do you have any videos or places I can go to

[darrell_tw]

Here is a simple version

You might need to change the prompt and output format from AI but the main workflow might be quite the same.

[Frederik_Nielsen]

Thank you so much, this is golden for me, to go forward🙌

[darrell_tw]

Glad it helps

You can help to mark this as solution and it’s a big help to me.

[Frederik_Nielsen]

Cool, I did
One more question:
the reason for you in the second step you put in the “no operation, do nothing” after the trigger? can that be removed or why is it there? I was just wondering

[darrell_tw]

Yeah you can remove it.

I just make it more easy to control from Trigger.