Connect Shopify and AppSheet to unlock the power of automation

No credit card required
Free forever for core features
14-day trial for premium features and apps

Choose a Trigger

Choose an Action

Set up your first integration

Quickly connect Shopify to AppSheet with a Zapier template.

Our most popular template

Create records in AppSheet for new orders from Shopify
Premium
Details
Try it
Shopify + AppSheet
Create records in AppSheet for every new product in Shopify for effective product management
Premium
Details
Try it
Shopify + AppSheet
Update records in AppSheet when products are updated in Shopify
Premium
Details
Try it
Shopify + AppSheet
Enable new Shopify customer accounts and create corresponding records in AppSheet
Premium
Details
Try it
Shopify + AppSheet

Create records in AppSheet for new orders from Shopify

Details

Try it

Shopify + AppSheet

Create records in AppSheet for every new product in Shopify for effective product management

Details

Try it

Shopify + AppSheet

Update records in AppSheet when products are updated in Shopify

Details

Try it

Shopify + AppSheet

Enable new Shopify customer accounts and create corresponding records in AppSheet

Details

Try it

Shopify + AppSheet

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 AppSheet - no code necessary. See how you can get setup in minutes.

100%

Help

1. Choose trigger event

2. Choose action

1. Select the event

Setup

Test

App

Trigger event

Choose a trigger event

Choose a trigger

A trigger is the event that starts your Zap—like a "New Blog" from Shopify.

Add your action

An action happens after the trigger—such as "Create Record" in AppSheet.

You’re connected!

Zapier seamlessly connects Shopify and AppSheet, automating your workflow.

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
Polling
Try It
- Risk Level
Trigger
Polling
Try It
New Cancelled Order
Triggers whenever an order is cancelled (with line item support).
Trigger
Instant
Try It
New Customer
Triggers when a new customer is added to your Shopify account.
Trigger
Instant
Try It
Customer Account Enabled
Triggers when a customer account is enabled.
Trigger
Instant
Try It

New Order
Triggers when an order is created (with line item support).
Trigger
Instant
Try It
New Refund
Triggers when a refund or partial refund occurs.
Trigger
Instant
Try It

New Product
Triggers when a product is created.
Trigger
Instant
Try It
Updated Customer
Triggers when a customer's information is updated.
Trigger
Instant
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
- Company
  Required
- Location Name
  Required
- External ID
- Locale
- Phone
- Note
- Tax Registration ID
- Billing same as shipping address?
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping City
- Shipping Country Code
- Shipping First Name
- Shipping Last Name
- Shipping Phone
- Shipping Recipient
- Shipping ZIP Code
- Shipping Zone Code
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
- Country Code
- Zip Code
- Address Phone
- Tags
- Note
- Accepts Marketing
- Tax Exempt
- Tax Exemptions
- Send E-Mail Invite
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
Action
Write
- Initial Value
  Required
- Code
- Customer ID
- Expiry Date
- Note
- Template Suffix
Action
Write
- Email
- Product
- Product Variant
- SKU
- Product Quantity
- Product Title
- Product Price
- Weight in Grams
- Price
- Rate
- Title
- Note
- Discount - Type
- Discount - Amount
- Discount - Code
- Additional Details
- Tags
- 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
- Inventory_behaviour
- Financial_status
- Fulfillment Status
- Code
- Title
- Price
- Discounted Price
- Source
Action
Write
- Product ID
  Required
- Channel ID
  Required
- Publish Date
Action
Write
- Order
  Required
- Amount
- Currency
- Type
- Parent Transaction
- Warning
- Gateway
Action
Write
- Inventory Item
  Required
- Unit Cost
- Track Inventory
- SKU
- Requires Shipping
- Country of Origin
- Province/State of Origin
Action
Write
- Product
  Required
- Product Variant
  Required
- Price
- Compare at Price
- SKU
- Barcode
- Tax Code
- Is taxable?
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- 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
- Order ID
  Required
Action
Search
- Order_id
  Required
Action
Search
- Ids
  Required
Action
Search
- Product Variant Titles
  Required
Action
Search
- Product
  Required
