Google Drive share Link to Notion embed no access

I’m trying to connect Google Drive to Notion. I’m extracting the shared link provided by Google Drive to embed it within a page in Notion. It does everything, but in Notion, I get a screen saying:

“You need access. Open the document directly to see if you can request access, or use an account that has it. More information.”

This was reported here a few months ago and was closed due to inactivity, so I’m reporting it again.