# Parse pdf file using chatgpt and upload the parsed file to one drive/ google drive **URL:** \ **Category:** Beginner Questions\ **Tags:** parse, text-parser, chatgpt\ **Created:** [March 6, 2024, 7:48am UTC](https://community.make.com/t/parse-pdf-file-using-chatgpt-and-upload-the-parsed-file-to-one-drive-google-drive/29658 "2024-03-06T07:48:48Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Ishita\_Joshi](https://avatars.discourse-cdn.com/v4/letter/i/439d5e/32.png) [@Ishita\_Joshi](https://community.make.com/u/Ishita_Joshi)\ **Post date:** [March 6, 2024, 7:48am UTC](https://community.make.com/t/parse-pdf-file-using-chatgpt-and-upload-the-parsed-file-to-one-drive-google-drive/29658/1 "2024-03-06T07:48:48Z")
Sorry, this is going to be a long post. Please bear with me 🤓 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](https://community.make.com/t/create-a-json-out-of-a-pdf-or-jpg-with-chat-gpt/22337) 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](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/8/d8895159da3211d53fbcb222e0beb261091f01e8.png) 1. Onedrive: Watch files by update time 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) 3. OpenAI: Upload a file 4. OpenAI: Message an assistant ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/9/198c9fa37c6214a1a8bb7f754fc1d886fed71ca3.png) 1. OpenAI: Create a completion (Not sure if this is the correct step) 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 ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [March 6, 2024, 9:08am UTC](https://community.make.com/t/parse-pdf-file-using-chatgpt-and-upload-the-parsed-file-to-one-drive-google-drive/29658/2 "2024-03-06T09:08:52Z")
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](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/0/f0b7aec7f39f7476a368a2e7a4a5f3188bced031.png) Additional fees apply. ---
**Author:** ![Ishita\_Joshi](https://avatars.discourse-cdn.com/v4/letter/i/439d5e/32.png) [@Ishita\_Joshi](https://community.make.com/u/Ishita_Joshi)\ **Post date:** [March 6, 2024, 9:42am UTC](https://community.make.com/t/parse-pdf-file-using-chatgpt-and-upload-the-parsed-file-to-one-drive-google-drive/29658/3 "2024-03-06T09:42:27Z")
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? ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [March 6, 2024, 11:00am UTC](https://community.make.com/t/parse-pdf-file-using-chatgpt-and-upload-the-parsed-file-to-one-drive-google-drive/29658/4 "2024-03-06T11:00:44Z")
> [@Ishita\_Joshi](#): > > Additional fees apply for what? Fees apply for using the “Retrieval” function on OpenAI. ---
**Author:** ![Ishita\_Joshi](https://avatars.discourse-cdn.com/v4/letter/i/439d5e/32.png) [@Ishita\_Joshi](https://community.make.com/u/Ishita_Joshi)\ **Post date:** [March 6, 2024, 11:19am UTC](https://community.make.com/t/parse-pdf-file-using-chatgpt-and-upload-the-parsed-file-to-one-drive-google-drive/29658/5 "2024-03-06T11:19:56Z")
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 ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [April 22, 2024, 7:34am UTC](https://community.make.com/t/parse-pdf-file-using-chatgpt-and-upload-the-parsed-file-to-one-drive-google-drive/29658/6 "2024-04-22T07:34:31Z")