We need solutions for handling large file downloads from G-Drive.

We are developing a process where Bot 1 generates an output that the business team must review and potentially adjust. Once updated, Bot 2 needs to download that specific file (approx 50-60 MB) from Google Drive to use as its input. Because this involves dynamic business updates, the previous workaround of using a static file in the Control Room is no longer viable.

P.S - The source files are standard .xlsx workbooks. However, they include embedded logic, formulas, and validation constraints.

Regarding the suggestion to use REST Web APIs for downloading these files, we have already attempted that approach. That also did not support as the resources (Gemini and ChatGPT) claim Google API for get method has the limitation only upto file size of 10 MB.

Please let us know if there are any other recommended strategies or if we can expedite a more permanent solution for handling large file downloads from G-Drive.