Thank you for the suggestions
Yes the Embed works well - but it is basically an iFrame; the data is not part of the document to manipulate for other views etc.
Zapier does work, but how do you trigger it to pull data whenever the Coda doc is reloaded? It seems more applicable to push data from Sheets to Coda than the other way around. That aside, Zapier is a paid and metered service; is that realistic if the document is shared to many people and auto-loads the data each time?
Coda is a terrific concept. I’m just really struggling with the concept of why there are such limitations or compromises in importing data from the Internet when using a cloud-based state-of-the-art application. I mean this with the utmost admiration for what has been accomplished so far and I really am rooting for this to succeed. But i think unless there is a strong emphasis on importing all sorts of data from the web very easily, the project will fail.