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.
Built an n8n CRM automation system that captures leads, creates and updates CRM records, assigns tasks, sends team notifications, automates follow-ups and generates reports.
Restaurant Automation System. Automates WhatsApp orders, menu & pricing lookup, estimate generation, PDF invoices, and order processing using n8n, Google Sheets, Gemini AI and WhatsApp Cloud API.