Integrate Shopify with Smartsheet to automate your work

Start with Google for free

1. Choose a Trigger

An event that starts an automation

2. Choose an Action

The event an automation performs after it's triggered

Endless possibilities

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

How Zapier works

Zapier makes it easy to integrate Shopify with Smartsheet - no code necessary. See how you can get setup in minutes.

Select a trigger from Shopify

A trigger is an event that starts your Zap and runs the workflow. For example, with Shopify, a trigger could be "New Blog."

A trigger is the event that kicks off your automated workflow.

Setup an action from Smartsheet

An action is what takes place after the automation is triggered. For example, with Smartsheet, the action could be "Create Workspace."

An action is the event that your automated workflow performs when triggered.

That’s it! You just connected Shopify to Smartsheet

With Zapier, it’s never been easier to connect your apps together and automate your most tedious work. Save hours every month.

Triggers and actions are the main components of every automated workflow.

Set up your first integration

Quickly connect Shopify to Smartsheet with a Zapier template.

Our most popular template

Add new paid Shopify orders to Smartsheet spreadsheets
Premium
Details
Try it
Shopify + Smartsheet
Add new rows to Smartsheet for each updated order in Shopify
Premium
Details
Try it
Shopify + Smartsheet
Add new Shopify customers to Smartsheet by creating new rows on your sheet
Premium
Details
Try it
Shopify + Smartsheet
Add new Shopify products to Smartsheet by creating rows for efficient tracking
Premium
Details
Try it
Shopify + Smartsheet
Add new Shopify orders to Smartsheet as rows
Premium
Details
Try it
Shopify + Smartsheet

Add new paid Shopify orders to Smartsheet spreadsheets

Premium

Shopify + Smartsheet

Add new rows to Smartsheet for each updated order in Shopify

Premium

Shopify + Smartsheet

Add new Shopify customers to Smartsheet by creating new rows on your sheet

Premium

Shopify + Smartsheet

Add new Shopify products to Smartsheet by creating rows for efficient tracking

Premium

Shopify + Smartsheet

Add new Shopify orders to Smartsheet as rows

Premium

Shopify + Smartsheet

Make work flow with AI

Level up your Shopify to Smartsheet integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.

Illustration of AI enhancing Zapier workflows with automation and app integrations.

Connect Shopify and Smartsheet to integrate crucial parts of your business

With Zapier, you can integrate everything from basic data entry to end-to-end processes. Here are some of the business-critical workflows that people automate with Zapier.

Automate your lead management and improve conversions

With Zapier, you can automate every part of your lead funnel and give yourself the best chance at converting leads. Automate everything from lead capture to outreach to reporting—and close more deals as a result.

An illustration representing how to automate lead management with Zapier.

Connect Shopify and Smartsheet to unlock the power of automation

With Zapier's 7,000 integrations, you can unify your tools within a connected system to improve your team's efficiency and deepen their impact.

Choose a Trigger

Start here

Start here

Choose an Action

Supported triggers and actions

Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.

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
- Risk Level
Trigger
Scheduled
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
Updated Order
Triggers when an order is updated (with line item support).
Trigger
Instant
Try It
- Order ID
  Required
- Type of Line Item to Add
  Required
- Reason for Edit
- Notify the Customer?
Action
Write
- Blog
  Required
- Title
  Required
- Author Name
  Required
- Content
  Required
- Featured Image URL
- Excerpt/Summary
- Tags
  Required
- Is Published?
Action
Write
- First Name
- Last Name
- Email Address
  Required
- Customer Phone
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Address Phone
- Tags
  Required
- Note
- Accepts Marketing
- Tax Exempt
- Send E-Mail Invite
Action
Write
- Order ID
  Required
- Fulfillment Order ID
  Required
- Notify Customer
- Address Line 1
- Street Address Line 2
- City
- Country Code
- State/Province Code
- Zip Code
- Tracking Company
- Tracking Number
- Tracking URL
Action
Write
- Email Address
  Required
- Product
  Required
- Product Variant
- SKU (Stock Keeping Unit)
- Product Quantity
- Title
  Required
- Price
- Weight in Grams
- Price
- Rate
- Title
- Note
- Discount - Type
- Discount - Amount
- Discount - Code
- Additional Details
- Tags
  Required
- Buyer Accepts Marketing?
- 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 - Country Code
- Shipping Address - State/Province/Region
- Shipping Address - State/Province/Region Code
- 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 - Country Code
- Billing Address - State/Province/Region
- Billing Address - State/Province/Region Code
- Billing Address - Postal/Zip code
- Send_receipt
- Send_fulfillment_receipt
- Location
  Required
- Inventory_behaviour
- Financial_status
- Fulfillment Status
- Code
- Title
- Price
- Discounted Price
- Source
Action
Write
- Product
  Required
- Channel ID
  Required
- Publish Date
Action
Write
- Order ID
  Required
- Amount
- Currency
- Type
- Parent Transaction
- Warning
- Gateway
Action
Write
- Order ID
  Required
- Email Address
  Required
- Note
- Address Phone
- Buyer Accepts Marketing?
- Remove Customer from Order?
- Tags
  Required
- Additional Details
- Shipping Address - Address
- Shipping Address - Address con't
- Shipping Address - City
- Shipping Address - Company
- Shipping Address - Country
- Shipping Address - First name
- Shipping Address - Last name
- Shipping Address - Latitude
- Shipping Address - Longitude
- Shipping Address - Name
- Shipping Address - Phone
- Shipping Address - State/Province/Region
- Shipping Address - State/Province/Region Code
- Shipping Address - Postal/Zip code
Action
Write
- Product
  Required
