← Back to all apps

Google Cloud BigQuery

Productivityby OpenAI

Integrate analytical data into your agent workflows to achieve superior business results. By connecting your agents with BigQuery, you can provide actionable insights directly to them. Move past standard analytics and utilize BigQuery's advanced features, such as forecasting, to generate higher-value intelligence.

13ChatGPT Tools
5Claude Tools
OpenAIDeveloper
ProductivityCategory

Use Cases

data

Available Tools

Batch Read Event

batch_read_event
Full Description

Read multiple Google Calendar events by ID.

Parameters (1 required, 1 optional)
Required
event_idsarray
Optional
calendar_idstring

Calendar ID to query. Use `primary` for the user's main calendar, or an email-like calendar ID containing `@` (for example `team@group.calendar.google.com`). Default is `primary`.

Default: null

Create Event

create_event
Full Description

Create a new Google Calendar event and return its details.

If add_google_meet is true, Google may return a pending conference state before the Meet link is fully provisioned. Re-read the event later if you need finalized conference details.

Parameters (4 required, 13 optional)
Required
attendeesarray

List of attendee emails to invite. The authenticated user's attendance is controlled by `self_attendance`. Pass an empty list for a solo status block. For `outOfOffice`, this must be an empty list.

end_timestring

Event end datetime in full ISO-8601/RFC3339 format (e.g. 2026-05-01T10:00:00-07:00).

start_timestring

Event start datetime in full ISO-8601/RFC3339 format (e.g. 2026-05-01T09:00:00-07:00).

titlestring
Optional
add_google_meetboolean

If true, request a Google Meet link for the event. If conference creation is still pending, re-read the event later to check final Meet details.

Default: null
auto_decline_modestring

Auto-decline behavior for status events

Default: null
chat_statusstring

Chat status for focus time events

Default: null
decline_messagestring

Optional message sent when declining

Default: null
descriptionstring

Description of the event

Default: null
event_typestring

Optional event type. Use `outOfOffice` or `focusTime` for status events. For a personal focus block, prefer `attendees=[]`; use `self_attendance="omit"` if you do not want the authenticated user added as an attendee. For `outOfOffice`, Google Calendar rejects events with attendees, so use `attendees=[]` and `self_attendance="omit"`.

Default: null
locationstring

Location of the event

Default: null
recurrencearray

Optional raw Google/RFC5545 recurrence lines (for example `RRULE:FREQ=WEEKLY;BYDAY=MO`). Omit for one-off events.

Default: null
reminders

Event reminder configuration. Use the calendar defaults when omitted.

Default: null
self_attendancestring

How the authenticated user should be represented on the event they create. Defaults to `accepted`; use `omit` to create the event without adding the authenticated user as an attendee. For `outOfOffice`, this must be `omit`. For a solo `focusTime` block, prefer `omit`.

Options:accepteddeclinedtentativeomit
Default: accepted
timezone_strstring

IANA timezone name such as `America/Los_Angeles` or `Europe/Berlin`. Do not pass UTC offsets like `+02:00`. Default is `America/Los_Angeles`.

Default: null
transparencystring

Optional event transparency. Use `opaque` to block the time as busy, or `transparent` to keep the event from blocking the calendar so overlapping bookings can still be scheduled. Leave null for Google default behavior.

Default: null
visibilitystring

Optional event visibility (`default`, `public`, or `private`). Leave null for Google default behavior.

Default: null

Delete Event

delete_event
Full Description

Remove a Google Calendar event.

Parameters (1 required)
Required
event_idstring

Fetch

fetch
Full Description

Get details for a single Google Calendar event.

Parameters (1 required)
Required
event_idstring

Get Availability

get_availability
Full Description

Look up busy windows on one or more calendars before scheduling a meeting.

Use this action when the user wants availability for a coworker, room, or other known calendar ID. time_min and time_max must be full RFC3339 datetimes with Z or an explicit UTC offset. response_timezone_str controls only how Google formats the busy window timestamps in the response. This action returns busy windows only, not event titles or details, and inaccessible calendars are reported as per-calendar errors.

Parameters (4 required)
Required
calendar_idsarray

List of calendar IDs to query. Use Google Calendar IDs such as `primary`, a coworker email, or a room/resource email.

