Translate long documents with ChatGPT and Gemini

“Anytime a new text document is dropped to the folder in Google Drive, the text is divided in chunks, based on the approximate number of characters and the sentence limit around the limit, several request are sent to Gemini Pro 2.0 and GPT4o models. The result is saved in a Google spreadsheet - chunk after chunk. Such a process allows avoiding the single request limitations of LLMs in case the original document is very long. ”