Skip to content

Integrate Google BigQuery with Shopify to automate your work

Start with Google for free

1. Choose a Trigger

An event that starts an automation

2. Choose an Action

The event an automation performs after it's triggered

Endless possibilities

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

How Zapier works

Zapier makes it easy to integrate Google BigQuery with Shopify - no code necessary. See how you can get setup in minutes.

Select a trigger from Google BigQuery

A trigger is an event that starts your Zap and runs the workflow. For example, with Google BigQuery, a trigger could be "Query Job Completed (With Row Data)."

A trigger is the event that kicks off your automated workflow.

Setup an action from Shopify

An action is what takes place after the automation is triggered. For example, with Shopify, the action could be "Add Line Item to Order."

An action is the event that your automated workflow performs when triggered.

That’s it! You just connected Google BigQuery to Shopify

With Zapier, it’s never been easier to connect your apps together and automate your most tedious work. Save hours every month.

Triggers and actions are the main components of every automated workflow.

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

G2 Badge - Best Est. ROI - Winter 2024

G2 Badge - Best Results - Winter 2024

G2 Badge - Most Implementable - Winter 2024

G2 Badge - Leader Mid-Market - Winter 2024

93%

Customers who say using Zapier has made them better at their job

25m

Customers have created over 25 million Zaps on the platform

6 mins

The average user takes less than 6 minutes to set up a Zap

Set up your first integration

Quickly connect Google BigQuery to Shopify with a Zapier template.

Our most popular template

Track new cancelled Shopify orders by creating rows in Google BigQuery
Premium
Details
Try it
Shopify + Google BigQuery
Add new paid orders in Shopify to rows in Google BigQuery
Premium
Details
Try it
Shopify + Google BigQuery
Save Shopify Sales to BigQuery
Premium
Details
Try it
Shopify + Google BigQuery
Create rows in Google BigQuery for every new customer in Shopify
Premium
Details
Try it
Shopify + Google BigQuery
Create rows in Google BigQuery for new products in Shopify
Premium
Details
Try it
Shopify + Google BigQuery
Create rows in Google BigQuery for every new order in Shopify
Premium
Details
Try it
Shopify + Google BigQuery

Track new cancelled Shopify orders by creating rows in Google BigQuery

Premium

Shopify + Google BigQuery

Add new paid orders in Shopify to rows in Google BigQuery

Premium

Shopify + Google BigQuery

Save Shopify Sales to BigQuery

Premium

Shopify + Google BigQuery

Create rows in Google BigQuery for every new customer in Shopify

Premium

Shopify + Google BigQuery

Create rows in Google BigQuery for new products in Shopify

Premium

Shopify + Google BigQuery

Create rows in Google BigQuery for every new order in Shopify

Premium

Shopify + Google BigQuery

Create rows in Google BigQuery for new paid orders in Shopify
Premium
Details
Try it
Shopify + Google BigQuery
Create new rows in Google BigQuery for new products in Shopify
Premium
Details
Try it
Shopify + Google BigQuery

Make work flow with AI

Level up your Google BigQuery to Shopify integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.

Illustration of AI enhancing Zapier workflows with automation and app integrations.

Connect Google BigQuery and Shopify to integrate crucial parts of your business

With Zapier, you can integrate everything from basic data entry to end-to-end processes. Here are some of the business-critical workflows that people automate with Zapier.

Automate your lead management and improve conversions

With Zapier, you can automate every part of your lead funnel and give yourself the best chance at converting leads. Automate everything from lead capture to outreach to reporting—and close more deals as a result.

An illustration representing how to automate lead management with Zapier.

Create more impactful campaigns with automation

Measuring campaign performance across platforms can get chaotic. Plus, digging up the right metrics costs you precious time and effort. With Zapier, you can create a centralized view of your performance, skillfully manage your lists, and ensure your campaigns drive ROI across the business.

An illustration representing how to measure campaign impact with Zapier.

Provide world-class support with a little help from automation

Support reps can't be productive when they have to track down crucial information for every incident or ticket. With Zapier, you can automatically send your reps the context they need to resolve tickets quickly and create a seamless customer experience.

An illustration representing how to automate customer support with Zapier.

Automate your way to actionable, up-to-date data

The days of manually exporting and importing data are over. With Zapier, you can send data where it needs to go, in the format you need it—so you can centralize your data and unlock more insights.

An illustration representing how to move and manage data with Zapier.

Resolve incidents faster with automation

