Monitor ride surge events and analyze ride errors with Sheets, Slack and Gemini

Description

Quick overview
This workflow pulls ride events and error records from Google Sheets, detects surge pricing and long waits, and notifies via Slack. For error records, it uses Google Gemini with real-time traffic and weather API lookups to diagnose the issue and send recommended actions to Slack.

How it works
Runs manually and reads ride records from a Google Sheets spreadsheet.
Processes the rows one by one with a short delay and routes each record based on whether its type is an event or an error.
For event records, checks if the ride price is more than 1.5× the normal price and the wait time is over 10 minutes.
If surge conditions are met, sends a surge and delay notification to Slack and records a surge-alert log entry.
If surge conditions are not met, records a normal “no alert needed” log entry.
For error records, structures the ride and error context and asks Google Gemini to generate an incident summary, probable cause, and recommended actions, calling traffic and weather APIs as needed.
Parses the Gemini response into JSON and posts the formatted error report to Slack.

Setup
Connect Google Sheets OAuth credentials and set the correct spreadsheet and sheet tab in the Google Sheets node.
Connect Slack OAuth2 credentials and set the target Slack user/channel for both Slack message steps.
Connect a Google Gemini (Google PaLM) API credential and select the model to use for diagnosis.
Provide valid API keys and endpoints for the traffic and weather HTTP request tools (and replace the sample keys in the query parameters).
Ensure your Google Sheet includes the fields used by the workflow (for example: type, city, user_id, ride_price, normal_price, wait_time, pickup_location, drop_location, error_message, details, traffic fields, and weather fields).

Additional info
How To Customize Nodes

You can customize this workflow easily:

Change surge thresholds in IF Node
Modify Slack messages for better user communication
Adjust AI prompt for different analysis style
Add new fields in Google Sheets for more insights
Change API providers if needed

Add-ons

You can extend this workflow with:

SMS or Email notifications
Database logging (MongoDB / MySQL)
Dashboard integration (Power BI / Tableau)
Predictive surge forecasting using AI
Driver availability tracking
Real-time map visualization

Use Case Examples

Detect surge pricing in busy cities and notify users instantly
Identify traffic-related ride delays and provide insights
Analyze ride errors and suggest corrective actions
Monitor overall ride performance for business optimization
Improve customer experience by proactive alerts

There can be many more use cases depending on business needs and system integrations.

Troubleshooting Guide

| Issue | Possible Cause | Solution |
|------|--------------|---------|
| No data fetched from Google Sheets | Incorrect credentials or sheet ID | Verify API credentials and sheet configuration |
| Slack message not sent | Invalid Slack OAuth setup | Reconnect Slack API and check permissions |
| AI response not generated | Gemini API issue or prompt error | Check API key and prompt formatting |
| Traffic/Weather data missing | API key invalid or wrong parameters | Verify API keys and query parameters |
| JSON parsing fails | AI response format incorrect | Ensure Gemini output is strictly JSON |
| Workflow not triggering | Trigger not configured properly | Check Manual/Cron/Webhook trigger |

Need Help

If you need help setting up, customizing or extending this workflow, we’re here to support you.

You can reach out to WeblineIndia for:

Workflow setup assistance
Custom automation development
AI-based system integration
Business process optimization

Contact WeblineIndia today to build powerful automation workflows tailored to your business needs.