Host Spreadsheet on OpenAI and make Assistant analyse it

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:
Zrzut ekranu 2024-07-24 o 01.35.54

Or specify files for code interpreter here:

Zrzut ekranu 2024-07-24 o 01.36.51

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!