BigCommerce + Google Sheets
Update Google Sheets rows with updated BigCommerce orders
Keep your data updated across your systems effortlessly. With this workflow, when there is an update in your BigCommerce orders, a new row will be instantly created in your Google Sheets spreadsheet. This allows for efficient sales tracking and ensures that your financial records are always current, streamlining your e-commerce management process.
Keep your data updated across your systems effortlessly. With this workflow, when there is an update in your BigCommerce orders, a new row will be instantly created in your Google Sheets spreadsheet. This allows for efficient sales tracking and ensures that your financial records are always current, streamlining your e-commerce management process.
- When this happens...
Order UpdatedTriggers when an order is updated.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Customer Created
Triggers when an new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter by Channel ID
Filter by Status ID
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Shipment Created
Triggers when a new shipment is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Address Updated
Triggers when a customer address is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Status Updated
Triggers when an order status have changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.EmailRequired
First NameRequired
Last NameRequired
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
TypeRequired
Sku
Description
WeightRequired
Width
Depth
Height
PriceRequired
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 NameRequired
Custom Fields ValueRequired
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Company
ID
Customer Group
ActionThis is an event a Zap performs.SearchFind existing data in your appName
SKU
ID
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Company
Customer ID
First NameRequired
Last NameRequired
Address 1Required
Address 2
CityRequired
State Or ProvinceRequired
Postal CodeRequired
Country CodeRequired
Phone
Address Type
Customer IdRequired
Id
Country
Name
Value
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Customer Address Created
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter by Category ID
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Updated
Triggers when a customer is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter by Channel ID
Filter by Status ID
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.TitleRequired
Url
BodyRequired
Is Published
Meta Description
Meta Keywords
Author
Thumbnail Path
Tags
Published Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
Company
Address 1Required
Address 2
CityRequired
State Or ProvinceRequired
Postal CodeRequired
Country CodeRequired
Phone
Address Type
Customer IdRequired
Id
Country
Name
Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Company
Customer ID
ActionThis is an event a Zap performs.SearchFind existing data in your appEmailRequired
Company
ID
Customer Group
First NameRequired
Last NameRequired
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
SKU
ID
TypeRequired
Description
WeightRequired
Width
Depth
Height
PriceRequired
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 NameRequired
Custom Fields ValueRequired
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About BigCommerce
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Add new Bigcommerce orders to Google Sheets as rows
- Add new Google Sheets rows to BigCommerce as customer addresses
- Add new BigCommerce customers to a Google Sheets spreadsheet as rows
- Create rows in Google Sheets for new BigCommerce products
- Add new BigCommerce orders to Google Sheets as multiple rows
- Track abandoned carts in BigCommerce by creating new rows in a Google Sheets spreadsheet
- Create new BigCommerce products from new Google Sheets rows
- Update Google Sheets rows with new order status from BigCommerce
- Update and manage custom actions in BigCommerce with new or updated rows in Google Sheets
- Update multiple Google Sheets rows when BigCommerce orders are updated
- Create new Google Sheets row for every new BigCommerce order created