7 n8n Google Sheets + OpenWeather API automations

Every free, copy-paste n8n recipe that connects Google Sheets and OpenWeather API in one workflow. Each is a ready-to-run AI agent — import it, connect both accounts, and it runs 24/7. No code, no signup. See all Google Sheets or OpenWeather API recipes.

Browse 7 recipes →
Free recipe
Free
Google Sheetsn8n
Google Sheetsn8n

Send Tour Guests Weather Contingency Plans Before They Wonder

Outdoor tour guests panic about weather and flood the operator with calls. Check each tour's forecast and proactively send the plan — go, modified or rescheduled — before they ask.

OpenWeather APIGoogle SheetsTwilion8n
Beginner · 25 min setup
Free recipe
Free
Google Sheetsn8n
Google Sheetsn8n

Check Wind Ratings Before Confirming Tent Rental Installs

Event tents have wind ratings, and installing into forecast winds beyond them is dangerous and liable. Check the install-day forecast against each tent's rating before confirming.

OpenWeather APIGoogle SheetsTwilion8n
Intermediate · 30 min setup
Free recipe
Free
Google Sheetsn8n
Google Sheetsn8n

Trigger Required Stormwater Inspections After Rain Events

Construction and industrial sites must inspect stormwater controls after qualifying rain events, and missed inspections mean violations. Detect qualifying rain and trigger the required inspections.

OpenWeather APIGoogle SheetsSlackn8n
Intermediate · 30 min setup
Free recipe
Free
Google SheetsGmailn8n
Google SheetsGmailn8n

Track Orchard Chill Hours to Predict Bloom and Plan Labor

Fruit trees need accumulated chill hours to bloom well, and growers guess at timing. Track chill hour accumulation and predict bloom timing to plan pollination and labor.

OpenWeather APIGoogle SheetsGmailn8n
Intermediate · 30 min setup
Free recipe
Free
Google Sheetsn8n
Google Sheetsn8n

Schedule Lawn Treatment Rounds Around Weather Windows Automatically

Fertilizer and pre-emergent rounds need dry windows and soil timing. Plan each round's route inside real weather windows and notify customers of their treatment day.

OpenWeather APIGoogle SheetsTwilion8n
Intermediate · 30 min setup
Free recipe
Free
Google Sheetsn8n
Google Sheetsn8n

Fill Weather-Cancelled Tee Times From a Standby List

Golf courses lose revenue when weather cancels tee times that could refill once it clears. Detect cancellations and offer freed times to a standby list, filling gaps the same day.

OpenWeather APIGoogle SheetsTwilion8n
Beginner · 25 min setup
Free recipe
Free
Google Sheetsn8n
Google Sheetsn8n

Run Crane Lift Go/No-Go Decisions Against Real Wind Data

Crane lifts have hard wind limits that vary by load and boom configuration, and a bad call is catastrophic. Check the lift-window forecast against the plan's wind limit for a documented go/no-go.

OpenWeather APIGoogle SheetsSlackn8n
Intermediate · 30 min setup
Looking for something else? Browse all integrations or search every recipe. Some ingredient links are affiliate links — full disclosure.