Upload Data from a Google Sheet to an OpenAI Assistant for One-Time Analysis

How To
,
1

Hello Make Community,

I’m hoping someone has a clever solution for this problem…

I have a Google Sheet that contains a lot of data.

I want to upload this to an OpenAI/ChatGPT “Assistant” for analysis.

The file is only going to be used for this one-time analysis, so I don’t really need to upload it permanently to the assistant (unless that is the only way?).

I saw this other post about using upload a file, but that feels more permanent than what I need.

Is there another way I can feed this spreadsheet data into the assistant to ask questions about the data?

I was thinking maybe I have to save the sheet as a CSV and pass the CSV raw data into the assistant, but that doesn’t feel overly elegant.

Does anyone have any clever ideas?

Thanks in advance!

3

Honestly, if you are just doing this once, you don’t even need Make. Just do it manually, log into ChatGPT, upload and do your prompt. Even if this is via the playground/assistant.

4

Sorry, let me clarify… this will happen once for this specific file.

However the automation (within Make) will happen over and over again with different files.

So, logging in and doing this manually via the ChatGPT web interface won’t work as this is all baked into a broader automation.

5

ah I see. Then just delete the file after use, might need to make an API call, further info here:

https://platform.openai.com/docs/api-reference/vector-stores-files/deleteFile

6

For more information on deleting files from a vector store, see this previous thread Delete files OPEN-AI with API call