Q: I have a sheet with 100 rows and 20 columns.
I have a GPT formula in 10 columns. If I add data, 1000 GPT formulas will run. What does your tool do to avoid timeouts, throttling of requests, and retries for failed requests?
Yaro_DocGPT_AI
May 15, 2024A: Hi buddy!
- The current add-on (GPT, Gemini, Claude, Mistral for Sheets, by docgpt.ai) makes direct call from formular without any middle software. So it is the fastest way to generate response from AI.
- To refresh failed formals - you can just refresh the page and Google Sheets will re-request them. (if you dont replaced AI functions with result - using built-in buttons for that inside the add-on)
There is no any limitations to count requests per minute/day/month from side add-on.
Limitation only exist from OpenAI side or another AI model that you are going to use.
If we are talking about GPT, there are limits based on your Tier, that depends on how long the account exist, how much did you spent.
There are some other plans that use my enterprise key, where the maximum Tier and lowest limitations. It is connected to other plans that has subscription .
Feel free to ask anything else
BjornPLUS
Verified purchaser
Thanks for the clarification! Are there any plans for some functionality like a "safe mode" that will run until all requests are successfull, and avoids most timeouts / bypasses the 30-second runtime limit for custom functions in Google Sheets / and automatically throttles openai to avoid timeouts etc
"bypasses the 30-second runtime limit for custom" - it is restriction from Google Sheets platform, that we cannot manage.
Probably it could be resolved by custom buttons like:
0. "Replace successfully executed functions"
1. "Recalculate error cells"
But be aware there are restrictions from AI vendor providers also. So probably you will need to use diff accounts with max tier.