Google Sheets as CRM: auto-sync and Telegram reports

Task: turn a Google Spreadsheet into a lightweight CRM
with automated reports and instant notifications.

What was built:
— gspread API: reads/writes rows when deal status changes
— Trigger: new deal → instant Telegram notification to assignee
— Weekly report: deal count, total amount, funnel conversion
— Contact deduplication on new record creation
— Google Apps Script + Python: two-way sync

#google_sheets #crm #automation #telegram #gspread #python