I built the first of hopefully many demo widgets over the weekend to show what's possible with sheet2api.
This one takes a spreadsheet which has been auto-populated with Weather data from openweathermap.org (using the MixedAnalytics API Connector).
That spreadsheet is then connected to sheet2api which a widget on a webpage uses to populate the current weather values, along with a nice image of the City. In this case, I did London and Paris.
Does anyone have ideas for other widget tutorials I could create?