Do you have any suggestion to overcome the Google Drive shared drive 400k files limitation?

rclone mount provides random access for reads.
optional support for random access writes, as long as the cached file is still local in the vfs file cache.
once the file is uploaded, random writes is not possible.

how about rclone rcat
https://forum.rclone.org/t/uploading-to-remote-and-calculating-local-md5sum-on-the-fly/29783/15

and there is a new compress remote