BigCommerce + Google BigQuery

BigCommerce + Google BigQuery integrations

Create rows in Google BigQuery for new BigCommerce orders

Streamline your order management process by automatically adding new BigCommerce orders to a Google BigQuery table. With this workflow, every time a new order is created in BigCommerce, a new row will be instantly inserted into your BigQuery table, helping you keep your order data organized and up-to-date. This seamless automation saves you time and ensures accurate data tracking for better business insights.

When this happens...
Order CreatedTriggers when a new order is created.
TriggerInstant
automatically do this!
Create RowCreates a new row of data in a table. Note: Does not create a job.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with BigCommerce and Google BigQuery

Discover other triggers and actions you can use with BigCommerce and Google BigQuery

- Filter by Channel ID
Trigger
Instant
Try It
Customer Created
Triggers when an new customer is created.
Trigger
Instant
Try It
- Filter by Channel ID
- Filter by Status ID
Trigger
Instant
Try It
Shipment Created
Triggers when a new shipment is created.
Trigger
Instant
Try It
Customer Address Updated
Triggers when a customer address is updated.
Trigger
Instant
Try It

Order Status Updated
Triggers when an order status have changed.
Trigger
Instant
Try It
- Email
  Required
- First Name
  Required
- Last Name
  Required
- Company
- Phone
- Registration IP Address
- Notes
- Tax Exempt Category
- Customer Group ID
- ID
- Force Password Reset
- New Password
- Accepts Product Review Abandoned Cart Emails
- Store Credit Amounts
- Origin Channel ID
- Channel IDs
- Name
- Value
Action
Write

- Name
  Required
- Type
  Required
- Sku
- Description
- Weight
  Required
- Width
- Depth
- Height
- Price
  Required
- Cost_price
- Retail_price
- Sale_price
- Map_price
- Tax_class_id
- Product_tax_code
- Categories
- Brand_id
- Inventory_level
- Inventory_warning_level
- Inventory_tracking
- Fixed_cost_shipping_price
- Is_free_shipping
- Is_visible
- Is_featured
- Related_products
- Warranty
- Bin_picking_number
- Layout_file
- Upc
- Search_keywords
- Availability_description
- Availability
- Gift_wrapping_options_type
- Gift_wrapping_options_list
- Sort_order
- Condition
- Is_condition_shown
- Order_quantity_minimum
- Order_quantity_maximum
- Page_title
- Meta_keywords
- Meta_description
- View_count
- Preorder_release_date
- Preorder_message
- Is_preorder_only
- Is_price_hidden
- Price_hidden_label
- Url
- Is_customized
- Open_graph_type
- Open_graph_title
- Open_graph_description
- Open_graph_use_meta_description
- Open_graph_use_product_name
- Open_graph_use_image
- Gtin
- Mpn
- Reviews_rating_sum
- Reviews_count
- Total_sold
- Custom Fields ID
- Custom Fields Name
  Required
- Custom Fields Value
  Required
- Bulk Pricing Rules ID
- Bulk Pricing Rules Quantity Min
- Bulk Pricing Rules Quantity Max
- Bulk Pricing Rules Type
- Bulk Pricing Rules Amount
- Images Image File
- Images Is Thumbnail?
- Images Sort order
- Images Description
- Images Image URL
- Images ID
- Images Product ID
- Images URL Zoom
- Images URL Standard
- Images URL thumbnail
- Images URL Tiny
- Images Date modified
- Videos Title
- Videos Description
- Videos Sort order
- Videos Type
- Videos Video ID
- Videos ID
- Videos Product ID
- Videos Length
- Variants Cost Price
- Variants Price
- Variants Sale Price
- Variants Retail Price
- Variants Weight
- Variants Width
- Variants Height
- Variants Depth
- Variants Is free shipping?
- Variants Fixed cost shipping price
- Variants Purchasing disabled
- Variants Purchasing disabled message
- Variants UPC
- Variants Inventory level
- Variants Inventory warning level
- Variants BIN Picking number
- Variants Product ID
- Variants SKU
Action
Write
- Email
- Company
- ID
- Customer Group
Action
Search
- Name
- SKU
- ID
Action
Search
- Name
- Company
- Customer ID
- First_name
  Required
- Last_name
  Required
- Address1
  Required
- Address2
- City
  Required
- State_or_province
  Required
- Postal_code
  Required
- Country_code
  Required
