Hey everyone! I’m working on a flow in this Make scenario:
Goal: Download an .XLSX Spreadsheet via Google Drive and Host it on OpenAI so that an Assistant can analyze the data in this spreadsheet.
I could managed to do it correctly the following: Download the Spreadsheet and Upload it to OpenAI
I’m having trouble getting my Assistant to read this recently hosted file. I can’t find a way to create this connection.
How can I make the Assistant have access to this file and answer the command I gave in the Prompt?
I hope someone can help me do this correctly.
Hi,
Welcome to the Make Community!
Please refer to OpenAI documentation here:
Step 2: Upload files and add them to a Vector Store. To access your files, the file_search tool uses the Vector Store object. Upload your files and create a Vector Store to contain them. Once the Vector Store is created, you should poll its status until all files are out of the in_progress state to ensure that all content has finished processing. The SDK provides helpers for uploading and polling in one shot.
You can set up VS ID here:

Or specify files for code interpreter here:

Both options are available when you switch “Show advanced settings” to on.
Please also take a look on this topic- it should help you
Have a nice day!