Hi everyone,
I’m still new to Make, and I’m definitely not a developer – so please be gentle with me 
I honestly thought uploading a CSV file for analysis would be much simpler, and now I’m realizing there’s more to it than I expected.
I’m trying to build a scenario where a CSV file stored on Google Drive is analyzed by ChatGPT. The goal is for the agent to read the file, extract specific rows based on defined criteria, and generate a text summary that will then be saved back to Google Drive as a .txt file.
Unfortunately, I’m stuck at the point where I successfully locate the CSV file in Google Drive, but I can’t seem to pass its content properly to the ChatGPT module. The file is found and shown in the scenario, but ChatGPT doesn’t analyze it – it either returns an error or acts like the file is empty or inaccessible.
Has anyone managed to pass a CSV file’s content from Google Drive into the ChatGPT module for processing? What’s the best way to load the actual file content into ChatGPT via Make?
Any help would be greatly appreciated!
Thanks in advance 
Hey there,
can you show the error message you are getting?
Usually for an Assistant to access a file, you need to add it to that Assistant’s vector store.
Hey, thanks for the reply!
Here’s what’s happening:
I’m using the ChatGPT (OpenAI Assistant) module in Make. In my workflow, I use a Google Drive module to select the correct CSV file and pass it along to the ChatGPT module. The file is located and passed forward – I can confirm that.
The ChatGPT module receives the prompt correctly, but it doesn’t seem to recognize or process the attached file. I’ve tried passing various file properties into the prompt (like File ID, Object, and File Name) – but none of these worked. The assistant just responds to the prompt as if no file was ever attached.
Here’s the result I get from the ChatGPT module:
“To help you identify the most promising keywords for optimization, I need more information about the report you mentioned. Unfortunately, as an artificial intelligence, I don’t have direct access to external files or the ability to view report contents based on identifiers.”
It seems like ChatGPT just ignores the file and gives a general reply to the prompt.
To be honest, I’m still new to Make and I’m definitely not a developer – so please be gentle with me I’ve managed to set up everything else in the scenario, but this part totally overwhelmed me. I don’t know what a “vector store” is or how to use it here. Also – could it be that I should set the role as “user” instead of “assistant” when using the ChatGPT module?
Could you walk me through how to configure this step by step?
I’d really appreciate the help – thanks so much in advance
Yeah uploading the file is not enough. When you have an assistant setup you need to give it access to a specific vector store. Then add the file to that vector store so the assistant can access it.
