Are you copying a local Google Doc? The Google doc or spreadsheet files saved on the disk is not the “actual” (complete) doc or spreadsheet file; it’s similar to a .hook file that contains a URL. When a user clicks the google doc file in Finder, the file redirect the OS to open the file on Google Drive (website) using the browser.
Supposing this:
- in a web browser, access a Google Drive spreadsheet
Copy Markdown Link- paste in a text editor
- use the URL in there
this works, proving that Hook is doing its thing.
See also: Hook and Roam research - Discussion & Help - Hook Productivity Forum, which discusses some limitations of Roam. I don’t currently have a Roam subscription, so I’m not in a position to see if Roam has dealt with the limitations mentioned in that post. (Those limitations are not specific to Hook.)
So I am moving this topic to the Discussion category. If it seems like a Hook bug, we’ll move it back. And I’ve added " (pasted into Roam Research)" to the topic title.