I found a free weather tool on GitHub that returns weather reports in various formats, including plain text with emojis for cloud conditions.
The service is free and can be integrated using IMPORTDATA() in Google Sheets.
-Returns plain text that can be displayed/formatted in AppSheet
Tallahassee: ⛅️ +80°F
There are lots of other formats that could be used:
Supported output formats and views wttr.in currently supports five output formats: * ANSI for the terminal; * Plain-text for the terminal and scripts; * HTML for the browser; * PNG for the graphical viewers; * JSON for scripts and APIs; * Prometheus metrics for scripts and APIs.
Note: I recommend avoiding sheet formulas in general, but there aren’t many options for weather data without advanced API integrations.
This is a much easier alternative so I thought I’d through it out there.