Skip to main content

I am trying to send the result of a ChatGPT query to a Notion database page. The ChatGPT text is over 2,000 characters, so I’ve inserted “!!!” every 1,000 characters (just to be safe) so that Zapier’s text splitter can split it into chunks. I have spent hours trying to get Zapier to loop through the chunks and send the output to Notion, but I haven’t had any luck. Have any of you been able to do this?

 

 

Hi ​@FrotSkyman 

Help us have more context by posting screenshots showing how your Zap steps are configured in EDIT mode with the field mappings visible.

 


Thanks for responding. Here are the details of those three steps. Note that I have tried several different ideas of what to include in the “Values to Loop” field. 

 

Here is an excerpt from the output of step 5:

And here are the details of steps 5, 6, and 7:

 


@FrotSkyman 

Notion rich text object fields have a 2,000 character limit, so Looping smaller chunks won’t solve for that.

 

Notion help: https://developers.notion.com/reference/request-limits


 


As I stated earlier, I’m aware of the 2000 character limit. I was hoping that the looping trigger would let me send the text to it in smaller increments. According to the way, it is supposed to work, it continues to repeat the steps each time through the loop. So I would send the first 1000 characters in Notion, it would loop and grab the next 1000 characters, send that to notion, etc. That’s what I’m trying to make work.


@FrotSkyman 

This is a Notion limitation, not a Zapier limitation.

For the Notion Item, the Content text field has a 2,000 character limit.

 

e.g. If you are trying to send a total of 3,000 characters to Notion Item for the Content field, then Notion will return an error because 3,000 characters is greater than the 2,000 character limit, regardless of whether you are trying to send in smaller text chunks.

 

Also, Looping iterations run in parallel, so you would have to add more Zap steps to configure logic to do sequential looping and find/append the text to the Content fields, assuming this would keep you under the 2,000 character limit of text fields in Notion Items.

 

You can add a Formatter > Text > Truncate step to the Zap to truncate the response from ChatGPT to 2,000 characters.

 

 


Got it. Thanks for everyone’s help!


Wow! Thank you for confirming the resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.


Just to be clear, I’m not able to use this zap. I can’t shrink my responses to 2000 characters. So it’s manual copy and paste unfortunately.


Hi ​@FrotSkyman,

 

We do apologize for any inconvenience. There are a few workarounds if you're facing issues with a 2000-character limit in your Zap. You can split the text into smaller chunks using Zapier's "Formatter" with the "Split Text" operation, though this will send multiple messages. Alternatively, store the text in an external service like Dropbox or Google Drive and send a link instead. You can shorten the text using the "Truncate" operation in Zapier's Formatter.

 

Let us know if you have any further questions. Looking forward to your response.
 


My original question was how do I split the text into 2000 character segments and send those to Notion. I understand that Notion has a 2000 character limit. I thought I could do it with looping sending 2000 characters a time to Notion. The messages in this chat say that it is not possible. If there is a way to do it, I would love to know. Thank you.


Hi ​@FrotSkyman,

 

I understand you're looking to split a text into 2000-character segments and send those to Notion due to its character limit. While Zapier doesn't have a built-in function for text splitting, you can use a Code by Zapier action to achieve this. You may seek assistance from our Zapier Experts with Codes since that will be an advanced task.


@JammerS If you believe that you can code around the 2,000 character limitation of the Notion API, I would love to speak with your Zapier Experts. Please let me know how best to connect with them.


Hi ​@FrotSkyman,

 

You can reach our Zapier experts here on this link: https://zapier.com/experts

 


Thanks, ​@JammerS 


Reply