Automate Weather Forecast Logging to Google Sheets

Automatically log a 14-day weather forecast from OpenWeatherMap into a Google Sheets spreadsheet, keeping your data organized and up-to-date.

make

This workflow retrieves a 14-day weather forecast for a specified location using OpenWeatherMap and logs the data into a Google Sheets spreadsheet. The data includes the date, minimum and maximum temperatures, rain, humidity, and a weather description. This automation ensures that your weather data is consistently updated without manual input.

Free
Last updated October 3, 2026
30-day money-back guarantee
Instant download
Lifetime updates included

Secure checkout powered by Stripe

Support

How to import this workflow into Make

  1. 1Purchase or download the workflow to get the Make blueprint JSON file.
  2. 2In Make, create a new scenario, click the three-dots menu, and choose "Import Blueprint".
  3. 3Reconnect each module to your own app connections when prompted.
  4. 4Run the scenario once to verify it, then set your schedule and turn it on.

Related Data & Analytics workflows

More from Talia Andersen

Need this deployed? We'll set it up for you.

Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.