- Title
  Required
- Product_type
  Required
- Vendor
  Required
- Payment Status
- Product Description
- Tags
  Required
- Category
- Collections to Join
- Collections to Leave
- Handle
- Redirect Handle?
- Alt Text
- Media Content Type
- Original Source
Action
Write
- Name
- Email Address
  Required
Action
Search
- Order ID
  Required
Action
Search
- Order ID
  Required
Action
Search
- Product Titles
  Required
Action
Search
- Product Titles
  Required
Action
Search
- Product
  Required
- Title
  Required
- Exact Match
  Required
Action
Search
- Title
  Required
- Product_type
  Required
- Vendor
  Required
- Content
  Required
- Tags
  Required
- Published At
- Price
- Inventory Policy
- Image URL
- More Image URLs
- SKU (Stock Keeping Unit)
- Is Published?
- Publish to Point of Sale
Action
Search or write
- Choose a Sheet
  Required
Trigger
Scheduled
Try It
- Choose a Sheet
  Required
Trigger
Scheduled
Try It
- Name
Action
Write
- Choose a Sheet
  Required
- Row
  Required
- Title
  Required
- Comment
  Required
Action
Write
- Source Folder
  Required
- Destination Folder
  Required
- New Folder Name
  Required
Action
Write
- Workspace
  Required
- New Folder Name
  Required
- What to Include?
- Skip Remap
Action
Write
- Destination
  Required
- Choose a Sheet
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row
  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)
  Required
- Access Level
  Required
- 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

- Blog
  Required
- Blog Entry Status
Trigger
Scheduled
Try It
Customer Account Enabled
Triggers when a customer account is enabled.
Trigger
Instant
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
- Inventory Item
Trigger
Instant
Try It
Updated Product
Triggers when a Product is updated, ordered or when a variant is added, removed, or updated.
Trigger
Instant
Try It
- Customer
  Required
- Tags
  Required
- Overwrite existing tags?
Action
Write
- Product ID
  Required
- Add New Image - File
- Add New Image - Alt Text
- Choose Existing Image
- Price
- Compare-at Price
- Charge Tax On This Variant?
- Cost Per Item
- SKU (Stock Keeping Unit)
- Barcode (ISBN, UPC, GTIN, etc.)
- Track Quantity?
- Continue Selling When Out of Stock?
- This Is a Physical Product
- Weight
- Weight Unit
- Country/Region of Origin
- Harmonized System (HS) code
- Position
- Requires Components
- Tax Code
Action
Write
- Email Address
  Required
- Product
  Required
- Product Variant
- Product Quantity
- Title
  Required
- Price
- Weight in Grams
- Note
- Discount - Type
- Discount - Amount
- Discount - Code
- Additional Details
- Tags
  Required
- 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
Action
Write
- Location
  Required
- Product
  Required
- Product Variant
  Required
- Adjust Quantity By
- Set Quantity To
Action
Write
- Title
  Required
- Product_type
  Required
- Vendor
  Required
- Payment Status
- Product Description
- Tags
  Required
- Collection ID
- Handle
- Note
- First Product Option
- Values for First Product Option
- Second Product Option
- Values for Second Product Option
- Third Product Option
- Values for Third Product Option
- Category
- Alt Text
- Media Content Type
- Original Source
Action
Write
- Customer
  Required
- Tags
  Required
Action
Write
- Customer
  Required
- First Name
- Last Name
- Email Address
  Required
- Company Name
- Default Address
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Tags
  Required
- Address Phone
- Note
- Tax Exempt
- Accepts Marketing
Action
Write
- Product
  Required
- Product Variant
- Title
  Required
- Price
- Compare at Price
- SKU (Stock Keeping Unit)
Action
Write
- HTTP Method
  Required
- URL
  Required
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Query - Name
- Query - Confirmation Number
- Query - Email
- Query - Customer ID
- Query - Location ID
- Query - SKU
- Query - Order ID
- Sort Key
- Reverse?
- Raw Query
Action
Search
- Owner_resource
  Required
- Owner_id
  Required
Action
Search
- Ids
  Required
Action
Search
- Title
  Required
Action
Search
- SKU (Stock Keeping Unit)
Action
Search
- Name
- Email Address
  Required
- First Name
- Last Name
- Customer Phone
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Address Phone
- Tags
  Required
- Note
- Accepts Marketing
- Tax Exempt
- Send E-Mail Invite
Action
Search or write
- Product
  Required
- Title
  Required
- Exact Match
  Required
- Price
- Compare at Price
- SKU (Stock Keeping Unit)
- Inventory Policy
Action
Search or write
- Choose a Sheet
  Required
Trigger
Scheduled
Try It
- Choose a Sheet
  Required
Trigger
Scheduled
Try It
- Choose a Sheet
  Required
- Row
  Required
- File Attachment
  Required
Action
Write
- Choose a Sheet
  Required
- Add Row to Top or Bottom
Action
Write
- Choose a Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Choose a 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)
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
- Api_docs_info
- HTTP Method
  Required
- URL
  Required
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write

Learn how to automate Shopify on the Zapier blog

Automate Smartsheet: get inspired on the Zapier blog

About Shopify

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

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.

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

Connect Shopify to Smartsheet on the world's largest no-code automation platform

Sign up with Google

Explore Shopify + Smartsheet Integrations

Explore Shopify + Smartsheet Integrations

manychat

keap-max-classic

google-sheets