Automation of warehouse synchronization KeyCRM → Google Sheets

Many online stores face a problem: product stock in the CRM is updated, but in the accounting, analytics, or team tables, it remains outdated. This leads to manual data entry, errors in stock levels, and a lack of timely notifications about critical product quantities.

I have developed an automatic solution for synchronizing data between KeyCRM and Google Sheets in real-time with a notification system.

What has been implemented:
- updating product stock via webhook from KeyCRM
- adding new products through polling API
- automatic recording of stock change history
- processing orders with recording in a separate Google Sheets sheet
- notifications in Telegram for critical product stock (≤5 or 0)

Technologies:
- Google Apps Script, KeyCRM API, Telegram Bot API, Google Sheets.

Result:
- automatic inventory control
- instant notifications about critical stock levels
- elimination of manual data entry
- reduced risk of errors in product accounting
- the solution works without a server (serverless)
- secure storage of API keys and tokens

Expansion possibilities:
- sales and stock analytics
- automatic reports
- integration with other CRMs or marketplaces
- automatic order creation