Your technical support team wants to focus on tech tickets rather than admin work. With Zapier, you can automate everything from ticket creation to routing to inter-team communication—eliminating friction from incident management and increasing speed to resolution.

An illustration of a flow chart representing how to resolve tickets and incidents with Zapier.

Connect Google BigQuery and Shopify to unlock the power of automation

With Zapier's 7,000 integrations, you can unify your tools within a connected system to improve your team's efficiency and deepen their impact.

Choose a Trigger

Start here

Start here

Choose an Action

Supported triggers and actions

Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.

- Project ID
  Required
- Dataset
  Required
- Table
  Required
Trigger
Scheduled
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Scheduled
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
  Required
Action
Write

- HTTP Method
  Required
- URL
  Required
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Sort Direction
- Where Clause
  Required
- Limit
  Required
Action
Search

- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Sort Direction
- Where Clause
  Required
Action
Search or write
- Blog
  Required
- Blog Entry Status
Trigger
Scheduled
Try It
Customer Account Enabled
Triggers when a customer account is enabled.
Trigger
Instant
Try It
- Abandoned Cart Age (Hours)
  Required
Trigger
Scheduled
Try It
New Draft Order
Triggers when a new draft order is created
Trigger
Instant
Try It
New Order
Triggers when an order is created (with line item support).
Trigger
Instant
Try It
New Product
Triggers when a product is created.
Trigger
Instant
Try It
New Tag Added to Customer
Triggers when a new tag is added to a customer.
Trigger
Scheduled
Try It
- Inventory Item
Trigger
Instant
Try It
Updated Product
Triggers when a Product is updated, ordered or when a variant is added, removed, or updated.
Trigger
Instant
Try It
- Customer
  Required
- Tags
  Required
- Overwrite existing tags?
Action
Write
- Name
  Required
- ExternalId
- A note about the company
- Company_contact
- Contact Email
- Contact First Name
- Contact Last Name
- Contact Phone
- Title
  Required
- Contact_locale
- Location
  Required
- Billing same as shipping address?
- Company_shippingAddress
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address Country Code
- Shipping_firstName
- Shipping_lastName
- Shipping Address Phone
- Shipping Address Recipient
- Shipping Address Zip
- Shipping Address Zone Code
- Location External ID
- Location_locale
- Location_name
- Location_note
- Location_phone
- TaxRegistrationId
Action
Write
- First Name
- Last Name
- Contact Email
- Customer Phone
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Contact Phone
- Tags
  Required
- A note about the company
- Accepts Marketing
- Tax Exempt
- Tax Exemptions
- Send E-Mail Invite
Action
Write
- Order ID
  Required
- Fulfillment Order ID
  Required
- Notify Customer
- Address Line 1
- Street Address Line 2
- City
- Country Code
- State/Province Code
- Zip Code
- Tracking Company
- Tracking Number
- Tracking URL
Action
Write
- Contact Email
- Product
  Required
- Product Variant
- SKU (Stock Keeping Unit)
- Product Quantity
- Title
  Required
- Price
- Weight in Grams
- Price
- Rate
- Title
- A note about the company
- Discount - Type
- Discount - Amount
- Discount - Code
- Additional Details
- Tags
  Required
- 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
  Required
- Inventory_behaviour
- Financial_status
- Fulfillment Status
- Code
- Title
- Price
- Discounted Price
- Source
Action
Write
- Product
  Required
- Channel ID
  Required
- Publish Date
Action
Write
- Order ID
  Required
- Amount
- Currency
- Type
- Parent Transaction
- Warning
- Gateway
Action
Write
- Order ID
  Required
- Contact Email
- A note about the company
- Contact Phone
- Buyer Accepts Marketing?
- Remove Customer from Order?
- Tags
  Required
- Additional Details
- Shipping Address - Address
- Shipping Address - Address con't
- 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 - State/Province/Region
- Shipping Address - State/Province/Region Code
- Shipping Address - Postal/Zip code
Action
Write
- Product
  Required
- Title
  Required
- Product_type
  Required
- Vendor
  Required
- Payment Status
- Product Description
- Tags
  Required
- Category
- Collections to Join
- Collections to Leave
- Handle
- Redirect Handle?
- Alt Text
- Media Content Type
- Original Source
Action
Write
- Name
  Required
- Contact Email
Action
Search
- Order ID
  Required
Action
Search
- Order ID
  Required
Action
Search
- Product Titles
  Required
