Can’t load CSV file from Google Drive to ChatGPT for analysis in Make scenario

Getting Started
, ,
1

Hi everyone,

I’m still new to Make, and I’m definitely not a developer – so please be gentle with me :sweat_smile: 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 :folded_hands:

image
image1754×277 60.4 KB

image
image1116×686 78.6 KB

image
image1071×1197 111 KB

2

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.