Help! Google Drive > Get CSV file - Upload to OpenAI module for analysis. Can't get it to work!

Jayson_Freshton · August 9, 2024, 11:12am

Hi everyone,

Would appreciate any help you could give.

Goal:

I want to periodically drop a CSV file into my google drive
Upload that file to OpenAI (presumable the data store)
With a prompt, ask it to summarise the contents of the CSV file.

Sounds straightforward?

So, I’ve been able to do parts 1 and 2 - it works - the file appears in my data store. Yay!

Problem:

I’ve created an ‘assistant’ in OpenAI (a text prompt telling it to analyse the data).
However, I appear to have no way to reference the file that’s just been uploaded.

I’ve tried a few things, but all I see to get is a response telling me that I need to upload data - it just can’t seem to see the file!

Here’s my simple flow with screenshot. I have tried a few other things, but I fear I’m just not going to be able to figure it out, or my logic is faulty!

Could anyone provide advice on how I achieve the goal? I simply want to somehow push a simple CSV file into OpenAI and for it to be able to see and respond to it based on my prompt.

I’ve searched and searched, but there seems no clear way to do this.

Really appreciate any help you can give.

samliew · August 9, 2024, 12:54pm

You need to use File Search to access the Vector Store that you previously uploaded the file to.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

Jayson_Freshton · August 9, 2024, 1:12pm

Hi Sam, thanks for looking at that. No joy I’m afraid - not really sure which fields/items I should be adding in though. Here’s the error, and the make up of the ‘Message an Assistant’ module:

Edit: Attached Json file if that helps?
blueprint (1).json (17.6 KB)

samliew · August 9, 2024, 1:15pm

File search resources takes in a Vector Store ID, not a File ID.

If you are unsure, don’t use the map option. Manually select the vector store.

Jayson_Freshton · August 9, 2024, 1:24pm

I’ve created a vector store folder call ‘Keyword documents’ - but the assistant can’t find the CSV file that’s been uploaded - as I’ve not been able (at least in the ‘Upload file’ module) to actually tell the automation to put it the file into that particular vector store.