response_timezone_strstring

Required IANA timezone name used for response timestamps only, such as `America/Los_Angeles` or `Europe/Berlin`. This does not define the query interval.

time_maxstring

Required RFC3339 datetime string with `Z` or an explicit UTC offset (for example `2026-05-01T10:00:00-07:00`). Do not pass naive datetimes and do not pass `now`.

time_minstring

Required RFC3339 datetime string with `Z` or an explicit UTC offset (for example `2026-05-01T09:00:00-07:00`). Do not pass naive datetimes and do not pass `now`.

Get Profile

get_profile
Full Description

Return the current Google Calendar user's profile information.

This action takes no parameters.

Read Event

read_event
Full Description

Read a Google Calendar event by ID.

Parameters (1 required, 1 optional)
Required
event_idstring

Google Calendar event ID, typically from search results.

Optional
calendar_idstring

Calendar ID to query. Use `primary` for the user's main calendar, or an email-like calendar ID containing `@` (for example `team@group.calendar.google.com`). Default is `primary`.

Default: null

Read Event All Fields

read_event_all_fields
Full Description

Read a Google Calendar event with extended Google metadata by ID.

Parameters (1 required, 1 optional)
Required
event_idstring

Google Calendar event ID, typically from search results.

Optional
calendar_idstring

Calendar ID to query. Use `primary` for the user's main calendar, or an email-like calendar ID containing `@` (for example `team@group.calendar.google.com`). Default is `primary`.

Default: null

Respond Event

respond_event
Full Description

Respond to a Google Calendar event invitation.

Parameters (2 required, 2 optional)
Required
event_idstring
response_statusstring

Your response to the event invitation

Options:accepteddeclinedtentative
Optional
notifyboolean

Notify attendees of this response

Default: False
reasonstring

Optional note explaining your response

Default: null

Search

search
Full Description

Search Google Calendar events within an optional time window.

Accepted parameters are only query, max_results, time_min, and time_max. query is broad free text, not a structured search language. Do not pass unsupported fields like topn, timezone_str, calendar_id, user_message, or best_effort_fetch.

Parameters (1 required, 3 optional)
Required
querystring

Broad free-text search over event titles plus some Google-indexed text fields such as descriptions, locations, and some email fields. Reliable for event titles and some email matches, but do not rely on this as a precise attendee-name filter.

Optional
max_resultsinteger

Maximum number of events to return. Must be at least 1.

Default: 50
time_maxstring

Optional window end in full ISO-8601/RFC3339 format (e.g. 2026-05-31T23:59:59Z).

Default: null
time_minstring

Optional window start in full ISO-8601/RFC3339 format (e.g. 2026-05-01T00:00:00Z).

Default: null

Search Events

search_events
Full Description

Look up Google Calendar events using various filters.

query is broad free text, not a structured search language.

Parameters (0 required, 7 optional)
Optional
calendar_idstring

Calendar ID to query. Use `primary` for the user's main calendar, or an email-like calendar ID containing `@` (for example `team@group.calendar.google.com`). Default is `primary`.

Default: null
max_resultsinteger

Maximum number of events to return. Must be at least 1.

Default: 50
next_page_tokenstring

Pagination token returned by a previous search_events/search_events_all_fields call. Omit on the first page.

Default: null
querystring

Broad free-text search over event titles plus some Google-indexed text fields such as descriptions, locations, and some email fields. Do not rely on this as a precise attendee-name filter.

Default: null
time_maxstring

End of the time window. Use full ISO-8601/RFC3339 datetime (for example `2026-05-31T23:59:59Z`) or exact `now`. Do not use relative expressions like `now-7d` or `now+30m`.

Default: null
time_minstring

Start of the time window. Use full ISO-8601/RFC3339 datetime (for example `2026-05-01T00:00:00Z`) or exact `now`. Do not use relative expressions like `now-7d` or `now+30m`.

Default: null
timezone_strstring

Timezone for interpreting time_min/time_max. IANA timezone name such as `America/Los_Angeles` or `Europe/Berlin`. Do not pass UTC offsets like `+02:00`. Default is `America/Los_Angeles`.

Default: null

Search Events All Fields

search_events_all_fields
Full Description

