Hello,
I’m working on my first workflow and need some help on the part I’m on. I have an AI Chat agent set up, where I can upload files from. I uploaded the files and the agent can see them, but when I asked it to compare all the files and then tell me which cells and their data changed, it says it can’t do that. These are excel files that were started as a template, they have multiple tabs but 95% of the file shouldn’t change. The excel file is used to price out material costs for different projects. Any suggestions on how best to do this? I could have upwards of 30 excel sheets. My initial request is to tell me which cells changed, but then I’d want to ask it what is the lowest/highest/average price for the material costs that changed and would like it to create a list with that. Thank you!
Hey, did you try using sheet?
Ive used sheet before to import rows and get the cells I want, but never with excel files. since the ai wont read the files, but with sheets it will turn it into a json data then work with it.
Thanks for the response, since these are going to be excel files, I’ll want to try and make this work with them. Is there a reason why it can’t actually open and read the files natively? I feel like when I messed around with Copilot Studio, it was able to look at my files and give me some feedback on them. I was thinking I could do something similar with n8n. Thanks again!
AI Chat agents can’t natively parse excel files, they only see file metadata or raw text representations. So you have to turn the excel file to json then structure the data well to be compared, then give to the ai agent to analyze it. It works differently than work on ai platform like chatgpt where you can upload your file, cuz they do that in the backend then give the data to their ai server.