Apps Script to create Google

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.