# Google Calendar

Google Calendar is a time-management and scheduling tool that lets you create events, manage multiple calendars, and track availability. Connecting it to Coupler.io lets you export your calendar data automatically — no manual downloads or CSV exports needed.

## Why connect Google Calendar to Coupler.io?

* **Automate reporting** — pull events and availability data into Google Sheets, Excel, or BigQuery on a schedule
* **Visualize your calendar** — send data to Looker Studio or Power BI to build time-tracking and capacity dashboards
* **Analyze with AI** — route calendar data to ChatGPT, Claude, Gemini, or other AI destinations to summarize schedules, identify patterns, or generate insights
* **Combine data sources** — use Append or Join transformations to merge calendar data with CRM, project, or HR data for richer analysis

## Prerequisites

* A Google account with access to the calendars you want to export
* Read access to any shared or team calendars you plan to pull from

## Quick start

{% hint style="success" %}
If you want to pull events from multiple calendars (for example, a team calendar and a personal one), set up separate sources in the same data flow and use the **Append** transformation to combine them into one dataset.
{% endhint %}

## How to connect

{% stepper %}
{% step %}
**Create a new data flow and add Google Calendar as a source.** In Coupler.io, click **Add data flow**, then search for and select **Google Calendar**.
{% endstep %}

{% step %}
**Authorize your Google account.** Click **Sign in with Google** and grant Coupler.io permission to read your calendar data. You'll be redirected back automatically after authorizing.
{% endstep %}

{% step %}
**Choose a data entity.** Select what you want to export: **List of my calendars**, **List of events**, or **Report: busy time for user**. If you choose Events or the Free/Busy report, you'll also need to select which calendar(s) to pull from and set a date range using the date pickers.
{% endstep %}

{% step %}
**Choose a destination.** Select where you want your data to land — Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination like ChatGPT, Claude, or Gemini.
{% endstep %}

{% step %}
**Run your data flow.** Click **Run** to execute a manual run and confirm your data loads correctly before setting up a schedule.
{% endstep %}
{% endstepper %}

## Available entities

| Entity                     | What it returns                                     |
| -------------------------- | --------------------------------------------------- |
| List of my calendars       | All calendars in your Google account                |
| List of events             | Events from a specific calendar within a date range |
| Report: busy time for user | Free/busy availability across one or more calendars |