Detect pricing anomalies in Google Sheets with Groq AI and Slack alerts

Data Quality Checker

This workflow automatically monitors pricing data in Google Sheets, detects anomalies such as missing values or sudden spikes/drops, generates AI-based short explanations for flagged rows, updates the sheet with status and reason and sends Slack alerts for critical issues.

Quick Implementation Steps:

1. Prepare your Google Sheet with columns: price, previousprice, status, reason, rownumber. 2. Connect n8n with your Google Sheets, Slack and Groq AI credentials. 3. Trigger the workflow manually or via webhook. 4. Each row is processed to detect anomalies and generate a reason using AI. 5. Flagged rows are updated in Google Sheets and a Slack alert is sent automatically.

What It Does

The Data Quality Checker workflow is designed to help you maintain accurate pricing data effortlessly. It fetches data from Google Sheets, evaluates each row for anomalies and ensures that unusual changes in prices do not go unnoticed.

It automatically flags rows with missing values, sudden spikes or sudden drops in price. The workflow uses a Groq AI model to generate concise explanations for any anomalies found, providing actionable insights directly in your sheet.

For rows without issues, it marks the status as OK with a standard reason. A Slack alert is sent for flagged data to keep teams informed in real-time, preventing unnoticed errors and enabling faster corrective actions.