Any suggestions how to get text from CSV spreadsheet file?

[Bananajuice2002]

Hi,

I’m looking for a solution that allows me to extract data from my spreadsheet (CSV or PDF), structure it using OpenAI, and send it to my agent in a specific format.

The challenge I’m facing is accessing the file after uploading it to Google Drive. I have both shareable and export links, but OpenAI doesn’t seem to be able to read them directly. I’m having trouble accessing the contents of the file programmatically and extracting the text.

Do you have any suggestions or best practices for handling this?

Thanks,

 

[Preeti Paryani]

Hello @Bananajuice2002,

You may try using this action, it might help.

 

[Fagun Shah]

Hi,

I’m looking for a solution that allows me to extract data from my spreadsheet (CSV or PDF), structure it using OpenAI, and send it to my agent in a specific format.

The challenge I’m facing is accessing the file after uploading it to Google Drive. I have both shareable and export links, but OpenAI doesn’t seem to be able to read them directly. I’m having trouble accessing the contents of the file programmatically and extracting the text.

Do you have any suggestions or best practices for handling this?

Thanks,

Use this action to uploadgdrive file and get a url for 20-min, which should work with OpenAI

 

[Bananajuice2002]

Hey guys,

I've changed my approach, and what I’m struggling with now is how to retrieve all the records from my Airtable database, clean them up, and send the data to OpenAI in a structured format.

The problem is the character length — it’s too long.

Do you have any suggestions for an intermediary step that can extract text from only specific columns, rather than all of them? I'm expecting up to 450 records max.

I’d prefer not to use an iterator because I don’t want to make 450 separate API calls to OpenAI. I need to generate a single, full document since I’m creating a knowledge base for my agent in ElevenLabs.

 

[Bananajuice2002]

HERE IS THE WORKFLOW: https://connect.pabbly.com/workflow...NVG4JHVVRUAZUJ1ZMUX1SUVctVBkGfQJbDD9bBQUtAGE#