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.
https://sheet2api.com/website-weather-widget-with-google-sheet/
Does anyone have ideas for other widget tutorials I could create?