How it works
To connect Mocean and Google Sheets, you don't need a developer: a ready-made scenario links them in minutes.
- Starts when: Triggers at 7 AM till 8 AM every minute on weekdays
- Then: Get today's date
- Then: Get date & status of alarm
- Check: Check if date is today
- If yes: Define Origin and Destination addresses
- Then: Get Latitude/Longitude of End Address
- Check: Merge all trajectories
- Then: Get real duration between the two addresses
- Check: Total duration < 9:00 AM?
- If yes: Check date & status of alarm
- Check: Check if status is equal to 'ini'
- If yes: Send an SMS/MMS/WhatsApp message
- Then: Update alarm status
- Then: Get Latitude/Longitude of Origin Address
- If no: Update alarm date & status
You can launch this Mocean + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.