Cancelling a Google Calendar Event through Jotform

Introduction

Google Calendar is a popular online calendar application used by millions of people worldwide. It allows users to create, manage, and share events with others. Jotform is an online form builder that enables users to create custom forms for various purposes. In this article, we will explore how to cancel a Google Calendar event using a Jotform submission.

Prerequisites

Before we begin, make sure you have the following:

• A Google Calendar account
• A Jotform account
• A form in Jotform that collects the email address of the Google Calendar event organizer

Setting Up the Form

First, create a new form in Jotform or use an existing one that collects the email address of the Google Calendar event organizer. You can add this field by going to the "Form Designer" tab, clicking on "Fields," and selecting "Email" from the list.

Next, create a new submission in Jotform that will trigger the Google Calendar event cancellation. To do this, go to the "Apps" tab, search for "Google Calendar," and install the "Google Calendar" app. Once installed, configure the app to connect to your Google account and select the form that will trigger the cancellation.

Writing the Script

Now, we will write a script that will be executed when the form is submitted. This script will use the Google Calendar API to cancel the event.

Setting Up the Project in Google Cloud Platform

Before we can write the script, we need to set up a new project in Google Cloud Platform and enable the Google Calendar API. Follow these steps:

1. Go to Google Cloud Console and sign in with your Google account.
2. Create a new project or select an existing one.
3. Enable the Google Calendar API for your project.
4. Create an OAuth 2.0 client ID for your project. Make sure to select "Web application" as the application type and provide a valid redirect URI.

Writing the Google Apps Script

Now, we will write the Google Apps Script that will be executed when the form is submitted. Follow these steps:

1. Go to Google Apps Script and sign in with your Google account.
2. Create a new project or select an existing one.
3. Copy and paste the following code into the script editor:

   function cancelEvent(email) {
    const calendar = CalendarApp.getCalendarById("primary");
    const events = calendar.getEventsByUserEmail(email);
    if (events.length > 0) {
    const event = events[0];
    event.delete();
    }
    }
   

4. Replace "primary" with the ID of your Google Calendar.
5. Save the script.

Setting Up the Webhook

Now, we will set up a webhook in Jotform to trigger the Google Apps Script when the form is submitted. Follow these steps:

1. Go to the "Apps" tab in your Jotform form and search for "Webhooks."
2. Add a new webhook and configure it as follows:
• URL: https://script.google.com/macros/d///
• Method: POST
• Content Type: application/json
• Headers: none
• Body: { "email": "<%=email%>" }

Testing the Script

Now, test the script by submitting the form with the email address of the Google Calendar event organizer. The script should cancel the event associated with that email address.

Conclusion

In this article, we explored how to cancel a Google Calendar event using a Jotform submission. We set up a form in Jotform, wrote a script in Google Apps Script, and configured a webhook to trigger the script when the form is submitted. With this setup, you can easily cancel Google Calendar events using Jotform.