Google Calendar

In this section, we present how to connect Google Calendar to MindsDB.

Google Calendar is an online calendar service and application developed by Google. It allows users to create, manage, and share events and appointments, as well as schedule and organize their personal, work, or team activities.

Data from Google Calendar can be utilized within MindsDB to train AI models, make predictions, and automate time management with AI.

​

Prerequisites

Before proceeding, ensure the following prerequisites are met:

1. Install MindsDB locally via Docker or Docker Desktop.
2. To connect Google Calendar to MindsDB, install the required dependencies following this instruction.
3. Install or ensure access to Google Calendar.

​

Connection

The required arguments to establish a connection are as follows:

• credentials_file is a path to the JSON file that stores credentials to the Google account.

In order to make use of this handler and connect the Google Calendar app to MindsDB, the following syntax can be used:

CREATE DATABASE my_calendar
WITH
    ENGINE = 'google_calendar',
    PARAMETERS = {
        'credentials_file': '\path-to-your-file\credentials.json'
    }; 

​

Usage

This creates a database that comes with the calendar table.

Now you can use your Google Calendar data, like this:

• searching for events:

  SELECT id, created_at, author_username, text
  FROM my_calendar.events
  WHERE start_time = '2023-02-16'
  AND end_time = '2023-04-09' LIMIT 20;
  

• creating events:

  INSERT INTO my_calendar.events(start_time, end_time, summary, description, location, attendees, reminders, timeZone)
  VALUES ('2023-02-16 10:00:00', '2023-02-16 11:00:00', 'MindsDB Meeting', 'Discussing the future of MindsDB', 'MindsDB HQ', '', 'Europe/Athens');
  

• updating one or more events:

  UPDATE my_calendar.events
  SET summary     = 'MindsDB Meeting',
      description = 'Discussing the future of MindsDB',
      location    = 'MindsDB HQ',
      attendees   = '',
      reminders   = ''
  WHERE event_id > 1 AND event_id < 10;                   -- used to update events in a given range
  

• deleting one or more events:

  DELETE
  FROM my_calendar.events
  WHERE id = '1';