Google BigQuery + Klaviyo

Create rows in Google BigQuery for new Klaviyo events

Effortlessly track your Klaviyo events in Google BigQuery with this seamless automation workflow. Whenever a new Klaviyo event occurs, it will instantly create a row in your desired Google BigQuery dataset. Stay organized and easily analyze your event data without any manual intervention.

When this happens...
New Event
Triggers on a new event. Optional filtering by metric.
TriggerScheduled
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?

- Metric
Trigger
Scheduled
Try It
- Channel
Trigger
Scheduled
Try It
- TagRequired
- ListRequired
Action
Write
- List NameRequired
Action
Write
- MetricRequired
- Email AddressRequired
- Event Id
- Value
- Time
- Custom Event Properties
Action
Write

- TagRequired
- ListRequired
Action
Write
- Campaign IDRequired
Action
Write

- List
- Email
- First Name
- Last Name
- Phone Number
- Title
- Organization
- City
- Region
- Country
- Zip
- Image URL
- Unique Id
- Custom Properties
Action
Write
- Email
- Phone Number
- Attributes Note
- Profiles Note
Action
Write
- NameRequired
- ChannelRequired
- Status
Action
Search
- NameRequired
Action
Search
- NameRequired
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

- Audience Type
Trigger
Scheduled
Try It
- Profile IDRequired
- ListRequired
Action
Write
- TagRequired
- SegmentRequired
Action
Write
- Email
- First Name
- Last Name
- Phone Number
- Title
- Organization
- City
- Region
- Country
- Zip
- Image URL
- Unique Id
- Custom Properties
- Consent to subscribe to Channel
Action
Write
- ListRequired
- Profile IDRequired
Action
Write
- TagRequired
- SegmentRequired
Action
Write
- Profile IdRequired
- Email
- First Name
- Last Name
- Phone Number
- Title
- Organization
- City
- Region
- Country
- Zip
- Image URL
- Unique Id
- Custom Properties
- List
Action
Write
- Identifiers Note
- Profile ID
- Email
- Phone Number
- Consent Note
- Consent to subscribe to ChannelRequired
- List
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- NameRequired
Action
Search
- Search NoteRequired
- Email
- Phone Number
- Secondary Search by Phone Number
- List
Action
Search
- Search NoteRequired
- Email
- Phone Number
- Secondary Search by Phone Number
- List
- First Name
- Last Name
- Title
- Organization
- City
- Region
- Country
- Zip
- Image URL
- Unique Id
- Custom Properties
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 Klaviyo

Klaviyo is an email marketing platform. Powered by data, built for ecommerce and web businesses.

Learn more

Related categories

Marketing Automation

Similar apps

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

Related Zap Templates

Create Klaviyo events from new Google BigQuery rows

Related Zap Templates

Create Klaviyo events from new Google BigQuery rows

Google BigQuery + Klaviyo

Create rows in Google BigQuery for new Klaviyo events

New Event

Metric

New Profile

Channel

Add Tag to List

Create List

Create Event

Event Id

Value

Time

Custom Event Properties

Remove Tag From List

Send Campaign

Create Or Update Profile

List

Email

First Name

Last Name

Phone Number

Title

Organization

City

Region

Country

Zip

Image URL

Unique Id

Custom Properties

Unsubscribe Profile

Email

Phone Number

Attributes Note

Profiles Note

Find Campaign

Status

Find Segment

Find Tag

Query Job Completed (With Row Data)

Dataset

Table

New Job Completed

Create Row

Delete Rows

Run a Query

Location

API Request (Beta)

Query String Parameters

Headers

Additional Request Headers

Body

Find Row(s)

Sort By Column

Sort Direction

Find or Create Record

Sort By Column

Sort Direction

Profile added to Segment or List

Audience Type

Add Profile to List

Add Tag to Segment

Create Profile

Email

First Name

Last Name

Phone Number

Title

Organization

City

Region

Country

Zip

Image URL

Unique Id

Custom Properties

Consent to subscribe to Channel

Remove Profile from List

Remove Tag from Segment

Update Profile