- Phone
- Address_type
- Customer_id
  Required
- Id
- Country
- Name
- Value
Action
Search or write
- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search

- Filter by Channel ID
Trigger
Instant
Try It
Customer Address Created
Triggers when a new customer is created.
Trigger
Instant
Try It
- Filter by Category ID
Trigger
Instant
Try It
Customer Updated
Triggers when a customer is updated.
Trigger
Instant
Try It
- Filter by Channel ID
- Filter by Status ID
Trigger
Instant
Try It
- Title
  Required
- Url
- Body
  Required
- Is_published
- Meta_description
- Meta_keywords
- Author
- Thumbnail_path
- Tags
- Published_date
Action
Write
- First_name
  Required
- Last_name
  Required
- Company
- Address1
  Required
- Address2
- City
  Required
- State_or_province
  Required
- Postal_code
  Required
- Country_code
  Required
- Phone
- Address_type
- Customer_id
  Required
- Id
- Country
- Name
- Value
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Name
- Company
- Customer ID
Action
Search
- Email
  Required
- Company
- ID
- Customer Group
- First Name
  Required
- Last Name
  Required
- Phone
- Registration IP Address
- Notes
- Tax Exempt Category
- Customer Group ID
- Force Password Reset
- New Password
- Accepts Product Review Abandoned Cart Emails
- Store Credit Amounts
- Origin Channel ID
- Channel IDs
- Name
- Value
Action
Search or write
- Name
  Required
- SKU
- ID
- Type
  Required
- Description
- Weight
  Required
- Width
- Depth
- Height
- Price
  Required
- Cost_price
- Retail_price
- Sale_price
- Map_price
- Tax_class_id
- Product_tax_code
- Categories
- Brand_id
- Inventory_level
- Inventory_warning_level
- Inventory_tracking
- Fixed_cost_shipping_price
- Is_free_shipping
- Is_visible
- Is_featured
- Related_products
- Warranty
- Bin_picking_number
- Layout_file
- Upc
- Search_keywords
- Availability_description
- Availability
- Gift_wrapping_options_type
- Gift_wrapping_options_list
- Sort_order
- Condition
- Is_condition_shown
- Order_quantity_minimum
- Order_quantity_maximum
- Page_title
- Meta_keywords
- Meta_description
- View_count
- Preorder_release_date
- Preorder_message
- Is_preorder_only
- Is_price_hidden
- Price_hidden_label
- Url
- Is_customized
- Open_graph_type
- Open_graph_title
- Open_graph_description
- Open_graph_use_meta_description
- Open_graph_use_product_name
- Open_graph_use_image
- Gtin
- Mpn
- Reviews_rating_sum
- Reviews_count
- Total_sold
- Custom Fields ID
- Custom Fields Name
  Required
- Custom Fields Value
  Required
- Bulk Pricing Rules ID
- Bulk Pricing Rules Quantity Min
- Bulk Pricing Rules Quantity Max
- Bulk Pricing Rules Type
- Bulk Pricing Rules Amount
- Images Image File
- Images Is Thumbnail?
- Images Sort order
- Images Description
- Images Image URL
- Images ID
- Images Product ID
- Images URL Zoom
- Images URL Standard
- Images URL thumbnail
- Images URL Tiny
- Images Date modified
- Videos Title
- Videos Description
- Videos Sort order
- Videos Type
- Videos Video ID
- Videos ID
- Videos Product ID
- Videos Length
- Variants Cost Price
- Variants Price
- Variants Sale Price
- Variants Retail Price
- Variants Weight
- Variants Width
- Variants Height
- Variants Depth
- Variants Is free shipping?
- Variants Fixed cost shipping price
- Variants Purchasing disabled
- Variants Purchasing disabled message
- Variants UPC
- Variants Inventory level
- Variants Inventory warning level
- Variants BIN Picking number
- Variants Product ID
- Variants SKU
Action
Search or write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It
- Project
  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
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search or write

About BigCommerce

BigCommerce is an e-commerce platform that provides an all-encompassing solution for a business' online store. If you're trying to sell physical goods online, you'll want to check out Bigcommerce.

HelpHelp

Related categories

eCommerce

Premium

Similar apps

Shopify

eCommerce

Magento

eCommerce

WooCommerce

eCommerce, WordPress

About Google BigQuery

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

Learn moreLearn moreHelpHelp

Related categories

Databases

Google

Premium