Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Alerts & Notifications

Alerts & Notifications

Send earthquake safety check messages via LINE using P2PQuake and Google Sheets

Runs on a schedule, checks P2PQuake for new quakes, and sends LINE safety checks to employees whose home or work prefecture reports intensity 4 or higher.

Import it free Sign in to open it

What it does

Workflow Overview This workflow provides an earthquake safety check system for employees using P2PQuake, LINE, and Google Sheets. It automatically checks for new earthquakes, identifies employees whose home or work prefecture is affected by seismic intensity 4 or higher, and sends a LINE safety check message only to those employees. Employees can register their name, home prefecture, and work prefecture through LINE. After receiving a safety check, they reply with 1, 2, or 3 to report their status. Google Sheets stores employee information, safety status, response time, and the last processed earthquake ID to prevent duplicate notifications.

The steps

  1. Earthquake Check Schedule
  2. Fetch Earthquake Information
  3. Get Latest Earthquake
  4. Get Last Earthquake ID
  5. Is New Earthquake?
  6. Get Employees
  7. Send Safety Check to LINE
  8. Update Last Earthquake ID
  9. Update Status - Safe
  10. Update Status - Needs Help
  11. Update Status - Other
  12. Route LINE Message
  13. Register Employee
  14. Is Employee in Affected Area?

15 steps in total.

Similar automations

Alerts & NotificationsPost Slack safety checks for Google Sheets sites near USGS earthquakes14 stepsRAG & Knowledge BasesAlert on Safety Incidents with Hugging Face and Redis10 stepsReports, Analytics & DashboardsSummarize Neighborhood Safety with a Claude RAG Agent10 stepsAlerts & NotificationsSend Daily Weather Updates to LINE4 steps