Projects using Apps Script in Buenos Aires

Projects using Apps Script in Buenos AiresProjects using Apps Script in Buenos Aires

Cover image for 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.

1

18

Cover image for I built a fully automated

I built a fully automated booking system using Google Sheets and Apps Script that: • Allows clients to select their preferred date and time • Automatically blocks unavailable slots based on Google Calendar • Syncs events instantly with the owner’s calendar • Sends automatic confirmation emails • Lets clients view their booking status, leave updates, or cancel directly from email Each appointment is automatically recorded in Google Sheets with a unique ID, client details, and message history, creating a structured and trackable database. It also includes a built-in analytics dashboard with real-time metrics such as: • Total appointments • Cancellation rate • Peak booking demand • A heatmap, showing weekly booking distribution Interface, logic, booking rules, and language are fully customizable based on each client’s needs. 😸

2

3

162

Cover image for My proprietary system for managing

My proprietary system for managing and achieving any goal you set

1

4

187