The problem is that this solution is limited to public documents, and it does not work with private documents that are shared with specific people only.
What Have I Tried
I tried using the embed link with private documents to which I have access. It does not work.
Can I embed private GSuite documents in HTML documents, so that only users with permissions can access them?