Action
Search
- Product Titles
  Required
Action
Search
- Product
  Required
- Title
  Required
- Exact Match
  Required
Action
Search
- Title
  Required
- Product_type
  Required
- Vendor
  Required
- Content
  Required
- Tags
  Required
- Published At
- Price
- Inventory Policy
- Image URL
- More Image URLs
- SKU (Stock Keeping Unit)
- Is Published?
- Publish to Point of Sale
Action
Search or write

- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Scheduled
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Scheduled
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Sort Direction
- Where Clause
  Required
Action
Search
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search
New Blog
Triggers when a new blog is added to your Shopify store.
Trigger
Scheduled
Try It
New Customer
Triggers when a new customer is added to your Shopify account.
Trigger
Scheduled
Try It
- Risk Level
Trigger
Scheduled
Try It
New Cancelled Order
Triggers whenever an order is cancelled (with line item support).
Trigger
Instant
Try It
New Fulfilled Order
Triggers when an order is fulfilled (with line item support).
Trigger
Instant
Try It
New Paid Order
Triggers when an order is paid (with line item support).
Trigger
Instant
Try It
New Refund
Triggers when a refund or partial refund occurs.
Trigger
Instant
Try It
Updated Customer
Triggers when a customer's information is updated.
Trigger
Instant
Try It
Updated Order
Triggers when an order is updated (with line item support).
Trigger
Instant
Try It
- Order ID
  Required
- Type of Line Item to Add
  Required
- Reason for Edit
- Notify the Customer?
Action
Write
- Blog
  Required
- Title
  Required
- Author Name
  Required
- Content
  Required
- Featured Image URL
- Excerpt/Summary
- Tags
  Required
- Is Published?
Action
Write
- Product ID
  Required
- 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
Action
Write
- Contact Email
- Product
  Required
- Product Variant
- Product Quantity
- Title
  Required
- Price
- Weight in Grams
- A note about the company
- Discount - Type
- Discount - Amount
- Discount - Code
- Additional Details
- Tags
  Required
- 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
Action
Write
- Adjust or Set quantity?
  Required
- Name
  Required
- The reason for the quantity changes
  Required
- Location
  Required
- Product
  Required
- Product Variant
  Required
- Product Quantity
Action
Write
- Title
  Required
- Product_type
  Required
- Vendor
  Required
- Payment Status
- Product Description
- Tags
  Required
- Collection ID
- Handle
- A note about the company
- First Product Option
- Values for First Product Option
- Second Product Option
- Values for Second Product Option
- Third Product Option
- Values for Third Product Option
- Category
- Alt Text
- Media Content Type
- Original Source
Action
Write
- Customer
  Required
- Tags
  Required
Action
Write
- Customer
  Required
- First Name
- Last Name
- Contact Email
- Company Name
- Default Address
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Tags
  Required
- Contact Phone
- A note about the company
- Tax Exempt
- Tax Exemptions
- Accepts Marketing
Action
Write
- Product
  Required
- Product Variant
- Title
  Required
- Price
- Compare at Price
- SKU (Stock Keeping Unit)
Action
Write
- HTTP Method
  Required
- URL
  Required
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Query - Name
- Query - Confirmation Number
- Query - Email
- Query - Customer ID
- Query - Location ID
- Query - SKU
- Query - Order ID
- Sort Key
- Reverse?
- Raw Query
Action
Search
- Owner_resource
  Required
- Owner_id
  Required
Action
Search
- Ids
  Required
Action
Search
- Title
  Required
Action
Search
- SKU (Stock Keeping Unit)
Action
Search
- Name
  Required
- Contact Email
- First Name
- Last Name
- Customer Phone
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Contact Phone
- Tags
  Required
- A note about the company
- Accepts Marketing
- Tax Exempt
- Tax Exemptions
- Send E-Mail Invite
Action
Search or write
- Product
  Required
- Title
  Required
- Exact Match
  Required
- Price
- Compare at Price
- SKU (Stock Keeping Unit)
- Inventory Policy
Action
Search or write

Learn how to automate Google BigQuery on the Zapier blog

Automate Shopify: get inspired on the Zapier blog

About Google BigQuery

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

Learn more Help

Related categories

About Shopify

Shopify is a simple way to create an online store to list products, collect credit card payments, and ship your goods.

Learn more Help

Related categories

eCommerce

Connect Google BigQuery to Shopify on the world's largest no-code automation platform

Sign up with Google