Look up Google Calendar events with extended Google metadata.

Parameters (0 required, 7 optional)
Optional
calendar_idstring

Calendar ID to query. Use `primary` for the user's main calendar, or an email-like calendar ID containing `@` (for example `team@group.calendar.google.com`). Default is `primary`.

Default: null
max_resultsinteger

Maximum number of events to return. Must be at least 1.

Default: 50
next_page_tokenstring

Pagination token returned by a previous search_events/search_events_all_fields call. Omit on the first page.

Default: null
querystring
Default: null
time_maxstring

End of the time window. Use full ISO-8601/RFC3339 datetime (for example `2026-05-31T23:59:59Z`) or exact `now`. Do not use relative expressions like `now-7d` or `now+30m`.

Default: null
time_minstring

Start of the time window. Use full ISO-8601/RFC3339 datetime (for example `2026-05-01T00:00:00Z`) or exact `now`. Do not use relative expressions like `now-7d` or `now+30m`.

Default: null
timezone_strstring

Timezone for interpreting time_min/time_max. IANA timezone name such as `America/Los_Angeles` or `Europe/Berlin`. Do not pass UTC offsets like `+02:00`. Default is `America/Los_Angeles`.

Default: null

Update Event

update_event
Full Description

Update an existing Google Calendar event.

If add_google_meet is true, Google may return a pending conference state before the Meet link is fully provisioned. Re-read the event later if you need finalized conference details.

Parameters (1 required, 19 optional)
Required
event_idstring

Google Calendar event ID, typically from search results.

Optional
add_google_meetboolean

If true, request a Google Meet link for the event. If conference creation is still pending, re-read the event later to check final Meet details.

Default: null
attendeesarray

List of emails of the attendees. Add 'me' to add the current user as an attendee. Leave null or empty to keep the same attendees.

Default: null
attendees_to_addarray

List of attendee email addresses to add to the event. Each entry must be an email address or `me`. Omit or pass an empty list to leave additions unchanged.

Default: null
attendees_to_removearray

List of attendee email addresses to remove from the event. Each entry must be an email address or `me`. Omit or pass an empty list to leave removals unchanged.

Default: null
auto_decline_modestring

Auto-decline behavior for status events

Default: null
chat_statusstring

Chat status for focus time events

Default: null
decline_messagestring

Optional message sent when declining

Default: null
descriptionstring

Description of the event. Leave null to keep the same description.

Default: null
end_timestring

New end datetime in full ISO-8601/RFC3339 format. Leave null to keep the same end time.

Default: null
event_typestring

Type for status events (`focusTime`/`outOfOffice`). Google Calendar does not allow changing an existing event's eventType.

Default: null
locationstring

Location of the event. Leave null to keep the same location.

Default: null
recurrencearray

New raw Google/RFC5545 recurrence lines. Only valid for `entire_series` or `this_and_following`. Omit to leave recurrence unchanged. For `this_and_following`, omitting recurrence reuses the current series rule from the split point onward unless the original rule is COUNT-based.

Default: null
reminders

Reminder configuration. Omit to keep existing reminders.

Default: null
start_timestring

New start datetime in full ISO-8601/RFC3339 format. Leave null to keep the same start time.

Default: null
timezone_strstring

IANA timezone name such as `America/Los_Angeles` or `Europe/Berlin`. Do not pass UTC offsets like `+02:00`. Provide this whenever changing start_time and/or end_time.

Default: null
titlestring

Title of the event. Leave null to keep the same title.

Default: null
transparencystring

Optional event transparency. Use `opaque` to block the time as busy, or `transparent` to keep the event from blocking the calendar so overlapping bookings can still be scheduled. Leave null to keep existing transparency unchanged.

Default: null
update_scopestring

How to apply this update to a recurring event. Use `this_instance` to update only the selected occurrence, `entire_series` to update the recurring series master and apply the change to the whole recurring series, or `this_and_following` to split the recurring series at the selected occurrence and apply changes from there onward. For non-recurring events, `entire_series` behaves the same as `this_instance`.

Options:this_instanceentire_seriesthis_and_following
Default: this_instance
visibilitystring

Optional event visibility (`default`, `public`, or `private`). Leave null to keep existing visibility unchanged.

Default: null