TM
TMTM
In the bustling offices of TechNova Inc., a rapidly growing tech company known for its innovative software solutions, a unique predicament has emerged. As the company expanded, so did its array of events and meetings. From product launches and client presentations to internal team-building activities, TechNova had a calendar bursting with events.
The responsibility of managing and scheduling these events had traditionally fallen on a dedicated events coordinator. However, due to budget constraints, the company made a tough decision to cut costs by eliminating the events coordinator position. To keep things running smoothly, the daunting task of scheduling all these events now fell squarely onto the shoulders of Mark Thompson, a diligent and capable project manager.
Mark was already juggling a heavy workload, overseeing multiple projects simultaneously. The sudden addition of event scheduling to his responsibilities left him feeling overwhelmed and stressed. He found himself buried under a mountain of calendar invites, trying to ensure that all events were well-coordinated, and everyone received the necessary notifications. It was an exhausting task that consumed a significant portion of his workdays.
Calendar automation refers to the process of automating tasks and actions related to calendar management, scheduling, and events using software tools and scripts. It aims to streamline and optimize calendar-related workflows, reducing manual efforts and minimizing the risk of errors. Calendar automation can be applied in various contexts, including personal scheduling, business meetings, event management, and more.
Google Apps Script, a JavaScript-based scripting language developed by Google, provides a powerful platform for automating calendar-related tasks and interactions with Google Calendar. Using Google Apps Script, you can create custom scripts and applications that interact with Google Calendar to automate tasks such as:
Event Creation: Automatically create events on Google Calendar based on predefined criteria, data from external sources, or user input.
Event Updates: Automatically update event details, including date, time, location, and descriptions, when changes occur in connected systems or data sources.
Event Deletion: Remove outdated or canceled events from the calendar to keep it up to date.
Notification and Reminders: Trigger notifications and reminders for upcoming events, sending emails, SMS messages, or app notifications to attendees.
Availability and Scheduling: Check the availability of attendees and schedule events at suitable times, taking into account conflicting schedules.
Data Integration: Integrate data from external sources, such as spreadsheets, databases, or APIs, with calendar events for dynamic event creation and management.
Recurring Events: Set up recurring events and automate the generation of recurring event instances.
Resource Booking: Manage the booking of conference rooms, equipment, or other resources associated with events.
So let's start with the calendar automation process.
The sheet should contain the following attributes:
Name of the Event
Start datetime of the Event
End datetime of the Event
Description of the Event
Attendees of the Event
Optional Attendees of the Event
We are inside the script editor.
Now on the left side, there is a tab called Services. Click on the plus icon of that.
Click the plus icon (+) to add the Calendar API service. With the Calendar service added you are now prepared to execute the script.
The Google Calendar API has successfully been added to the Project.
Let's begin scripting by opening the Google Apps Script editor.
function main() {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = ss.getSheetByName("Calendar_Events");
const eventsData = sheet.getDataRange().getValues();
const eventArray = [];
for (var i = 1;i<eventsData.length;i++){
const eventMap = {};
eventMap['eventName'] = eventsData[i][0];
eventMap['start'] = eventsData[i][1];
eventMap['end'] = eventsData[i][2];
eventMap['description'] = eventsData[i][3];
eventMap['attendees'] = eventsData[i][4];
eventMap['optionalAttendees'] = eventsData[i][5];
eventArray.push(eventMap);
}
Logger.log(eventArray);
}It will generate the object as shown below:
[
{
"eventName": "Event Number 1",
"start": "2021-06-26T9:30:00",
"end": "2021-06-26T10:30:00",
"description": "This is the event number 1",
"attendees": "burhanuddinnahargarwala@gmail.com, dashingbb786@gmail.com",
"optionalAttendees": "dashingbb786@gmail.com"
},
........
]Now let's create another function that takes this object and creates new events in the calendar.
function createNewEvent(eventArray) {
for (i=0; i < eventArray.length; i++) {
const event = eventArray[i];
const calendarEvent = CalendarApp.getDefaultCalendar().createEvent(
event['eventName'],
new Date(event['start']),
new Date(event['end']),
{ sendInvites: true, sendUpdates: "all", guests: event['attendees']}
);
}
}The 'createNewEvent' function operates on an array of event objects (eventArray) and executes the following steps for each event:
It iterates through the eventArray, extracting essential event details such as the event name, start date, end date, and attendees from each event object.
Using the CalendarApp.getDefaultCalendar().createEvent() method, the function generates a new event in the default Google Calendar. It's important to note that this method automatically selects the calendar associated with the email account used for accessing Google Sheets and running the Apps Script. This ensures that the event is added to the calendar linked to the same email account.
Pro Tip: If you need to schedule the event on a different calendar, you can utilize a provided code snippet to specify the calendar ID, allowing you to precisely control the destination calendar.
const calendarEvent = CalendarApp.getCalendarById(calendarId).createEvent(
event['eventName'],
new Date(event['start']),
new Date(event['end']),
{ sendInvites: true, sendUpdates: "all", guests: event['attendees']}
);Sets the event name, start date, and end date for the newly created event.
Specifies additional options, such as sending invitations to guests (sendInvites: true), sending updates to all attendees (sendUpdates: "all"), and specifying the event's attendees based on the input event object.
The calendarId is the ID of your calendar that you can fetch from your calendar itself
Click the three dots of any of the shared calendars.
Click on Settings and sharing
Go to the Integrate calendar section to get the calendar ID.
Now let's run the app script to get the desired outcome.
At the top of the Apps Script editor, select the main function from the dropdown menu. Click the "Run" button to execute the script. Follow these steps to observe the script's functionality and automate calendar events based on the provided sheets.
Review the permissions and allow access to the data.
Once the code is successfully executed, the events will be scheduled in your calendar.
The event has been successfully scheduled in the calendar, and both attendees have been added to the event. Additionally, email notifications regarding the meeting have been sent to the attendees.
A notable observation is that while the Google Sheet designates 'dashingbb786@gmail.com' as an optional attendee, this designation is not reflected in the event. To address this, we will implement logic to mark the attendees as optional within the event details.
function markAttendeeAsOptional(eventId, optionalGuestsList, calendarId = 'primary') {
// Get the event to update
const event = Calendar.Events.get(calendarId, eventId);
const attendees = event['attendees'];
const optionalAttendees = []
for (let i = 0; i < attendees.length; i++) {
const attendee = attendees[i];
const guest = attendee['email'];
// if guest is there in optional guestLists, then mark that as optional
if (optionalGuestsList.includes(guest)) {
attendee['optional'] = true;
}
optionalAttendees.push(attendee);
}
// Save the changes to the event
var resource = { attendees: optionalAttendees };
Calendar.Events.patch(resource, calendarId, event['id']);
}This function, 'markAttendeeAsOptional()', is designed to mark specific attendees as optional within a Google Calendar event.
So let's delete the events and again run the script to check whether the attendee is marked as optional or not.
The attendee is successfully set as optional for the given event.
Refer to the provided GitHub repository link to access the complete script for automating your calendar events. Make sure to maintain the same sheet format as outlined in the blog for seamless integration:
For more in-depth information about various methods offered by the Calendar API, it's advisable to refer to the official Calendar API documentation, where you can explore a comprehensive range of functionalities and capabilities.
In this comprehensive guide, we've explored the power of automation using Google Apps Script and the Google Calendar API to streamline event management. Whether you're scheduling meetings, workshops, or any type of event, this automation process can save you time, reduce errors, and ensure consistency in your calendar.
Let's see the condition of the mark after going through this blog.
In the upcoming section of our blog, we will delve into the dynamic world of event management. We'll explore how to make modifications to your scheduled events and efficiently remove any events that need to be canceled. Stay tuned for these valuable insights!
Running data quality checks on retail sales distribution data
This blog explores my experience with cleaning datasets during the process of performing EDA for analyzing whether geographical attributes impact sales of beverages
Snowflake recommends 100–250 MB files for optimal loading, but why? What happens when you load one large file versus splitting it into smaller chunks? I tested this with real data, and the results were surprising. Click to discover how this simple change can drastically improve loading performance.
Master the bronze layer foundation of medallion architecture with COPY INTO - the command that handles incremental ingestion and schema evolution automatically. No more duplicate data, no more broken pipelines when new columns arrive. Your complete guide to production-ready raw data ingestion
Learn Git and GitHub step by step with this complete guide. From Git basics to branching, merging, push, pull, and resolving merge conflicts—this tutorial helps beginners and developers collaborate like pros.
Discover how data management, governance, and security work together—just like your favorite food delivery app. Learn why these three pillars turn raw data into trusted insights, ensuring trust, compliance, and business growth.
Beginner’s journey in AWS Data Engineering—building a retail data pipeline with S3, Glue, and Athena. Key lessons on permissions, data lakes, and data quality. A hands-on guide for tackling real-world retail datasets.
A simple request to automate Google feedback forms turned into a technical adventure. From API roadblocks to a smart Google Apps Script pivot, discover how we built a seamless system that cut form creation time from 20 minutes to just 2.
Step-by-step journey of setting up end-to-end AKS monitoring with dashboards, alerts, workbooks, and real-world validations on Azure Kubernetes Service.
My learning experience tracing how an app works when browser is refreshed
Demonstrates the power of AI assisted development to build an end-to-end application grounds up
A hands-on learning journey of building a login and sign-up system from scratch using React, Node.js, Express, and PostgreSQL. Covers real-world challenges, backend integration, password security, and key full-stack development lessons for beginners.
This is the first in a five-part series detailing my experience implementing advanced data engineering solutions with Databricks on Google Cloud Platform. The series covers schema evolution, incremental loading, and orchestration of a robust ELT pipeline.
Discover the 7 major stages of the data engineering lifecycle, from data collection to storage and analysis. Learn the key processes, tools, and best practices that ensure a seamless and efficient data flow, supporting scalable and reliable data systems.
This blog is troubleshooting adventure which navigates networking quirks, uncovers why cluster couldn’t reach PyPI, and find the real fix—without starting from scratch.
Explore query scanning can be optimized from 9.78 MB down to just 3.95 MB using table partitioning. And how to use partitioning, how to decide the right strategy, and the impact it can have on performance and costs.
Dive deeper into query design, optimization techniques, and practical takeaways for BigQuery users.
Wondering when to use a stored procedure vs. a function in SQL? This blog simplifies the differences and helps you choose the right tool for efficient database management and optimized queries.
Discover how BigQuery Omni and BigLake break down data silos, enabling seamless multi-cloud analytics and cost-efficient insights without data movement.
In this article we'll build a motivation towards learning computer vision by solving a real world problem by hand along with assistance with chatGPT
This blog explains how Apache Airflow orchestrates tasks like a conductor leading an orchestra, ensuring smooth and efficient workflow management. Using a fun Romeo and Juliet analogy, it shows how Airflow handles timing, dependencies, and errors.
The blog underscores how snapshots and Point-in-Time Restore (PITR) are essential for data protection, offering a universal, cost-effective solution with applications in disaster recovery, testing, and compliance.
The blog contains the journey of ChatGPT, and what are the limitations of ChatGPT, due to which Langchain came into the picture to overcome the limitations and help us to create applications that can solve our real-time queries
This blog simplifies the complex world of data management by exploring two pivotal concepts: Data Lakes and Data Warehouses.
demystifying the concepts of IaaS, PaaS, and SaaS with Microsoft Azure examples
Discover how Azure Data Factory serves as the ultimate tool for data professionals, simplifying and automating data processes
Revolutionizing e-commerce with Azure Cosmos DB, enhancing data management, personalizing recommendations, real-time responsiveness, and gaining valuable insights.
Highlights the benefits and applications of various NoSQL database types, illustrating how they have revolutionized data management for modern businesses.
Dive into the fundamental concepts and phases of ETL, learning how to extract valuable data, transform it into actionable insights, and load it seamlessly into your systems.
An easy to follow guide prepared based on our experience with upskilling thousands of learners in Data Literacy
Teaching a Robot to Recognize Pastries with Neural Networks and artificial intelligence (AI)
Streamlining Storage Management for E-commerce Business by exploring Flat vs. Hierarchical Systems
Figuring out how Cloud help reduce the Total Cost of Ownership of the IT infrastructure
Understand the circumstances which force organizations to start thinking about migration their business to cloud