BaseLinker + Google BigQuery
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 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 Order
Triggers when a new order is confirmed.
- automatically do this!Create Row
Creates a new row of data in a table. Note: Does not create a job.
- Free forever for core features
- 14 day trial for premium features & apps
New Invoice
Triggers when a new invoice is created.
Try ItOrder statusRequired
Try ItOrder statusRequired
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 nameRequired
product sku
product ean
product attributes
single item gross priceRequired
VAT rate
Quantity of piecesRequired
single item weight
order idRequired
courier codeRequired
package numberRequired
pickup dateRequired
New Order
Triggers when a new order is confirmed.
Try Itorder idRequired
series id
order idRequired
payment doneRequired
payment date
payment comment
Order IDRequired