Skip to content
How to upload data ...
 
Notifications
Clear all

How to upload data from Google Sheets to an OpenAI Assistant for one-time analysis

5 Posts
3 Users
0 Reactions
7 Views
Robert_B
(@robert_b)
Posts: 2
New Member
Topic starter
 

Hello callin.io Community,

I'm hoping someone has a clever solution for this challenge...

I have a Google Sheet with a substantial amount of data.

My goal is to upload this data to an OpenAI/ChatGPT "Assistant" for analysis.

This file is intended solely for this one-time analysis, so I don't necessarily need to upload it permanently to the assistant (unless that's the only feasible method?).

I came across this other post regarding uploading a file, but that seems more permanent than my requirement.

Is there an alternative method to provide this spreadsheet data to the assistant so I can query it?

I considered saving the sheet as a CSV and passing the raw CSV data to the assistant, but that doesn't strike me as particularly elegant.

Does anyone have any insightful ideas?

Thanks in advance!

 
Posted : 17/06/2025 2:26 pm
Mit
 Mit
(@mit)
Posts: 10
Active Member
 

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

 
Posted : 17/06/2025 4:25 pm
Robert_B
(@robert_b)
Posts: 2
New Member
Topic starter
 

Apologies, allow me to elaborate… this action will occur once for this particular file.

However, the automation (within callin.io) will repeat continuously with various files.

Therefore, logging in and performing this manually through the ChatGPT web interface will not be effective, as this is all integrated into a larger automation.

 
Posted : 17/06/2025 4:37 pm
Mit
 Mit
(@mit)
Posts: 10
Active Member
 

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

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

 
Posted : 18/06/2025 8:26 am
samliew
(@samliew)
Posts: 293
Reputable Member
 

For more information on deleting files from a vector store, please refer to this previous discussion: Delete files OPEN-AI with API call

 
Posted : 18/06/2025 8:56 am
Share: