yes. Be careful how much you share, you almost certainly want to restrict who can view your documents. It looks like you can do that in the dialogs below, but I did not experiment.
steps to make a google sheet: pick new:
pick sheet:
give it a name...
pick share:
ask for a shareable link. I did not choose anybody for editors. It is shared with the world if you have the link. I think this is where you can restrict viewers as well.
copy the link. As you can see, this doc is open to the world...
modify the link. Google Groups ( productforums.google.com/forum/#!topic/docs/An-nZtjaupU ) suggested a change like this:
....7E/edit?usp=sharing
becomes
....7E/export?format=csv&id
at the end of the link.
finally, use the JMP open function (JSL) to view it. (Or use File->InternetOpen->OpenAs->Data with the same URL)
open("https://docs.google.com/spreadsheets/d/1A...........7E/export?format=csv&id")
There's a bunch of unanswered questions here, join the discussion!
Craige