BaseLinker + Google BigQuery

BaseLinker + Google BigQuery integrations

Create rows in Google BigQuery for new orders in BaseLinker

When a new order comes in on BaseLinker, use this automation to capture the information seamlessly in Google BigQuery. This streamlines the data entry process, making it easy to track and analyze your sales performance in a robust and simplified manner. Let this convenient workflow save you time and enhance efficiency in your business operations.

When this happens...
New OrderTriggers when a new order is confirmed.
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 BaseLinker and Google BigQuery

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

New Invoice
Triggers when a new invoice is created.
Trigger
Instant
Try It
- Order status
  Required
Trigger
Instant
Try It
- Order status
  Required
- Creation date (in unix time format)
- Currency symbol
- Payment method
- Cash on delivery
- Order is already paid?
- Buyer comments
- Seller comments
- Buyer e-mail address
- Buyer phone number
- Delivery method name
- Gross delivery price
- Delivery address - name and surname
- Delivery address - company
- Delivery address - street and number
- Delivery address - postcode
- Delivery address - city
- Delivery address - state
- Delivery address - country code (two-letter, e.g. EN)
- Pick-up point delivery - pick-up point identifier
- Pick-up point delivery - pick-up point name
- Pick-up point delivery - pick-up point address
- Pick-up point delivery - pick-up point postcode
- Pick-up point delivery - pick-up point city
- Billing details - name and surname
- Billing details - company
- Billing details - Vat Reg. no./tax number
- Billing details - street and house number
- Billing details - postcode
- Billing details - city
- Billing details - state
- Billing details - country code (two-letter, e.g. EN)
- Wants an invoice
- additional field 1
- additional field 2
- storage
- storage id
- product id
- variant id
- product name
  Required
- product sku
- product ean
- product attributes
- single item gross price
  Required
- VAT rate
- Quantity of pieces
  Required
- single item weight
Action
Write
- order id
  Required
- courier code
  Required
- package number
  Required
- pickup date
  Required
Action
Write
- order ID
  Required
Action
Write

- Order ID
  Required
- Status ID
  Required
Action
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

New Order
Triggers when a new order is confirmed.
Trigger
Instant
Try It
- order id
  Required
- series id
Action
Write
- order id
  Required
- payment done
  Required
- payment date
- payment comment
Action
Write
- Order ID
  Required
Action
Write
- Order ID
  Required
- admin comments
- user comments
- payment method
- payment method COD
- email
- phone
- user login
- delivery method
- delivery price
- delivery fullname
- delivery company
- delivery address
- delivery postcode
- delivery city
- delivery state
- delivery country code
- delivery point id
- delivery point name
- delivery point address
- delivery point postcode
- delivery point city
- invoice fullname
- invoice company
- invoice nip
- invoice address
- invoice postcode
- invoice city
- invoice state
- invoice country code
- want invoice
- extra field 1
- extra field 2
Action
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

About BaseLinker

BaseLinker is a cloud-based system integrating 1000+ marketplaces, stores, carriers, accounting and many more. Handle orders 10x faster!

Learn moreLearn moreHelpHelp

Related categories

eCommerce

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