Ecwid by Lightspeed + Google BigQuery

Ecwid by Lightspeed + Google BigQuery integrations

Create Google BigQuery rows from new paid orders on Ecwid

Want to make your ecommerce and your web analytics platforms talk to each other? Use this integration. When active, it detects new paid orders on Ecwid and adds the info as new rows on Google BigQuery. You'll be all set to start making use of data to grow your business.

When this happens...
New Paid OrderTriggered when a new paid order is placed (with line item support).
TriggerPolling
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 Ecwid by Lightspeed and Google BigQuery

Discover other triggers and actions you can use with Ecwid by Lightspeed and Google BigQuery

New Abandoned Cart
Triggered when a customer leaves an online store without making a purchase.
Trigger
Polling
Try It
- Payment Status
- Fulfillment Status
Trigger
Polling
Try It
- Payment Status
- Fulfillment Status
Trigger
Polling
Try It
- Payment Status
- Fulfillment Status
Trigger
Polling
Try It
- Coupon Name
  Required
- Coupon Code
  Required
- Discount
- Discount Type
- Status
- Launch Date
- Expiration Date
- Total Limit
- Uses Limit
- applicationLimit
- Order Count
- repeatCustomerOnly
- catalogLimitProducts
- catalogLimitCategories
Action
Write

- Title
  Required
- Price
  Required
- SKU Number
- Description
- Quantity
- Weight
- Enabled
- Unlimited
- Compare To Price
- Is Shipping Required
- Warning Limit
Action
Write
- Product ID
  Required
- Link on your image
  Required
Action
Write

- Keywords
- Order Number
- Vendor Order Number
- Email
- Customer ID
- Payment Status
- Fulfillment Status
- Accept Marketing
- Referer ID
- Product ID
- Coupon Code
- Total From
- Total To
- Created From
- Created To
- Updated From
- Updated To
- Payment Method
- Shipping Method
Action
Search
- Keyword
- Customer's Name
- Customer's Email
  Required
- Group ID
- Minimum number of order a customer placed
- Maximum number of order a customer placed
- Accept Marketing
- Created From
- Created To
- Updated From
- Updated To
- Customer's Password
- Customer group ID
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

- Customer Email
- Agreed to receive email marketing
Trigger
Polling
Try It
New Paid Order
Triggered when a new paid order is placed (with line item support).
Trigger
Polling
Try It
New Product
Triggers when a new product is created.
Trigger
Polling
Try It
- Customer's Email
  Required
- Customer's Password
- Customer group ID
- Customer's Name
Action
Write
- Email
  Required
- Payment Status
  Required
- Fulfilment Status
  Required
- Product Name
  Required
- Product Price
  Required
- Product Quantity
  Required
- Product SKU
- Product Weight
- Payment Method
- Total
- Tax
- Order Comments
- Shipping Rate
- Shipping Person Name
- Shipping Method Name
- Shipping Person Company Name
- Shipping Person Street
- Shipping Person City
- Shipping Person Country Code
- Shipping Person Postal Code
- Shipping Person State Code
- Shipping Person Phone
- Billing Person Name
- Billing Person Company Name
- Billing Person Street
- Billing Person City
- Billing Person Country Code
- Billing Person Postal Code
- Billing Person State Code
- Billing Person Phone
- Subtotal
- Payment Module
- customerTaxExempt
- customerTaxId
- customerTaxIdValid
- reversedTaxApplied
- IP Address
- Coupon Discount
- Referer Url
- Volume Discount
- Customer ID
- Hidden
- Membership Based Discount
- Total And Membership Based Discount
- Discount
- Global Referer
- Create Date
- Customer Group
- Tracking Number
- Payment Message
- External Transaction ID
- Affiliate ID
- Private Admin Notes
- Pickup Time
- Accept Marketing
- Disable All Customer Notifications
- External Fulfillment
- External Order ID
Action
Write
- Product ID
  Required
- SKU
- Name
- Quantity
- Unlimited
- Price
- Compare To Price
- Weight
- Enabled
- Description
Action
Write
- Keyword
- Name
- Email
- Group ID
- Minimum number of order a customer placed
- Maximum number of order a customer placed
- Accept Marketing
- Created From
- Created To
- Updated From
- Updated To
Action
Search
- Keyword
- SKU
- Product ID
- Enabled
Action
Search
- Keyword
- SKU Number
- Product ID
- Enabled
- Title
  Required
- Price
  Required
- Description
- Quantity
- Weight
- Unlimited
- Compare To Price
- Is Shipping Required
- Warning Limit
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 Ecwid by Lightspeed

Ecwid by Lightspeed is a cloud online store builder which lets you instantly launch an online store on any website, Facebook page, or multiple sites simultaneously.

Learn moreLearn moreHelpHelp

Related categories

eCommerce

Similar apps

Shopify

eCommerce

Gumroad

eCommerce

SendOwl

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