Monitor LINE activity and Gemini sentiment with Google Sheets for elderly care

Description: Monitor activity and detect distress in elderly family members via LINE. 👴👵

This workflow connects LINE and Google Sheets to create a non-intrusive monitoring system. It uses Gemini to analyze message sentiment for health concerns and includes a daily "Watchdog" routine that triggers an alert if no activity is recorded by 11:00 AM.

How it works:

Monitor: Logs every incoming message to Google Sheets. If Gemini detects a health risk (e.g., "I feel dizzy"), it instantly alerts the child via LINE.

Note: Automatically handles stickers by logging them as [Sent Media].

Daily Check: Runs daily at 11:00 AM.

Phase 1: Checks the Google Sheet for today's logs. If empty, sends a gentle reminder to the parent.

Phase 2: Waits 3 hours. If still no activity, sends an emergency alert to the child.

Setup Instructions:

LINE: Create a LINE Official Account and retrieve the Channel Access Token.

Google Sheets: Create a sheet named ActivityLog with headers: Date, Time, Message, Sentiment, Alert.

Config: Open the "Config" node to enter your PARENT_LINE_ID, CHILD_LINE_ID, and SHEET_ID.