I’m trying to extract data from a pdf invoice and send it to a Google Sheet. I need to fill 5 basic fields, Customer, Supplier, Total amount, invoice number and invoice date. I’m currently using Gemini to extract those fields and it detects all of them with little to no error except for the date, which I can’t get right at all. It just gives a random date that its not even on the PDF. If i take that same invoice and upload it manualy to chatgpt or Gemini (using the same version. I tried 2.0 flash, 2.5 flash, 2.0 pro, 2.5pro and 1.5) it gives the correct date, so i dont understand why doing it though Make I get a different answer. To avoid format problems because my invoices usually have the spanish date format, now im only trying to extrat the year and still having problems.
My scenario looks like this:
As you can see, the output, in ‘FechaFactura’ it says 2023 where it sould say 2025. there its not a single date in the whole pdf that says 2023.
Sorry for my bad english and I hope anyone know how to correct this.