How can i analize big google sheet with Open AI

How To
1

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2025-10-31 115426
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2025-10-31 1154261388Γ—250 30.3 KB
I have a question: I have a table with more than 40,000 rows. I need the gpt chat to analyze everything and then give a final answer. In my scenario, the first Open AI module simply remembers everything, and the next module looks through the thread ID and analyzes, but does not transmit much information (chunk text).

1 Like
3

Hi Vladimir, I see what’s happening OpenAI in Make.com can’t process 40,000+ rows at once because of token limits. The best fix is to split your data into smaller chunks (e.g., 500–1,000 rows), summarize each chunk with OpenAI, and then combine those summaries for one final analysis.

4

No self promotion in posts mate.

1 Like
5

Okay will take care for the next time.

6

Hi @Ussikov_Vladimir_Nik Welcome to the community!

Try to create a file with all those records in csv, upload to assistant and ask it to process the file. if you want to process data in chunks, you can use repeater module to create chunks and process chunks.

adding raw sheet table in text might not be the right choice for bulk rows.

Best,
@Prem_Patel

7

Hi, I tried uploading a CSV file, but it didn’t work. I need the AI ​​to look through the entire huge table containing information on store inventory and then give a short answer about what needs to be moved where. How do I do this?