Google Sheet Preview: is there any way?

Note: the following was merged (thanks @merefield and @darkpixlz) from another topic I just created… with the exact same question as in December. It fell through the cracks in my brain (ski accident was nearly a year ago folks, but I’m still not back in good working order for some things, clearly – thanks for your indulgence).

In my community each member has a tracking spreadsheet that they normally share when they post for help. The way it works now on Facebook, there is a “preview” that shows a snapshot of the latest part of the spreadsheet:

This is super useful (at least one thing Facebook is useful for/at!) because it gives us a view of the relevant data we need without even clicking on the spreadsheet. We often click, of course, but it gives us a general understanding of what kind of situation we’re dealing with.

I read here that for the onebox to work on Discourse the google doc had to be published. I tried that with mine but it doesn’t seem to work:

It even says the sheet is private, when it’s not! Here is the result when I share the “share with link” link, same thing:

Is there any way to get something better than that? It’s a fundamental aspect of how we function: the key point of our work is to help people track and interpret blood glucose that they monitor at home, and this spreadsheet model is our “magic” tool to do this.

I’m guessing that if Facebook can manage to display a meaningful snapshot of a google spreadsheet, there should be a way to manage that on Discourse too?

2 Likes