n8n Daily Business Change Digest: OpenAI + Google Sheets + Telegram

See competitor pricing, SEO ranking, and revenue risk change—then get a daily digest automatically

This n8n Daily Business Change Digest workflow runs every morning at 8am to detect meaningful changes across Google Sheets, search signals via SerpApi, and AI-generated “What Changed?” summaries using OpenAI—delivering results to Telegram and Gmail, with Slack alerts if anything fails.

What this workflow does

• Daily scheduled monitoring: Loads configuration values (Google Sheet ID, SerpApi key, tracked keyword/domain, and notification targets) and executes at 8am.
• Competitor pricing change detection: Reads pricing baselines from Google Sheets, uses OpenAI web search to extract current entry-level plan pricing, flags moves of 3% or more, and updates the baseline.
• Google ranking movement tracking: Pulls the latest keyword position via SerpApi, compares it to the stored baseline in Google Sheets, and reports only real rank changes while saving the new position.
• Revenue anomaly detection: Analyzes revenue rows in Google Sheets and flags today’s revenue as an anomaly when the z-score is ≥ 2 versus recent history.
• Customer churn detection: Identifies customers that move from active to churned in Google Sheets and updates each customer’s baseline status for the next run.
• AI-powered daily digest: Combines all reportable updates and uses gpt-4o-mini to write a grouped “What Changed?” message; if nothing changed, it sends an all clear Telegram notification.
• Failure visibility: On error, posts an execution alert to Slack including the failed node and execution details.

Use cases

• Daily SaaS competitive monitoring with pricing + SEO rank movement in one place
• Early warning for revenue anomalies and customer churn directly in your inbox/phone via Gmail + Telegram
• Reliable operations oversight with Slack alerts when an n8n workflow fails

Technical details

• Workflow logic uses nodes such as: if, set, code, gmail, merge, and slack
• Integrations driven by: Google Sheets, SerpApi, OpenAI (gpt-4o-mini), Telegram, and Gmail