Apps Script to create Google events and tasks when a cell is updated.
The requirement was to automatically create Google Tasks and Calendar events when a task is entered in Google Sheets.
• Implemented automatic updates to Google Tasks when the task name, status, or date is modified in the sheet.
• When a task is completed in Google Tasks, its status updates automatically in the spreadsheet for all assigned users.
• Meetings are scheduled via the sheet, generating Google Calendar events for all Gmail participants listed in the cell.
• Added automatic updates to calendar events when changes are made in the sheet.
• Entire solution built using Google Apps Script.
AI Lead Qualifier — chat agent that qualifies leads before your manager picks up the phone.
THE PROBLEM
78% of buyers choose the vendor who answers first. Most inbound leads wait hours for a human.
THE SOLUTION
An AI agent answering every lead within seconds, 24/7: short dialog → structured data (need, budget, timeline, contact) → A/B/C grade → instant Telegram alert with a full lead card. Everything logged to Google Sheets.
BUSINESS IMPACT
• Response in seconds, not hours
• 50–70% of routine questions off your sales team
• Structured lead card for every inquiry
• Self-hosted — no monthly SaaS fees
PROVEN IN A LIVE TEST
From "can you make a website for my store?" the agent extracted need, timeline, budget, name and phone in 2 messages, scored the lead class A, and alerted the manager — automatically.
Built on n8n + LLM + Telegram. Details in my profile — DM me.