Parse pdf file using chatgpt and upload the parsed file to one drive/ google drive

Questions & Answers
, ,
1

Sorry, this is going to be a long post. Please bear with me :nerd_face:

I want to parse multiple pdf files which contain tabular data using chatgpt and put it into an excel sheet. All pdfs are different from each other and hence i cannot specify the column names that I want to extract. All i want to do is get the table from each pdf file into an excel sheet. This my first time using make. The closest solution i came across was this and i tried to follow it. However I am not entirely sure I am doing it correctly.

I am using one drive to store my files but it isn’t mandatory. I can even use google drive.

Here’s the flow:

image
image1819Ă—452 82.4 KB

  1. Onedrive: Watch files by update time

    image
    image1071Ă—847 82.7 KB

  2. Onedrive: Download file (Not sure about this step because i need to select one specific file which does not help my case when there are multiple files that i want to parse)

    image
    image1410Ă—849 99 KB

  3. OpenAI: Upload a file

    image
    image1028Ă—774 94 KB

  4. OpenAI: Message an assistant

    image
    image997Ă—868 109 KB

image
image828Ă—865 82.7 KB

  1. OpenAI: Create a completion (Not sure if this is the correct step)

    image
    image880Ă—860 87.1 KB

    image
    image850Ă—859 79.7 KB

  2. Stuck here. If chatgpt can really return downloadable excel files then i wish to download it and upload it to my one drive folder. If it cannot return downloadable files then i want to retrieve the parse content and upload it to a google sheet.

I dont know how to proceed further. Please help

2

Welcome to the Make community!

You need to select “Knowledge Retrieval” for the assistant to be able to access files.

Screenshot_2024-03-06_150352

Additional fees apply.

1 Like
3

Hey!
When i did that, it took a very long time to execute. I got time out error. My pdf file is not too big. It is just 1 page

Also, I didn’t get it. Additional fees apply for what?

4

Fees apply for using the “Retrieval” function on OpenAI.

2 Likes
5

Ohh okay.
I made the changes you suggested. I ticked knowledge retrieval.
Can you please tell me how can i transfer my parsed data that i receive from chatgpt to a google sheet? or if chatgpt can directly provide a downloadable file, i’d like to upload it directly to my one drive

1 Like