- Product Variant Title
  Required
Action
Search
- Copy
- Product Title / Handle
  Required
- Product_type
- Vendor
- Product Status
- Product Description
- Tags
- 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
Search or write
- Application
  Required
- Table
  Required
- Locale
- Location
- Timezone
Action
Write
- Application
  Required
- Table
  Required
- Locale
- Location
- Timezone
- Action
  Required
Action
Write
- Application
  Required
- Table
  Required
- Locale
- Location
- Timezone
Action
Search

- Blog
  Required
- Blog Entry Status
Trigger
Polling
Try It
- Abandoned Cart Age (Hours)
  Required
Trigger
Polling
Try It
New Company
Triggers when a new company is created.
Trigger
Instant
Try It
New Draft Order
Triggers when a new draft order is created.
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 (with order details).
Trigger
Instant
Try It
New Tag Added to Customer
Triggers when a new tag is added to a customer.
Trigger
Polling
Try It
Updated Draft Order
Triggers when a draft order 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
- Is Published?
Action
Write
- Name
  Required
- ExternalId
- A note about the company
- Company_contact
- Contact Email
- Contact First Name
- Contact Last Name
- Contact Phone
- Contact Title
- Contact_locale
- Location
- Billing same as shipping address?
- Company_shippingAddress
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address Country Code
- Shipping_firstName
- Shipping_lastName
- Shipping Address Phone
- Shipping Address Recipient
- Shipping Address Zip
- Shipping Address Zone Code
- Location External ID
- Location_locale
- Location_name
- Location_note
- Location_phone
- TaxRegistrationId
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
- Order ID
  Required
- Fulfillment Order ID
  Required
- Notify Customer
- Address Line 1
- Address Line 2
- City
- Country Code
- Province Code
- Zip Code
- Tracking Company
- Tracking Number
- Tracking URL
Action
Write
- Adjust or Set quantity?
  Required
- The name of quantities to be changed
  Required
- The reason for the quantity changes
  Required
- Location
  Required
- Product
- Product Variant
  Required
- Quantity to Set or Adjust
Action
Write
- Title
  Required
- Product_type
- Vendor
- Product Status
- Product Description
- Tags
- 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
- Company Name
- Default Address
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Tags
- Phone Number
- Note
- Tax Exempt
- Tax Exemptions
- Accepts Marketing
- Send Account Invite Email
Action
Write
- Order ID
  Required
- Email
- Notes
- Phone
- Buyer Accepts Marketing?
- Remove Customer from Order?
- Tags
- Additional Details
- Shipping Address - Line 1
- Shipping Address - Line 2
- 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 - Province
- Shipping Address - Province Code
- Shipping Address - ZIP
Action
Write
- Product ID
  Required
- Title
- Product_type
- Vendor
- Product Status
- Product Description
- Tags
- Category
- Collections to Join
- Collections to Leave
- Handle
- Redirect Handle?
- Alt Text
- Media Content Type
- Original Source
Action
Write
- Search Query
- Email
Action
Search
- Order ID
  Required
- Include Closed Fulfillment Orders
Action
Search
- Owner_resource
  Required
- Owner_id
  Required
Action
Search
- Product Titles
  Required
Action
Search
- Copy
- Product Title / Handle
  Required
Action
Search
- Product Variant SKU
  Required
Action
Search
- Search Query
- Email Address
  Required
- First Name
- Last Name
- Customer Phone
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Country Code
- Zip Code
- Address Phone
- Tags
- Note
- Accepts Marketing
- Tax Exempt
- Tax Exemptions
- Send E-Mail Invite
Action
Search or write
- Product ID
  Required
- Product Variant Title
  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
Search or write
- Application
  Required
- Table
  Required
- Locale
- Location
- Timezone
Action
Write
- Application
  Required
- Table
  Required
- Locale
- Location
- Timezone
Action
Write

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

G2 Badge - Most Implementable - Winter 2024

G2 Badge - Leader Mid-Market - Winter 2024

93%

Customers who say using Zapier has made them better at their job

25m

Customers have created over 25 million Zaps on the platform

