Shopify + Smartsheet

Add new rows to Smartsheet for each updated order in Shopify

Keep your sales data seamlessly updated with this efficient workflow. As soon as any order changes in your Shopify account, the details are instantaneously entered as a new row in your Smartsheet. This automation helps you to maintain real-time sales records, taking away the hassle of manual data entry, and granting you immediate insight into your business’s performance.

When this happens...
Updated Order
Triggers when an order is updated (with line item support).
TriggerScheduled
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

What does this mean?

New Blog
Triggers when a new blog is added to your Shopify store.
Trigger
Scheduled
Try It
New Customer
Triggers when a new customer is added to your Shopify account.
Trigger
Scheduled
Try It
- Abandoned Cart Age (Hours)Required
Trigger
Scheduled
Try It
New Draft Order
Triggers when a new draft order is created
Trigger
Instant
Try It
New Order
Triggers when an order is created (with line item support).
Trigger
Instant
Try It

New Product
Triggers when a product is created.
Trigger
Instant
Try It
New Tag Added to Customer
Triggers when a new tag is added to a customer.
Trigger
Scheduled
Try It

Updated Order
Triggers when an order is updated (with line item support).
Trigger
Instant
Try It
- First NameRequired
- Last NameRequired
- Email AddressRequired
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Phone
- Tags
- Note
- Accepts Marketing
- Tax Exempt
- Send E-Mail Invite
Action
Write
- LocationRequired
- ProductRequired
- Product VariantRequired
- Adjust Quantity By
- Set Quantity To
Action
Write
- TitleRequired
- Product TypeRequired
- VendorRequired
- Product Description
- Tags
- Published At
- Price
- Inventory Policy
- Image URL
- More Image URLs
- SKU
- Is Published?
- Publish to Point of Sale
Action
Write
- CustomerRequired
- First Name
- Last Name
- Email Address
- Tags
- Phone Number
- Note
- Tax Exempt
- Accepts Marketing
Action
Write
- ProductRequired
- Product VariantRequired
- Title
- Price
- Compare at Price
- SKU
Action
Write
Get specific order by ID
Get details of an order using Order ID
Action
Write
- Order IDRequired
Action
Search
- ProductRequired
- Product Variant TitleRequired
- Exact MatchRequired
Action
Search
- Product TitleRequired
- Product TypeRequired
- VendorRequired
- Product Description
- Tags
- Published At
- Price
- Inventory Policy
- Image URL
- More Image URLs
- SKU
- Is Published?
- Publish to Point of Sale
Action
Search or write
- ProductRequired
- TitleRequired
- Exact MatchRequired
- Price
- Compare at Price
- SKU
- Inventory Policy
Action
Search or write
- Choose a SheetRequired
Trigger
Scheduled
Try It
- Choose a SheetRequired
Trigger
Scheduled
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
- 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
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write

- BlogRequired
Trigger
Scheduled
Try It
Customer Account Enabled
Triggers when a customer account is enabled.
Trigger
Instant
Try It
New Cancelled Order
Triggers whenever an order is cancelled (with line item support).
Trigger
Instant
Try It
New Fulfilled Order
Triggers when an order is fulfilled (with line item support).
Trigger
Instant
Try It
New Paid Order
Triggers when an order is paid (with line item support).
Trigger
Instant
Try It
New Refund
Triggers when a refund or partial refund occurs.
Trigger
Instant
Try It
Updated Customer
Triggers when a customer's information is updated.
Trigger
Instant
Try It
- BlogRequired
- TitleRequired
- Author NameRequired
- ContentRequired
- Featured Image URL
- Excerpt/Summary
- Tags
- Is Published?
Action
Write
- Email
- Product
- Product Variant
- Product Quantity
- Product Title
- Product Price
- Weight in Grams
Action
Write
- Email
- Product
- Product Variant
- Product Quantity
- Product Title
- Product Price
- Weight in Grams
- Note
- Discount - Type
- Discount - Amount
- Discount - Code
- Additional Details
- Tags
- Shipping Address Instructions
- Shipping Address - First name
- Shipping Address - Last name
- Shipping Address - Company
- Shipping Address - Phone
- Shipping Address - Address
- Shipping Address - Address con't
- Shipping Address - City
- Shipping Address - Country
- Shipping Address - State/Province/Region
- Shipping Address - Postal/Zip code
- Billing Address Instructions
- Billing Address - First name
- Billing Address - Last name
- Billing Address - Company
- Billing Address - Phone
- Billing Address - Address
- Billing Address - Address con't
- Billing Address - City
- Billing Address - Country
- Billing Address - State/Province/Region
- Billing Address - Postal/Zip code
- Send Receipt
- Send Fulfillment Receipt
- Location
- Inventory Behavior
- Financial Status
- Fulfillment Status
- Code
- Title
- Price
- Discounted Price
- Source
Action
Write
- ProductRequired
- TitleRequired
- Price
- Compare at Price
- SKU
- Inventory Policy
Action
Write
- ProductRequired
- Title
- Product Type
- Vendor
- Product Description
- Tags
- Price
- Images
- SKU
- Is Published?
- Publish to Point of Sale
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Name
- Email
Action
Search
- Product TitleRequired
Action
Search
- Name
- Email AddressRequired
- First NameRequired
- Last NameRequired
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Phone
- Tags
- Note
- Accepts Marketing
- Tax Exempt
- Send E-Mail Invite
Action
Search or write
- Product TitleRequired
- Product TypeRequired
- VendorRequired
- Product Description
- Tags
- Published At
- Price
- Inventory Policy
- Image URL
- More Image URLs
- SKU
- Is Published?
- Publish to Point of Sale
Action
Search or write
- Choose a SheetRequired
Trigger
Scheduled
Try It
- Choose a SheetRequired
Trigger
Scheduled
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
- 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
Find a row in a specified sheet using a query.
Action
Write

About Shopify

Shopify is a simple way to create an online store to list products, collect credit card payments, and ship your goods.

Learn more Help

Related categories

eCommerce

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.

Help

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

PRODUCTS

CAPABILITIES

By team

Shopify + Smartsheet

Add new rows to Smartsheet for each updated order in Shopify

New Blog

New Customer

New Abandoned Cart

New Draft Order

New Order

New Product

New Tag Added to Customer

Updated Order

Create Customer

First NameRequired

Last NameRequired

Email AddressRequired

Company Name

Street Address

Street Address Line 2

City

State

State/Province Code

Country

Zip Code

Phone

Tags

Note

Accepts Marketing

Tax Exempt

Send E-Mail Invite

Update Inventory Quantity

LocationRequired

ProductRequired

Product VariantRequired

Adjust Quantity By

Set Quantity To

Create Product

TitleRequired

Product TypeRequired

VendorRequired

Product Description

Tags

Published At

Price

Inventory Policy

Image URL

More Image URLs

SKU

Is Published?

Publish to Point of Sale

Update Customer

CustomerRequired

First Name

Last Name

Email Address

Tags

Phone Number

Note

Tax Exempt

Accepts Marketing

Update Product Variant

ProductRequired

Product VariantRequired

Title

Price

Compare at Price

SKU

Get specific order by ID

Get Order by ID

Order IDRequired

Find Product Variant by Title

ProductRequired

Product Variant TitleRequired

Exact MatchRequired

Find or Create Product

Product TitleRequired

Product TypeRequired

VendorRequired

Product Description