Google BigQuery + Shopify
Create rows in Google BigQuery when new orders occur in Shopify
Manage your Shopify orders effortlessly with this automation that keeps your Google BigQuery records up-to-date. This workflow launches as soon as a new order comes in Shopify, immediately creating a corresponding row in Google BigQuery. With your order data assembled in one place, you gain the power to analyze and optimize your sales strategy more efficiently.
Manage your Shopify orders effortlessly with this automation that keeps your Google BigQuery records up-to-date. This workflow launches as soon as a new order comes in Shopify, immediately creating a corresponding row in Google BigQuery. With your order data assembled in one place, you gain the power to analyze and optimize your sales strategy more efficiently.
- When this happens...
New OrderTriggers when a new purchase is made (only open orders) (with line item support).
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create RowsCreates new rows of data in a table (accepts line items). Note: Does not create a job.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Blog
Triggers when a new blog is added to your Shopify store.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Customer
Triggers when a new customer is added to your Shopify account.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planAbandoned Cart Age (Hours)Required
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Draft Order
Triggers when a new draft order is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Order
Triggers when an order is created (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Product
Triggers when a product is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Tag Added to Customer
Triggers when a new tag is added to a customer.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Order
Triggers when an order is updated (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.BlogRequired
TitleRequired
Author NameRequired
ContentRequired
Featured Image URL
Excerpt/Summary
Tags
Is Published?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
Email AddressRequired
Company Name
Street Address
Street Address Line 2
City
State
State/Province Code
Country
Zip Code
Phone
Tags
Note
Accepts Marketing
Tax Exempt
Send E-Mail Invite
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LocationRequired
ProductRequired
Product VariantRequired
Adjust Quantity By
Set Quantity To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Product TypeRequired
VendorRequired
Product Description
Tags
Published At
Price
Inventory Policy
Image URL
More Image URLs
SKU
Is Published?
Publish to Point of Sale
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Email
Notes
Phone
Buyer Accepts Marketing?
Remove Customer from Order?
Tags
Additional Details
Shipping Address - Line 1
Shipping Address - Line 2
Shipping Address - City
Shipping Address - Company
Shipping Address - Country
Shipping Address - First Name
Shipping Address - Last Name
Shipping Address - Latitude
Shipping Address - Longitude
Shipping Address - Name
Shipping Address - Phone
Shipping Address - Province
Shipping Address - Province Code
Shipping Address - ZIP
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
Product VariantRequired
Title
Price
Compare at Price
SKU
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Get specific order by ID
Get details of an order using Order ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProductRequired
Product Variant TitleRequired
Exact MatchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct TitleRequired
Product TypeRequired
VendorRequired
Product Description
Tags
Published At
Price
Inventory Policy
Image URL
More Image URLs
SKU
Is Published?
Publish to Point of Sale
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProductRequired
TitleRequired
Exact MatchRequired
Price
Compare at Price
SKU
Inventory Policy
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProject IDRequired
DatasetRequired
TableRequired
Sort By ColumnRequired
Unique ColumnRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planProject IDRequired
DatasetRequired
TableRequired
Unique ColumnRequired
ValueRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planProjectRequired
DatasetRequired
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
DatasetRequired
TableRequired
RowsRequired
Skip Invalid Rows
Ignore Unknown Values
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
DatasetRequired
TableRequired
Where ColumnRequired
Where ValueRequired
Update ColumnsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
DatasetRequired
TableRequired
Sort By Column
Sort Direction
Where ClauseRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
Job IDRequired
LocationRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
Customer Account Enabled
Triggers when a customer account is enabled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Cancelled Order
Triggers whenever an order is cancelled (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Fulfilled Order
Triggers when an order is fulfilled (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Paid Order
Triggers when an order is paid (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Refund
Triggers when a refund or partial refund occurs.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Customer
Triggers when a customer's information is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Product
Triggers when a Product is updated, ordered or when a variant is added, removed, or updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product IDRequired
Add New Image - File
Add New Image - Alt Text
Choose Existing Image
Price
Compare-at Price
Charge Tax On This Variant?
Cost Per Item
SKU (Stock Keeping Unit)
Barcode (ISBN, UPC, GTIN, etc.)
Track Quantity?
Continue Selling When Out of Stock?
This Is a Physical Product
Weight
Weight Unit
Country/Region of Origin
Harmonized System (HS) code
Position
Requires Components
Tax Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Product
Product Variant
Product Quantity
Product Title
Product Price
Weight in Grams
Note
Discount - Type
Discount - Amount
Discount - Code
Additional Details
Tags
Shipping Address Instructions
Shipping Address - First name
Shipping Address - Last name
Shipping Address - Company
Shipping Address - Phone
Shipping Address - Address
Shipping Address - Address con't
Shipping Address - City
Shipping Address - Country
Shipping Address - State/Province/Region
Shipping Address - Postal/Zip code
Billing Address Instructions
Billing Address - First name
Billing Address - Last name
Billing Address - Company
Billing Address - Phone
Billing Address - Address
Billing Address - Address con't
Billing Address - City
Billing Address - Country
Billing Address - State/Province/Region
Billing Address - Postal/Zip code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Product
Product Variant
SKU
Product Quantity
Product Title
Product Price
Weight in Grams
Price
Rate
Title
Note
Discount - Type
Discount - Amount
Discount - Code
Additional Details
Tags
Buyer Accepts Marketing?
Shipping Address Instructions
Shipping Address - First name
Shipping Address - Last name
Shipping Address - Company
Shipping Address - Phone
Shipping Address - Address
Shipping Address - Address con't
Shipping Address - City
Shipping Address - Country
Shipping Address - Country Code
Shipping Address - State/Province/Region
Shipping Address - State/Province/Region Code
Shipping Address - Postal/Zip code
Billing Address Instructions
Billing Address - First name
Billing Address - Last name
Billing Address - Company
Billing Address - Phone
Billing Address - Address
Billing Address - Address con't
Billing Address - City
Billing Address - Country
Billing Address - Country Code
Billing Address - State/Province/Region
Billing Address - State/Province/Region Code
Billing Address - Postal/Zip code
Send Receipt
Send Fulfillment Receipt
Location
Inventory Behaviour
Financial Status
Fulfillment Status
Code
Title
Price
Discounted Price
Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
First Name
Last Name
Email Address
Tags
Phone Number
Note
Tax Exempt
Accepts Marketing
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
Title
Product Type
Vendor
Product Description
Tags
Price
Images
SKU
Inventory Policy
Is Published?
Publish to Point of Sale
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appOwner ResourceRequired
Owner IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appIdsRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct Variant SKURequired
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Email AddressRequired
First NameRequired
Last NameRequired
Company Name
Street Address
Street Address Line 2
City
State
State/Province Code
Country
Zip Code
Phone
Tags
Note
Accepts Marketing
Tax Exempt
Send E-Mail Invite
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProduct TitleRequired
Product TypeRequired
VendorRequired
Product Description
Tags
Published At
Price
Inventory Policy
Image URL
More Image URLs
SKU
Is Published?
Publish to Point of Sale
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProjectRequired
Dataset
Table
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planProject IDRequired
Job IDRequired
LocationRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planProjectRequired
DatasetRequired
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
DatasetRequired
TableRequired
Where ColumnRequired
Where ValueRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
SQL QueryRequired
Location
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
DatasetRequired
TableRequired
Sort By Column
Sort Direction
Where ClauseRequired
LimitRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProjectRequired
DatasetRequired
TableRequired
Sort By Column
Sort Direction
Where ClauseRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google BigQuery
BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.
About Shopify
Shopify is a simple way to create an online store to list products, collect credit card payments, and ship your goods.