Why is my Google Sheets text getting truncated when sent to ChatGPT?

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 [...]

 

​@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

You can try opening a ticket with Zapier Support for additional troubleshooting: https://zapier.com/app/get-help

But how could I configure this using a GPT action? 

Can I configure chat GPT actions inside the zap editor? 

Thanks, 

LL

​@luisalinux 

If you are trying to use a Zap, review the available ChatGPT/OpenAI Zap app triggers/actions: https://zapier.com/apps/chatgpt/integrations#triggers-and-actions

​@luisalinux 
The concept with splitting large text is like this:

1. Split text into chunks (array of items)
2. Loop thru each text iteration
3. Send to ChatGPT and keep in Memory Key and tell it to wait to continue
4. Filter for last loop iteration
5. 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!