When fetching random messages from google sheets, all messages longer than 80 characters, are not being displayed through the bot - send a message service, the data is being fetched, as I can see it in the output in the logs.
Any message less than 80 characters is being displayed normally.
Any ideas as to why is this happening ?
Thank you 
Hi there,
Messenger does have a character limit on the messages but the message would normally be seen as multiple messages within the chat.
Are you not seeing your messages split up?
Hi Kellsey,
A message of any length would be successfuly displayed in messenger if it was written directly there, but when I get a message that is more than 80 characters from google sheets, nothing is displayed.
I’ve tested this with a cell that contained 173 characters and it’s worked fine so perhaps it’s the reference that’s the problem.
Please, can you share with me what you are using for the Google Sheets output? And can you confirm which Google Sheets task you are using to get the data? Is it the Search or List Rows?
For the google sheets output im using the folowing:
{{google_sheets_search_rows_fetch_data.results_+_gsx:replyorders}}
And i’m using the Search Rows, as I want a randomized selection of the data from google sheets.
Hi,
Are you getting an error in your logs saying that the message can’t be blank?
Hi kellsey,
I just tried deleting the sheet and creating a new one, the issue has been resolved and now the messages appear in full, I think the issue might have been from google sheets.
Thank you for your help, and sorry, as the first thing I should have done, is to check if the problem was from google sheets.