6 mins

The average user takes less than 6 minutes to set up a Zap

Connect Shopify and AppSheet 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.

Create more impactful campaigns with automation

Measuring campaign performance across platforms can get chaotic. Plus, digging up the right metrics costs you precious time and effort. With Zapier, you can create a centralized view of your performance, skillfully manage your lists, and ensure your campaigns drive ROI across the business.

Provide world-class support with a little help from automation

Support reps can't be productive when they have to track down crucial information for every incident or ticket. With Zapier, you can automatically send your reps the context they need to resolve tickets quickly and create a seamless customer experience.

Automate your way to actionable, up-to-date data

The days of manually exporting and importing data are over. With Zapier, you can send data where it needs to go, in the format you need it—so you can centralize your data and unlock more insights.

Resolve incidents faster with automation

Your technical support team wants to focus on tech tickets rather than admin work. With Zapier, you can automate everything from ticket creation to routing to inter-team communication—eliminating friction from incident management and increasing speed to resolution.

Learn how to automate Shopify on the Zapier blog

Make work flow with AI

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

Learn about AI automation

Frequently Asked Questions about Shopify + AppSheet integrations

New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Shopify and AppSheet

How do I start integrating Shopify with AppSheet?

Begin by navigating to the AppSheet platform and creating a new app. In your app settings, you'll find an option to connect with external services like Shopify. You'll need your Shopify API key and shop domain to establish a connection.

What triggers are available for the Shopify-AppSheet integration?

With our integration, you can utilize triggers such as 'New Order Created', 'Product Updated', and 'Customer Added'. These triggers let us automate specific actions whenever these events occur in your Shopify store.

What actions can be performed in AppSheet upon a trigger from Shopify?

Once a trigger event from Shopify occurs, you can perform actions like updating data records, sending notifications, or triggering workflows within AppSheet. This ensures your app responds dynamically to changes in your store.

Is there support for handling inventory changes in this integration?

Yes, when a product inventory level changes in Shopify, our system can automatically update relevant data fields in your AppSheet application through the integration.

Can I customize what data is sent from Shopify to AppSheet?

Absolutely. We allow customization on data mapping between Shopify and AppSheet. You can select specific fields that are relevant for your operations, ensuring that only pertinent information is transferred.

How often does synchronization occur between Shopify and AppSheet?

The synchronization frequency depends on how you configure it within the setup. Generally, triggers ensure that updates happen almost instantaneously when certain conditions are met in your Shopify store.

Do I need technical expertise to set up the integration?

Not necessarily; we've designed the setup process to be user-friendly with straightforward guides. However, familiarity with API keys and basic data management may be helpful during configuration.

About Shopify

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

Learn moreLearn moreHelpHelp

Related categories

eCommerce

About AppSheet

AppSheet is a no-code app development platform that lets you build desktop & mobile apps for your business from spreadsheet data.

HelpHelp

Related categories

App Builder

Similar apps

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

Connect Shopify and AppSheet to unlock the power of automation

Set up your first integration

Create records in AppSheet for new orders from Shopify

Create records in AppSheet for every new product in Shopify for effective product management

Update records in AppSheet when products are updated in Shopify

Enable new Shopify customer accounts and create corresponding records in AppSheet

Create records in AppSheet for new orders from Shopify

Create records in AppSheet for every new product in Shopify for effective product management

Update records in AppSheet when products are updated in Shopify

Enable new Shopify customer accounts and create corresponding records in AppSheet

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

How Zapier works

Choose a trigger

Add your action

You’re connected!

Supported triggers and actions

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

Connect Shopify and AppSheet to integrate crucial parts of your business

Automate your lead management and improve conversions

Create more impactful campaigns with automation

Provide world-class support with a little help from automation

Automate your way to actionable, up-to-date data

Resolve incidents faster with automation

Learn how to automate Shopify on the Zapier blog

Automatically post new Shopify store items to Pinterest

How to automatically add Shopify customers to Salesforce

How to automatically save Shopify orders to a Google Sheet

Make work flow with AI

Frequently Asked Questions about Shopify + AppSheet integrations

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