BigCommerce + Smartsheet

Update rows in Smartsheet whenever order status updates in BigCommerce

Efficiently manage your BigCommerce orders with this seamless workflow. When an order status is updated in BigCommerce, it immediately adds a row to Smartsheet, ensuring that all your data is up-to-date and organized for easy accessibility. This streamlines your order management process, enabling you to optimize operations and save valuable time.

When this happens...
Order Status Updated
Triggers when an order status have changed.
TriggerInstant
automatically do this!
Add Row to Sheet
Add a row to a sheet.
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

- 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
Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a SheetRequired
Trigger
Polling
Try It
- Select a ReportRequired
Trigger
Polling
Try It
- Workspace NameRequired
Action
Write
- Choose a SheetRequired
- RowRequired
- TitleRequired
- CommentRequired
Action
Write
- Source FolderRequired
- Destination FolderRequired
- New Folder NameRequired
Action
Write
- WorkspaceRequired
- New NameRequired
- What to Include?
- Skip Remap
Action
Write
- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- DestinationRequired
- TemplateRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- Choose RowRequired
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a SheetRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet IDRequired
- Row IDRequired
Action
Search

- 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
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- 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
- Choose a SheetRequired
Trigger
Polling
Try It
- Choose a SheetRequired
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- SheetRequired
- RowRequired
- File AttachmentRequired
Action
Write
- Choose a SheetRequired
- Add Row to Top or Bottom
Action
Write
- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- SheetRequired
- ColumnRequired
- Parent Row
Action
Write
- DestinationRequired
- Sheet to CopyRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write
- Choose a SheetRequired
- Row IDRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- FormatRequired
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a WorkspaceRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
Action
Write
- Sheet IDRequired
- QueryRequired
Action
Search

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.

Related categories

eCommerce

Similar apps

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

Related categories

Spreadsheets

Similar apps

Related Zap Templates

Add new rows to Smartsheet for each newly created order in BigCommerce

Related Zap Templates

Add new rows to Smartsheet for each newly created order in BigCommerce

BigCommerce + Smartsheet

Update rows in Smartsheet whenever order status updates in BigCommerce

Abandoned Cart

Customer Created

Order Created

Shipment Created

Customer Address Updated

Order Status Updated

Create Customer

Create a Product

Search Customer

Search Product

Find or Create Customer's Address

Get Reports

New Comment

New or Updated Report Row

Create Workspace

Add Discussion to Row

Copy Folder

Copy Workspace

Move Row

Create Sheet From Template

Send Row

Share Sheet

API Request (Beta)

Find Attachment

Cart Created

Customer Address Created

Product Created

Customer Updated

Order Updated

Create Blog Post

Create Customer Address

API Request (Beta)

Search Customer Address

Find or Create Customer

Find or Create Product

New Attachment

New Row

Updated Row

Add Attachment to Row

Add Row to Sheet

Copy Row

Export Column

Create Sheet From Existing Sheet

Update Row

Send Sheet

Share Workspace

Find sheet Row (Legacy)

Find Sheet Row

About BigCommerce

Related categories

Similar apps

Shopify

Magento

WooCommerce

About Smartsheet

Related categories

Similar apps

MySQL

Zoho Creator

Knack

Related Zap Templates

Related Zap Templates