Personally I found the entire design and the organization of files/docs/sheets between Google Drive and other apps in the Google ecosystem is confusing as hell. There was no way to follow a specific hierarchy and the commenting/reviewing system felt clunky.
Wish I never had to use this Google suite of products if it wasn't for my employer.
Maybe you should give it another look. Hierarchy eas terrible because it was originally designed to have tags instead of folders and these were prone for cyclic references. When they implemented folders they implemented them on top of tags and things never worked out great.
It got a lot simpler since they nuked tags in favor of folders.
Wish I never had to use this Google suite of products if it wasn't for my employer.