Hello
I’m trying to create a scenario in which everytime a save a ticket or invoice in pdf format or jpg, Chat GPT can read it, extract key information and then create a record in Airtable with the expense.
First of all, I have developed the prompt and is working perfectly in Chat GPT. This is the prompt: Read the file {{8.id}} which is an invoice in pdf or jpg format and generate a JSON with the following information:
Issue date
Issuer’s VAT number
Issuing company name
Ticket or invoice number
Concept
Amount excluding VA
VAT rate (%
VAT
Total amount
The date must be in DD.MM.YYYYY format.
The amounts only with the decimals you do not have to separate the thousands, except the VAT rate (%) that goes without decimals. Decimals are indicated with a comma.
My make scenario is as follow:
Watch files in Drive folder
Download the file
Upload the file with ChatGPT (Purpose: assistant)
Read the file and extract the information in JSON. Role: System.
The 4th step is failing. At the beginning it said it could not perform that kind of task, but now the output is zero.
The next step will be to create the record in Airtable, but I’m still struggling with the 4th step.
Anyone can give me a clue?
I can share my scenario if needed.
Thanks and best regards
Ok, so it seems to quite worked, but I received this message as output:
“Sorry for any misunderstanding, but as a language AI model, I do not have the ability to access external files or read PDF or JPG documents. However, I could show you an example that will represent what your JSON output will look like.”
So what I don’t understand that the prompt works when I use it in chatgpt but not in Make.
Thanks again
@Natalia_Grech intenta creando un asistente en el API de OpenAI y dale las instrucciones al asistente para que haga lo que le pides.
mira este ejemplo:
I just wanted to let you know that I translated your question to English since that’s the official language of the community. By keeping the content in one language, we give everybody the chance to step in and help you.
Translation:
Try creating an assistant in the OpenAI API and give instructions to the assistant to do what you ask. Look at this example:
Note: Please read our Code of conduct and get familiar with the rules and guidelines that apply here in our community. This way we keep the community organized and neat for everybody.
Hi @Rafael_Sanchez
Where did you find the assistant? I don’t get any as options.
Do you have to create it first as a GPT?
Thanks for your help.
Best regards
Hi @Rafael_Sanchez
I figured out how to create the assistant with the API, but I still get the same answer: It cannot process a pdf.
Thanks anyway.
Best regards
As for the files, you can check the uploaded files here https://platform.openai.com/files/
but the problem is that when we upload them with make it seem it’s not uploading properly the file
Someone here has done something with base64 for images, but it doesn’t seem to work on my end
If you upload the file by hand and not via Make, you will see that you can read the pdf file.
It’s just that when you upload it with make it gets corrupted. (at least on my side, but maybe I’m using the Upload File module incorrectly)
Can you show me a screenshot of your OpenAi Upload File module ? (in step 3. Upload the file with ChatGPT (Purpose: assistant))
@Natalia_Grech I saw the messages and you can do a couple of things.
if you want to read the PDF and are open to semi semi-automation scenario you could create a GPT that reads your PDF and then sends the information to a webhook and processes the information in integromat.
Another method is to create an assistant and you could use an “Upload file” module from ChatGPT, then use the file ID, and pass that ID to the assistant just like I show in my last picture.
please DM me for quick assistance on how to do it.
Hello @vendy ok, I saw that @Natalia_Grech is giving instructions in Spanish and i assumed she may be a Spanish speaker, but you’re correct, I’ll keep communication in English
I saw that