Skip to content
FlowHubFluxonLab
A
AI Automationfree

Send crowd safety SMS reroute alerts with OpenAI, Twilio, and Google Sheets

by Oneclick AI Squadadapted from n8n official workflow galleryUpdated Aug 2026
RequiresAAI AgentAnthropic Chat ModelCCodeHTTP RequestHTTP Request
Share Post Share
ScSchedule Trigger - Poll Crowd DataSchedule Trigge…HRFetch Live Crowd Density DataFetch Live Crow…CoJS - Rename Density ValuesJS - Rename Den…HRFetch Active Incident ReportsFetch Active In…CoJS - Rename Incident ValuesJS - Rename Inc…MeMerge - Combine Density & IncidentsMerge - Combine…CoJS - Merge Zone Data & Calculate Risk ScoresJS - Merge Zone…SOSplit Out - ZonesSplit Out - Zon…CoJS - Format Heatmap Log RecordJS - Format Hea…HRSave Zone Status to Google Sheets Heatmap TrackerSave Zone Statu…FiFilter - High Risk Zones OnlyFilter - High R…WaWait - API Rate LimitWait - API Rate…AgAI - Generate Rerouting SuggestionAI - Generate R…Anthropic - Rerouting ModelAnthropic - Rer…CoJS - Parse Rerouting OutputJS - Parse Rero…HRFetch Subscribed TravelersFetch Subscribe…CoJS - Filter Travelers in Zone & Format AlertsJS - Filter Tra…SOSplit Out - TravelersSplit Out - Tra…HRSend SMS Alert to TravelerSend SMS Alert …WaWait For Limit1234567891011121314151617181920
1/5
STEPS · 20
Runs on a schedule

Quick overview This workflow ingests crowd density and incident reports via webhook or a 5‑minute schedule, assesses risk with Python thresholds, uses OpenAI to generate a short rerouting recommendation, then sends an SMS via Twilio and logs each alert to a Google Sheets heatmap tracker. How it works Triggers when a POST request hits the n8n webhook or every 5 minutes on a schedule. Normalizes incoming fields (location, crowd density, safety score, incidents, traveler contact, and preferences) and fills in defaults when values are missing. Calculates risk level in Python based on configurable thresholds for high density, incident count, and low safety score. Continues only for high-risk items and pauses briefly before the AI call. Uses OpenAI (via an AI agent) to generate a personalized rerouting suggestion under 150 words from the live data and traveler preferences. Sends the rerouting alert to the traveler via Twilio SMS and appends the alert details and reroute text to a Google Sheets log via the Google Sheets API. Setup Add an OpenAI API credential and select the model in the OpenAI Chat Model connection.

Tags

n8nreference-onlyagentlm-chat-anthropic
Connects
AAI AgentAnthropic Chat ModelCCodeWHTTP Request
CategoryAI Automation
Triggermanual
Complexityadvanced
Nodes20
AddedJul 8, 2026

Related workflows

See all AI Automation
Acalln8nworkflowtoolCdhl
free

Summarize Zoom meetings and create follow-ups with OpenAI, ClickUp, and Outlook

Quick overview This workflow pulls the transcript and participant list from a recent Zoom meeting, uses OpenAI to generate formal meeting minutes, emails the summary via SMTP, and runs an AI agent that creates ClickUp tasks and (when details exist) schedules a follow-up meeting in Microsoft Outlook Calendar. How it works Starts when you manually run the workflow. Fetches your scheduled Zoom meetings and keeps only those that started within the last 24 hours. Requests the meeting recording files from Zoom, stops with an error if no transcript is available, then extracts the transcript download URL. Downloads the Zoom transcript file, extracts its text, and reformats it into clean, readable dialogue. Pulls the Zoom meeting participant list (including emails) and sends the transcript and participants to OpenAI to generate structured meeting minutes. Formats the minutes into an HTML email and sends the summary via SMTP to a participant email address. Uses an OpenAI-powered agent to extract action items and follow-up details from the same transcript, then creates tasks in ClickUp and creates a follow-up event in Microsoft Outlook Calendar when scheduling information is present. Setup Ad

by Redowan Ahmed Farhan
Acalln8nworkflowtoolclickupC
free

Answer WooCommerce order and DHL tracking questions with GPT-4 chat

Quick overview This workflow serves a demo web page with an n8n chat widget and runs an OpenAI-powered support agent that looks up WooCommerce orders and DHL tracking details by calling the same workflow as a tool. How it works Serves a demo HTML page via a webhook that embeds the n8n Chat widget configured to start a chat session. Triggers a new conversation when the chat widget connects and provides a customer email (mocked in this template) as session metadata. Uses an OpenAI (GPT-4) chat model with short-term memory to answer order-related questions and decide when to fetch live order data. Calls the same workflow as a tool with the customer email (and optional comma-separated order IDs) to retrieve matching WooCommerce orders. Looks up the WooCommerce customer by email, fetches their orders, and extracts shipment tracking metadata from each order. For orders with DHL tracking numbers, queries the DHL API for current shipment status, then merges tracking results back into the order data. Returns a JSON response containing the customer’s orders and any available DHL tracking details to the agent for use in the chat reply. Setup Add a WooCommerce API credential and update the sto

by Redowan Ahmed Farhan
ACgmailW
free

Send weekly blended ad performance reports with Meta Ads, Google Ads, GA4 and OpenAI

Quick overview This workflow runs every Monday at 8am, pulls last-7-days performance data from the Meta Ads API, Google Ads API, and Google Analytics 4, calculates blended KPIs, uses OpenAI to generate a client-friendly insight summary, and delivers an HTML report by Gmail while posting status update to Slack. How it works Runs every Monday at 8am on a schedule trigger. Fetches the last 7 days of spend and engagement metrics from the Meta Ads Insights endpoint. Fetches the last 7 days of campaign cost, clicks, and conversions from the Google Ads API using a streamed search query. Fetches the last 7 days of conversions and revenue by default channel group from the Google Analytics 4 Data API. Combines the three datasets and calculates blended totals for spend, conversions, revenue, and ROAS. Sends the blended metrics to OpenAI to generate a 3–4 sentence plain-language weekly performance summary. Builds a simple HTML report and sends it to the client via Gmail while posting a short “report sent” summary to a Slack channel. If the workflow execution fails, posts the error message to an ops Slack channel. Setup Add credentials and replace the placeholders for your Meta Ads token and ad

by Redowan Ahmed Farhan