Why is my Google Sheets text getting truncated when sent to ChatGPT?
Hi,
I have a long text inside a cell in google spreadsheet.
But when I run a GPT action, the text gets truncated.
Here is the output of the action, you can see it is missing information:
Quiz 1: Due September 18, 2025, at 11:55 PM
Quiz 2: Due October 2, 2025, at 11:55 PM
Quiz 3: Due October 16, 2025, at 11:55 PM
Fall Reading Week: Oct 30 - Nov 5, 2025
Quiz 4: Due November 13, 2025, at 11:55 PM
Quiz 5: Due November 27, 2025, at 11:55 PM
Thanksgiving: October 13, 2025
Midterm Test Information
Midterm 1: Content from Weeks 1 and 2.
Midterm 2: Content from Weeks 3 and 4.
No books, notes, or calculators allowed. Student ID required. Dates & times TBA.
Final Exam Information...
If you need information from a specific section, or want me to look for something specific, just let me know!
You said:
did you display everything?
ChatGPT said:
No, I did not display the entire raw text—I stopped at the “Final Exam Information...” because the result received from the action was cut off (indicated by the ellipsis ...). The raw output I got from Zapier ended there; I did not remove or skip any content.
If there’s more content in your source document, it was not returned in the response due to a size or output limit, or it was truncated by the Zapier action or integration itself.
Can anyone help?
Thanks
LL
Page 1 / 1
Hi @luisalinux
For us to have more info, post screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.
Hi, I configured a custom GPT action,
I am not sure if I can insert the custom GPT action I created inside a zap.(This is a question I have for some time).
So I will send the prints from the configured GPT action and also a similar action inside a zap with some other trigger, so that you can see the fields.
In the zap, It gets the complete output, raw rows, jSON and formatted fields are okay! You can see that it retrieves eveything.
But the information that chat gpt retrieves using the custom action gets truncated. See bellow:
So, the information does no end in Final Exam Information, it has more parts to it that were not retrieved.
I had to use JSON to pass to chatgp in the custom action as you can see in the picture:
I had to used JSON because the other options raw or formatted works fine in the example zap but the result in chat gpt using the custom action does not work. The output is not even truncated, it is three dots ...], so chat gpt gets no information. See bellow..
When I change the custom action to raw or formatted
Chat gpts answers:
Let me know if this is enough information.
thanks,
LL
Actually, I think the GPT action is defective. I tried to run the live Demo and the JSON output gets truncated here. So it is not chat GPT the problem
If I change a formatted or other output then the result is s...]
@luisalinux
I think the root issue is to due context window limits which has max characters limits, thus causing the data to be truncated.
There is a Zap action to try to add: Formatter > Text > Split Text into Chucks for AI Prompts
@luisalinux The concept with splitting large text is like this:
Split text into chunks (array of items)
Loop thru each text iteration
Send to ChatGPT and keep in Memory Key and tell it to wait to continue
Filter for last loop iteration
Tell ChatGPT to do the desired action
@Troy Tessalone Thanks for explaining.
How can I tell the GPT to trigger this action?
I can program this action on the editor (steps 1- 4) but I want to trigger it when my custom gpt perform a call to an action.
Is it possible??
Luisa
Hey @luisalinux
Just came across this and wanted to check whether you were able to make any progress here?
If so, we’d love to hear what the solution was - this would be really helpful to others that might be experiencing similar issues.
And if not, it looks like you might have been using AI Actions which was since deprecated. In which case, I’d recommend exploring Zapier MCP for this instead.
Keep us posted on how you’re getting on, want to make sure you’re all set!