BigCommerce + Google Sheets

Add new Bigcommerce orders to Google Sheets as rows

Looking for a way to archive all your orders that doesn't take more of your precious time? Give this Bigcommerce Google Sheets integration a shot: Zapier will watch for new Bigcommerce orders and add a new row to your Google Sheet for each one it detects. Simply set it up and from then on you'll have an automated record-keeping system working for you 24/7!

When this happens...
Order Created
Triggers when a new order is created.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

What does this mean?

- 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
- 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
Action
Write

- 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
Action
Write
- Email
- Company
- ID
- Customer Group
Action
Search
- Name
- SKU
- ID
Action
Search
- Name
- 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
Action
Search or write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write

- 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
- TitleRequired
- Url
- BodyRequired
- Is Published
- Meta Description
- Meta Keywords
- Author
- Thumbnail Path
- Tags
- Published Date
Action
Write
- 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
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Name
- Company
- Customer ID
Action
Search
- EmailRequired
- 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
Action
Search or write
- NameRequired
- 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
Action
Search or write
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
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.

Help

Related categories

eCommerce

Similar apps

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more Help

BigCommerce + Google Sheets

Add new Bigcommerce orders to Google Sheets as rows

Abandoned Cart

Filter by Channel ID

Customer Created

Order Created

Filter by Channel ID

Filter by Status ID

Shipment Created

Customer Address Updated

Order Status Updated

Create Customer

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

Create a Product

Sku

Description

Width

Depth

Height

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