Google Calendar (Service Account) icon

Google Calendar (Service Account)

Access Google Calendar API using Service Account

Actions9

Event → Get Free Slots

AI-generated

Summary

Retrieve available free time slots within a specified date range from a Google Calendar using a service account, considering working hours, slot duration, and optional weekend inclusion.

Inputs

  • Authentication (required) — Select whether to use saved credentials or enter service account credentials manually.
  • Service Account Email (required) — Email address of the service account (required if manual authentication is chosen).
  • Private Key (required) — Private key from the service account JSON (required if manual authentication is chosen).
  • Impersonate Email — Email to impersonate (requires domain-wide delegation and manual auth).
  • Calendar ID (required) — Identifier of the calendar to query (use 'primary' for the primary calendar).
  • Search Range (days) (required) — Number of days ahead to look for free slots.
  • Slot Duration (minutes) (required) — Length of each available slot in minutes.
  • Working Hours Start (required) — Start hour in 24-hour format (0-23) for the working day.
  • Working Hours End (required) — End hour in 24-hour format (0-23) for the working day.
  • Timezone (required) — Timezone of the calendar to correctly calculate slot times.
  • Options: Include Weekends — Whether to include Saturday and Sunday as working days (default false).
  • Options: Max Slots — Maximum number of free slots to return (default 10).

Output shape

a single JSON object containing a list of available free time slots with their start and end timestamps, local date and time strings, total number of slots found, and parameters used for the search.

The free slots exclude times overlapping with busy calendar events. Weekends can be optionally included. The output lists up to the specified maximum number of slots. Time calculations respect the given timezone and working hours.

Examples

Example 1: Find up to 5 free one-hour slots in the next 7 days within working hours 9am to 5pm, excluding weekends on a user's primary calendar.

Authentication: Credential; Calendar ID: primary; Search Range (days): 7; Slot Duration: 60; Working Hours Start: 9; Working Hours End: 17; Timezone: America/New_York; Include Weekends: False; Max Slots: 5

Discussion