You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a sheet with a huge number of character that I want to translate it. Escpecially I have 34.000.000 pcs character in my sheet. I just set up the DeepL API and put the DeepL translate function all of the cells. Since Monday DeepL function is still loading and I dont see any succesfull translated charachter in my sheet. But I see a lot of fault message "Service invoked too many times for one day: urlfetch"
Yes I know this is a huge number of characters, but I didnt know how the API will handle it.
What should I do to translate my huge number of character? Could you help me please?
Thanks!
The text was updated successfully, but these errors were encountered:
Hi, the error you're seeing means you're making too many HTTP requests and Google is in essence rate-limiting you (see here).
If you want to translate a big table like this, I would recommend to do it in steps, and not all cells at once (and wait until each set of cells is completed before starting the next one). Please note that a single cell can at most have in the order of 120k characters and still be translated successfully (as the maximum request size is 128kB, see docs)
If this is not a one-off job, I would strongly recommend using the API itself programmatically to achieve this. We have SDKs for various programming languages on this GitHub, this GSheets integration is just an example project of what you can build with the DeepL API, and we don't fully support it.
Edit: Also, the API can't yet handle huge requests, so if you didn't get a response within a minute, it's fair to assume the request just failed. No need to wait for hours.
Hello all,
I have a sheet with a huge number of character that I want to translate it. Escpecially I have 34.000.000 pcs character in my sheet. I just set up the DeepL API and put the DeepL translate function all of the cells. Since Monday DeepL function is still loading and I dont see any succesfull translated charachter in my sheet. But I see a lot of fault message "Service invoked too many times for one day: urlfetch"
Yes I know this is a huge number of characters, but I didnt know how the API will handle it.
What should I do to translate my huge number of character? Could you help me please?
Thanks!
The text was updated successfully, but these errors were encountered: