# How can i analize big google sheet with Open AI **URL:** \ **Category:** Questions\ **Tags:** google-sheets\ **Created:** [October 31, 2025, 6:54am UTC](https://community.make.com/t/how-can-i-analize-big-google-sheet-with-open-ai/95214 "2025-10-31T06:54:46Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Ussikov\_Vladimir\_Nik](https://avatars.discourse-cdn.com/v4/letter/u/eb9ed0/32.png) [@Ussikov\_Vladimir\_Nik](https://community.make.com/u/Ussikov_Vladimir_Nik)\ **Post date:** [October 31, 2025, 6:54am UTC](https://community.make.com/t/how-can-i-analize-big-google-sheet-with-open-ai/95214/1 "2025-10-31T06:54:46Z")
![Снимок экрана 2025-10-31 115426](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/9/7974dc6114dc887617c4d5b6ef9c979f60e4e8db.png)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). ---
**Author:** ![Farhan\_Ahmed](https://avatars.discourse-cdn.com/v4/letter/f/b5a626/32.png) [@Farhan\_Ahmed](https://community.make.com/u/Farhan_Ahmed)\ **Post date:** [October 31, 2025, 1:25pm UTC](https://community.make.com/t/how-can-i-analize-big-google-sheet-with-open-ai/95214/3 "2025-10-31T13:25:26Z")
Hi Vladimir, I see what’s happening OpenAI in [Make.com](http://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. ---
**Author:** ![Stoyan\_Vatov](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Stoyan\_Vatov](https://community.make.com/u/Stoyan_Vatov)\ **Post date:** [October 31, 2025, 1:29pm UTC](https://community.make.com/t/how-can-i-analize-big-google-sheet-with-open-ai/95214/4 "2025-10-31T13:29:03Z")
No self promotion in posts mate. ---
**Author:** ![Farhan\_Ahmed](https://avatars.discourse-cdn.com/v4/letter/f/b5a626/32.png) [@Farhan\_Ahmed](https://community.make.com/u/Farhan_Ahmed)\ **Post date:** [October 31, 2025, 2:03pm UTC](https://community.make.com/t/how-can-i-analize-big-google-sheet-with-open-ai/95214/5 "2025-10-31T14:03:52Z")
Okay will take care for the next time. ---
**Author:** ![Prem\_Patel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/prem_patel/32/93657_2.png) [@Prem\_Patel](https://community.make.com/u/Prem_Patel)\ **Post date:** [October 31, 2025, 4:25pm UTC](https://community.make.com/t/how-can-i-analize-big-google-sheet-with-open-ai/95214/6 "2025-10-31T16:25:11Z")
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 ---
**Author:** ![Ussikov\_Vladimir\_Nik](https://avatars.discourse-cdn.com/v4/letter/u/eb9ed0/32.png) [@Ussikov\_Vladimir\_Nik](https://community.make.com/u/Ussikov_Vladimir_Nik)\ **Post date:** [November 6, 2025, 5:01am UTC](https://community.make.com/t/how-can-i-analize-big-google-sheet-with-open-ai/95214/7 "2025-11-06T05:01:13Z")
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? ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [February 4, 2026, 5:12am UTC](https://community.make.com/t/how-can-i-analize-big-google-sheet-with-open-ai/95214/8 "2026-02-04T05:12:03Z")