BigCommerce + Smartsheet

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

Keep track of your BigCommerce orders in an organized way with this automation. Once activated, every time a new order is placed in BigCommerce, it will add a row to a designated Smartsheet. This streamlines your order management, ensuring no order details are missed, and makes it easy for you to maintain your business records efficiently.

When this happens...
Order CreatedTriggers when a new order is created.
TriggerInstant
automatically do this!
Add Row to SheetAdd a row to a sheet.
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 BigCommerce and Smartsheet

Discover other triggers and actions you can use with BigCommerce and Smartsheet

- 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
- Email
  Required
- First Name
  Required
- Last Name
  Required
- 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

- Name
  Required
- Type
  Required
- Sku
- Description
- Weight
  Required
- Width
- Depth
- Height
- Price
  Required
- 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 Name
  Required
- Custom Fields Value
  Required
- 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_name
  Required
- Last_name
  Required
- Address1
  Required
- Address2
- City
  Required
- State_or_province
  Required
- Postal_code
  Required
- Country_code
  Required
- Phone
- Address_type
- Customer_id
  Required
- Id
- Country
- Name
- Value
Action
Search or write
Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Select a Report
  Required
Trigger
Polling
Try It
- Workspace Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row
  Required
- Title
  Required
- Comment
  Required
Action
Write
- Source Workspace
- Source Folder
  Required
- Destination Workspace
- Destination Folder
  Required
- New Folder Name
  Required
Action
Write
- Workspace
  Required
- New Name
  Required
- What to Include?
- Skip Remap
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Destination
  Required
- Template
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Choose Row
  Required
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a Sheet
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet ID
  Required
- Row ID
  Required
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
- Title
  Required
- Url
- Body
  Required
- Is_published
- Meta_description
- Meta_keywords
- Author
- Thumbnail_path
- Tags
- Published_date
Action
Write
- First_name
  Required
- Last_name
  Required
- Company
- Address1
  Required
- Address2
- City
  Required
- State_or_province
  Required
- Postal_code
  Required
- Country_code
  Required
- Phone
- Address_type
- Customer_id
  Required
- Id
- Country
- Name
- Value
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Name
- Company
- Customer ID
Action
Search
- Email
  Required
- Company
- ID
- Customer Group
- First Name
  Required
- Last Name
  Required
- 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
- Name
  Required
- SKU
- ID
- Type
  Required
- Description
- Weight
  Required
- Width
- Depth
- Height
- Price
  Required
- 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 Name
  Required
- Custom Fields Value
  Required
- 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 Sheet
  Required
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- Sheet
  Required
- Row
  Required
- File Attachment
  Required
Action
Write
- Choose a Sheet
  Required
- Add Row to Top or Bottom
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Sheet
  Required
- Column
  Required
- Parent Row
Action
Write
- Destination
  Required
- Sheet to Copy
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row ID
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Format
  Required
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a Workspace
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- 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 ID
  Required
- Query
  Required
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.

HelpHelp

Related categories

eCommerce

Premium

Similar apps

Shopify

eCommerce

Magento

eCommerce

WooCommerce

eCommerce, WordPress

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.

HelpHelp

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

Related Zap Templates

Update rows in Smartsheet whenever order status updates in BigCommerce

Related Zap Templates

Update rows in Smartsheet whenever order status updates in BigCommerce