transfer huge data from 1 cloud service to another

The best option would be to have the folder or stuff sinking for offline access from onedrive then you copy it / move it to google drive but you'd have to have it downloaded / download it anyway.There are say, automated or third party services that do what you want per this article,
https://www.techbloat.com/how-to-transfer-files-from-onedrive-to-google-drive.html
But tbh i'd still probably recommend the manual approach.
As far as the third par services that do this, this is straight from the article linked above but this is regarding the third party services, at least, one of them.
3. Using Third-Party Cloud Migration Tools
Several specialized tools simplify cloud-to-cloud migration, especially for large datasets or enterprise needs.
Some popular tools include:
MultCloud
CloudFuze
Mover.io (by Microsoft)
CloudHQ
Example: Using MultCloud
MultCloud is a cloud management platform that supports multiple services, including OneDrive and Google Drive.
Steps:
Create an Account on MultCloud.
Add Cloud Accounts:
Sign in to your OneDrive and Google Drive accounts within MultCloud.
Use Cloud Transfer Feature:
Set up a transfer task specifying source (OneDrive) and destination (Google Drive).
Schedule transfers or run immediately.
Monitor Progress:
MultCloud provides real-time status updates.
Handles large data transfers seamlessly.
Advantages:
No local storage needed.
Automated and fast transfer.
Preserves folder structure and permissions (where supported).
Disadvantages:
Security concerns—trust third-party with your data.
May require paid plans for large data volumes.

Also, the article above is right; you'll have to pay for the 100gb you want to sfer, the free plan only gives you 5gb. This is from their plans and pricing page,
MultCloud Plans & Pricing
Choose the right MultCloud for you!
Limited Data
Unlimited Data
5GB / Month
$0

5GB free data traffic per month
Convert 50 Emails per Month
2 threads for data transfer
Transfer/sync/backup across clouds
Offline transfer/sync/backup
Migrate 3 sub-accounts between team
High-speed data transfer

4 one-way/two-way sync modes
Real-time sync
Password-protected sharing
Sub-accounts collaboration

30+ leading cloud storage services
Add unlimited cloud accounts
Single log in to all clouds
24/7/365 priority support
1200GB / Year
-50%
$119.88 $59.99
Annual Payment

1200GB data traffic per year
Unlimited Emails Conversions
10 threads for data transfer
Scheduled transfer/sync/backup
Transfer/sync/backup across clouds
Offline transfer/sync/backup
Migrate 1000 sub-accounts between team
High-speed data transfer

10 one-way/two-way sync modes
Real-time sync
Password-protected sharing
Sub-accounts collaboration

30+ leading cloud storage services
Add unlimited cloud accounts
Single log in to all clouds
24/7/365 priority support
2400GB / Year
-58%
$239.76 $99.98
Annual Payment

2400GB data traffic per year
Unlimited Emails Conversions
10 threads for data transfer
Scheduled transfer/sync/backup
Transfer/sync/backup across clouds
Offline transfer/sync/backup
Migrate 1000 sub-accounts between team
High-speed data transfer

10 one-way/two-way sync modes
Real-time sync
Password-protected sharing
Sub-accounts collaboration

30+ leading cloud storage services
Add unlimited cloud accounts
Single log in to all clouds
24/7/365 priority support

https://www.multcloud.com/price
Granted this at the moment is cheeper do to black friday / cyber Monday but, paying that ammount to only rely on it once seems; kinda not worth it, in my opinion, but if that's what you want to each their own of course. Still, the best solution as said would be the manual approach, if you ask me.

There are alternatives sure as I mentioned in the post above but you'll have to pay.