n8n Ozon Low-Stock Alerts to Telegram via Google Sheets Thresholds

Get notified on Telegram when Ozon stock runs low—using Google Sheets thresholds

This n8n workflow pulls daily stock levels from your Ozon Seller API, compares them to per-offer minimums stored in Google Sheets, and sends a single low-stock summary message to Telegram—at 09:00 every day.

What this workflow does

• Runs on a schedule: executes once daily at 09:00.
• Fetches stock from Ozon: requests product stock levels via the Ozon Seller API and paginates through results.
• Reads thresholds from Google Sheets: loads a worksheet that includes offer_id and min_stock, then matches rows to products by offer_id.
• Calculates available quantity: sums available stock across warehouses for each product.
• Applies default fallback: uses a default minimum stock value when no min_stock entry exists for a given offer.
• Filters low-stock items: keeps only products where available quantity ≤ min_stock.
• Sends one Telegram summary: formats a single message listing low-stock items (sorted by lowest stock) and limits output to a configured maximum number of lines.

Use cases

• Prevent stockouts by automatically monitoring Ozon inventory and alerting your team before items run critical.
• Maintain per-offer safety stock levels in Google Sheets without changing workflow logic.
• Give SaaS operators and automation engineers a reliable daily inventory watchdog using n8n.

Technical details

• n8n nodes / building blocks: set, merge, filter, split out, telegram, and sticky note.
• Integrations: Ozon Seller API (Custom Auth with Client-Id and Api-Key headers), Google Sheets (OAuth), and Telegram (bot credentials + chat ID).
• Expected sheet columns: offer_id, min_stock.

Configure credentials, select your spreadsheet/worksheet, and deploy. Your low-stock signals will start flowing to Telegram automatically every day.