PDF to Excel without assistants?

:bullseye: What is your goal?

I want to collect attachments in an email inbox, have OpenAI read them out (here’s where my scenario has failed so far) and format them as an excel file to download.

:thinking: What is the problem & what have you tried?

This seems to have been possible via Message an Assistant. (The Generate a completion module still doesn’t allow to upload files within. Does anyone know if they’re planning to change this?) I can only select GPT3 und GPT4 models in the Assistant tho, which just feedback me that they don’t have the capability to return files. I read that OpenAI is phasing out the Assistants API and want us to move to the Responses API. I cannot find where to interact with that tho. Do I need to make my own API endpoints and use the Make an API call model instead now? Thanks for any help!

Hey there,

reading PDFs is best done with a dedicated PDF OCR app. Something like PDF.co for example, or PDF4me.

Also, you don’t need it to return a file. Just a valid JSON with the data inside. You can then rework that data in a xlsx format.

1 Like