Transform NASA DONKI Space Alerts to Japanese with GPT-4 for Slack and Sheets

Description

Who’s it for

Teams that care about space-weather impact—SRE/infra, satellite ops, aviation, power utilities, researchers—or anyone who wants timely, readable alerts when NASA publishes significant solar events.

How it works / What it does

Every 30 minutes a Cron trigger runs, the NASA DONKI node fetches the past 24 hours of space-weather notifications, and a code step de-duplicates, labels event types, and assigns a severity (CRITICAL / HIGH / OTHER). A Switch routes items:

CRITICAL/HIGH** → an LLM (“AI Agent”) produces a concise Japanese alert → Slack posts with local time and source link.
OTHER** → an LLM creates a short summary for record-keeping → a small merge step prepares fields → Google Sheets appends a new row.
Sticky notes in the canvas explain the schedule, data source, and overall flow.

How to set up

Add credentials for Slack, Google Sheets, and OpenAI (or compatible LLM).
Open the Slack nodes and select your workspace + target channel.
Select your Google Sheet and worksheet for logging.
(Optional) Adjust the Cron interval and the NASA lookback window.
Test with a manual execution, then activate.

Requirements

Slack Bot with permission to post to the chosen channel
Google account with access to the target Sheet
OpenAI (or API-compatible) credentials for the LLM nodes
Internet access to NASA DONKI (no API key required)

How to customize the workflow

Tweak severity rules inside the Analyze & Prioritize code node.
Edit prompt tone/length in each AI Agent node.
Change Slack formatting or mention style (@channel vs none).
Add filters (e.g., alert only on CME/FLR) or extend logging fields in the merge step.