Templates / Send earthquake safety checks to employees with P2PQuake, LINE, and Google Sheets

Send earthquake safety checks to employees with P2PQuake, LINE, and Google Sheets

Ready for 3.0

by AKIKO SASAKI ✓ · 1 views · created 2026-10-15 · Miscellaneous

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 15 nodes and runs on a schedule (every 30 minutes) (plus 1 other trigger). Along the way it connects Google Sheets. It also calls api.p2pquake.net and api.line.me over HTTP.

How it runs

Trigger: On a schedule (every 30 minutes) (plus 1 other trigger).

  1. Fetch Earthquake Information (HTTP Request): calls api.p2pquake.net
  2. Route LINE Message (Switch): routes items into 3 branches
  3. Get Latest Earthquake (Limit): keeps the first few items
  4. Update Status - Safe (Google Sheets): update
  5. Update Status - Needs Help (Google Sheets): update
  6. Update Status - Other (Google Sheets): update
  7. Register Employee (Google Sheets): append
  8. Get Last Earthquake ID (Google Sheets): uses Google Sheets
  9. Is New Earthquake? (If): checks a condition and branches into true / false
  10. Get Employees (Google Sheets): uses Google Sheets

…plus 3 more steps. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: api.p2pquake.net, api.line.me

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (7)

From the author

Quick overview This workflow polls the P2PQuake earthquake API every 30 minutes, checks impacted employees stored in Google Sheets, and sends targeted safety check messages via the LINE Messaging API, while also recording employee registration and response…

Excerpt from AKIKO SASAKI's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.