Hi n8n community 
I’d like to share a reusable n8n workflow that fetches current observations from a
Weather Underground Personal Weather Station (PWS) and stores them in a PostgreSQL database.
GitHub Repository:
What this workflow does
• Fetches real-time weather data from a Weather Underground PWS
• Supports metric, imperial and hybrid units
• Automatically creates the PostgreSQL table if it doesn’t exist
• Stores structured weather metrics (temperature, wind, pressure, UV, precipitation, etc.)
• Uses n8n credentials (no secrets included in the template)
Configuration
In the “Configuration” node, set:
{
“userStationId”: “YOUR_STATION_ID”,
“userUnits”: “m”,
“numericPrecision”: “decimal”
}
You also need to create an HTTP Query Auth credential in n8n
using your Weather Underground API key.
API Rate Limits (Important)
Weather Underground enforces strict API limits depending on your plan.
Typical free / PWS plans allow around ~500 requests per day.
I recommend:
• Using a 30-minute interval or slower
• Avoiding very frequent polling
Exceeding the limit may result in HTTP 429 errors or temporary API key suspension.
Official API info:
Privacy & Security
• No credentials included
• No personal data stored by default
• Station ID must be provided by the user
Feedback, suggestions, and improvements are very welcome 