Google BigQuery + Google Calendar

Add new Google Calendar events to Google BigQuery as rows

Efficiently manage your events and data analysis with this seamless workflow between Google Calendar and Google BigQuery. When a new event is added to your Google Calendar, a row is instantly created in Google BigQuery, ensuring all important details are captured and ready for analysis. Streamline your event tracking and data reporting with this easy-to-use automation.

When this happens...
New Event
Triggers when an event is created.
TriggerInstant
automatically do this!
Create Row
Creates a new row of data in a table. Note: Does not create a job.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

New Calendar
Triggers when a calendar is created.
Trigger
Scheduled
Try It
- CalendarRequired
- Search Term
Trigger
Scheduled
Try It
- CalendarRequired
- Expand Recurring Events
Trigger
Instant
Try It
- CalendarRequired
- Search TermRequired
Trigger
Scheduled
Try It
- NameRequired
- Description
Action
Write

- CalendarRequired
- Summary
- Description
- Location
- Add Conferencing?
- Start Date & TimeRequired
- End Date & TimeRequired
- Repeat Frequency
- Repeat Until
- Repeat How Many Times?
- All day
- Color
- Attendees
- Visibility
- Use Default Reminders?
- Reminders
- Minutes Before Reminders
- Show me as Free or Busy
- Guests Can Modify Event
- Event Type
Action
Write
- CalendarRequired
- EventRequired
- Summary
- Description
- Location
- Start Date & Time
- End Date & Time
- Repeat Frequency
- Repeat Until
- Repeat How Many Times?
- All day
- Color
- Attendees
- Visibility
- Use Default Reminders?
- Reminders
- Minutes Before Reminders
- Show me as Free or Busy
Action
Write

- CalendarRequired
- Event IDRequired
Action
Search
- CalendarRequired
- Expand Recurring Events
- Search Term
- Start Time Before
- End Time After
Action
Search
- ProjectRequired
- Dataset
- Table
Trigger
Scheduled
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Scheduled
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
- LimitRequired
Action
Search
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search or write

- CalendarRequired
Trigger
Scheduled
Try It
- CalendarRequired
- Time Before
- Time Before (Unit)
- Search Term
Trigger
Scheduled
Try It
- CalendarRequired
Trigger
Instant
Try It
- CalendarRequired
- EventRequired
- Attendee/sRequired
Action
Write
- CalendarRequired
- EventRequired
- Notify Attendees?
Action
Write
- CalendarRequired
- Describe EventRequired
- Attendees
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- CalendarRequired
- Expand Recurring Events
- Search Term
- Start Time Before
- End Time After
Action
Search
- CalendarRequired
- Expand Recurring Events
- Search Term
- Start Time Before
- End Time After
- Summary
- Description
- Location
- Add Conferencing?
- Start Date & TimeRequired
- End Date & TimeRequired
- Repeat Frequency
- Repeat Until
- Repeat How Many Times?
- All day
- Color
- Attendees
- Visibility
- Use Default Reminders?
- Reminders
- Minutes Before Reminders
- Show me as Free or Busy
- Guests Can Modify Event
- Event Type
Action
Search or write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Scheduled
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Scheduled
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
- Update ColumnsRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search
- Project IDRequired
- Job IDRequired
- LocationRequired
Action
Search

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn more

Related categories

About Google Calendar

Google Calendar lets you organize your schedule and share events with co-workers and friends. With Google's free online calendar, it's easy to keep track of your daily schedule.

Learn more

Google BigQuery + Google Calendar

Add new Google Calendar events to Google BigQuery as rows

New Calendar

Event Ended

New or Updated Event

New Event Matching Search

Create Calendar

Create Detailed Event

Update Event

Retrieve Event by ID

Find Multiple Events

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Find Row(s)

Find or Create Record

Event Cancelled

Event Start

New Event

Add Attendee/S to Event

Delete Event

Quick Add Event

API Request (Beta)

Find Event

Find or Create Event

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Get Rows for Job Completed

About Google BigQuery

Related categories

About Google Calendar

Related categories

Similar apps

Appointlet

Acuity Scheduling

Microsoft Office 365