Scenario - Drive to GPT assistant to google sheets

I am in the process of making a scenario that pulls a pdf file from a google drive sends it to a gpt assistant then pulls the data from that response to a google sheet for easy access. However I am having an issue with the file size limits, does anyone know a work around for this? I got an error in make “The operation failed with an error. [400] Invalid ‘messages[0].content’: string too long. Expected a string with maximum length 32768, but got a string with length 182647 instead” Which I find odd, because if I upload directly into the gpt assistant it has no issue reviewing the document. I also have not gotten to the pulling of info from the gpt to google sheets - If anyone has experience in mapping specific response data from your gpt into various sub headings in google sheets any help would be appreciated. Cheers!

Welcome to the Make community!

This is not a Make issue. You are running into a excel/sheets limitation.

The maximum number of characters in a single cell cannot be more than 32767. The following topic describes Excel limitations in greater detail: Excel specifications and limits

As a workaround, you can split the text into multiple cells.

2 Likes

Hey Samliew,

Thanks for the clarification - I got it to work in the end!

2 Likes

No problem, glad I could help!

1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

others can save time when catching up with the latest activity here, and

  • allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:
Screenshot_2023-10-04_161049

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

2 Likes