Google BigQuery + WooCommerce

Execute queries in Google BigQuery for new orders in WooCommerce

Enhance your data analysis and tracking of WooCommerce orders by using this workflow with the Google BigQuery platform. As soon as a new order is registered in WooCommerce, this automation initiates a query in Google BigQuery, letting you update, organize and scrutinize your data in real-time. It's an efficient solution for eCommerce businesses looking to streamline their data management process, and promptly respond to market trends.

When this happens...
Order
Triggers when any Order is created, updated, deleted, etc.
TriggerInstant
automatically do this!
Run a Query
Runs a SQL query against a table in BigQuery.
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

- Trigger RuleRequired
Trigger
Instant
Try It
- Trigger RuleRequired
Trigger
Instant
Try It
- Trigger RuleRequired
Trigger
Instant
Try It
- Trigger RuleRequired
Trigger
Instant
Try It
- Trigger RuleRequired
Trigger
Instant
Try It

- Trigger RuleRequired
Trigger
Instant
Try It
Update Coupon
Updates an existing Coupon.
Action
Write

Update Customer
Updates an existing Customer.
Action
Write
Create Order Note
Creates a new Order Note.
Action
Write
Create Product
Creates a new Product or Variation.
Action
Write
Update Product Stock Quantity
Manage the stock quantity and stock status of an existing Product or Variation by SKU or ID.
Action
Write
Create Subscription
Creates a new Subscription.
Action
Write
Update Subscription
Updates an existing Subscription.
Action
Write
Update User Membership
Updates an existing User Membership.
Action
Write
Find Coupon
Finds a Coupon by searching.
Action
Search
Find Membership Plan
Finds a Membership Plan by searching.
Action
Search
Find Order
Finds an Order by searching.
Action
Search
Find Subscription Note
Finds a Subscription Note by searching.
Action
Search
Find User Membership
Finds a User Membership by searching.
Action
Search
Find or Create Customer
Finds a Customer by searching.
Action
Search or write
Find or Create Order
Finds an Order by searching.
Action
Search or write
Find or Create Subscription Note
Finds a Subscription Note by searching.
Action
Search or write
Find or Create User Membership
Finds a User Membership by searching.
Action
Search or write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Polling
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Polling
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
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search or write

- Trigger RuleRequired
Trigger
Instant
Try It
- Trigger RuleRequired
Trigger
Instant
Try It
- Trigger RuleRequired
Trigger
Instant
Try It
- Trigger RuleRequired
Trigger
Instant
Try It
- Trigger RuleRequired
Trigger
Instant
Try It
Create Coupon
Creates a new Coupon.
Action
Write
Create Customer
Creates a new Customer.
Action
Write
Create Order
Creates a new Order.
Action
Write
Update Order
Updates an existing Order.
Action
Write
Update Product Price
Manage the regular price or sale price of an existing Product or Variation by SKU or ID.
Action
Write
Update Product
Updates an existing Product or Variation.
Action
Write
Create Subscription Note
Creates a new Subscription Note.
Action
Write
Create User Membership
Creates a new User Membership.
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
Find Customer
Finds a Customer by searching.
Action
Search
Find Order Note
Finds an Order Note by searching.
Action
Search
Find Product
Finds a Product or Variation by searching.
Action
Search
Find Subscription
Finds a Subscription by searching.
Action
Search
Find or Create Coupon
Finds a Coupon by searching.
Action
Search or write
Find or Create Order Note
Finds an Order Note by searching.
Action
Search or write
Find or Create Product
Finds a Product or Variation by searching.
Action
Search or write
Find or Create Subscription
Finds a Subscription by searching.
Action
Search or write
- ProjectRequired
- Dataset
- Table
Trigger
Polling
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- 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 WooCommerce

WooCommerce is the eCommerce platform for WordPress. This connection requires a paid extension.

Learn more

Related categories

Related Zap Templates

Create rows in Google BigQuery for new orders in WooCommerce

Create rows in Google BigQuery for new WooCommerce subscriptions

Google BigQuery + WooCommerce

Execute queries in Google BigQuery for new orders in WooCommerce

Booking

Customer

Order

Order Note

Subscription

User Membership

Update Coupon

Update Customer

Create Order Note

Create Product

Update Product Stock Quantity

Create Subscription

Update Subscription

Update User Membership

Find Coupon

Find Membership Plan

Find Order

Find Subscription Note

Find User Membership

Find or Create Customer

Find or Create Order

Find or Create Subscription Note

Find or Create User Membership

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

Coupon

Membership Plan

Line Item in an Order

Product

Subscription Note

Create Coupon

Create Customer

Create Order

Update Order

Update Product Price

Update Product

Create Subscription Note

Create User Membership

API Request (Beta)

Find Customer

Find Order Note

Find Product

Find Subscription

Find or Create Coupon

Find or Create Order Note

Find or Create Product

Find or Create Subscription

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Get Rows for Job Completed

About Google BigQuery

Related categories

About WooCommerce

Related categories

Related Zap Templates

Related Zap Templates