Connect Google Sheets and Shopify to automate any workflow
![Google Sheets](https://zapier-images.imgix.net/storage/services/8913a06feb7556d01285c052e4ad59d0.png?auto=format&ixlib=react-9.8.1&q=50&fit=crop&h=30&w=30)
![Google Sheets](https://zapier-images.imgix.net/storage/services/8913a06feb7556d01285c052e4ad59d0.png?auto=format&ixlib=react-9.8.1&q=50&fit=crop&h=60&w=60)
![Shopify](https://zapier-images.imgix.net/storage/services/4da9d3e3f93cd522f85e1b0695341f89.png?auto=format&ixlib=react-9.8.1&q=50&fit=crop&h=30&w=30)
![Shopify](https://zapier-images.imgix.net/storage/services/4da9d3e3f93cd522f85e1b0695341f89.png?auto=format&ixlib=react-9.8.1&q=50&fit=crop&h=60&w=60)
Top companies trust Zapier to automate work that solves their unique business problems—no coding required.
Create your first workflow
Quickly connect Google Sheets to Shopify with a Zapier template.
Our most popular template
How Zapier works
Zapier makes it easy to integrate Google Sheets with Shopify - no code necessary. See how you can get setup in minutes.
A trigger is where automation begins
![A trigger is the event that kicks off your automated workflow.](https://res.cloudinary.com/zapier-media/image/upload/q_auto,f_auto/v1703713159/App%20Directory/2S%20Page/First_content_row_mqocjq.png)
Now it's time for action
![An action is the event that your automated workflow performs when triggered.](https://res.cloudinary.com/zapier-media/image/upload/q_auto,f_auto/v1703713241/App%20Directory/2S%20Page/Second_content_row_majysk.png)
And that's it! You've just created a Zap.
![Triggers and actions are the main components of every automated workflow.](https://res.cloudinary.com/zapier-media/image/upload/q_auto,f_auto/v1703713241/App%20Directory/2S%20Page/Third_content_row_nghpr1.png)
Connect Google Sheets and Shopify 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
![An illustration representing how to automate lead management with Zapier.](https://res.cloudinary.com/zapier-media/image/upload/q_auto,f_auto/v1703713466/App%20Directory/2S%20Page/First_option_apbx4e.png)
Connect Google Sheets and Shopify 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.
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.
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column_nameRequired
- Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- TitleRequired
- Spreadsheet to Copy
- Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Api_docs_info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Headers
- Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- BlogRequired
- Blog Entry Status
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan- Customer Account Enabled
Triggers when a customer account is enabled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly. - New Cancelled Order
Triggers whenever an order is cancelled (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly. - New Fulfilled Order
Triggers when an order is fulfilled (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly. - New Paid Order
Triggers when an order is paid (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly. - New Refund
Triggers when a refund or partial refund occurs.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly. - Updated Customer
Triggers when a customer's information is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly. - Updated Product
Triggers when a Product is updated, ordered or when a variant is added, removed, or updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly. - CustomerRequired
- TagsRequired
- Overwrite existing tags?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Product IDRequired
- 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Email AddressRequired
- ProductRequired
- Product Variant
- Product Quantity
- TitleRequired
- Price
- Weight in Grams
- Note
- Discount - Type
- Discount - Amount
- Discount - Code
- Additional Details
- TagsRequired
- 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Email AddressRequired
- ProductRequired
- Product Variant
- SKU (Stock Keeping Unit)
- Product Quantity
- TitleRequired
- Price
- Weight in Grams
- Price
- Rate
- Title
- Note
- Discount - Type
- Discount - Amount
- Discount - Code
- Additional Details
- TagsRequired
- 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
- LocationRequired
- Inventory_behaviour
- Financial_status
- Fulfillment Status
- Code
- Title
- Price
- Discounted Price
- Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- CustomerRequired
- TagsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Order IDRequired
- Email AddressRequired
- Note
- Phone
- Buyer Accepts Marketing?
- Remove Customer from Order?
- TagsRequired
- 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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ProductRequired
- Product Variant
- TitleRequired
- Price
- Compare at Price
- SKU (Stock Keeping Unit)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Get specific order by ID
Get details of an order using Order ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app. - Name
- Email AddressRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Order IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Order IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- ProductRequired
- TitleRequired
- Exact MatchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- TitleRequired
- Product_typeRequired
- VendorRequired
- ContentRequired
- TagsRequired
- Published At
- Price
- Inventory Policy
- Image URL
- More Image URLs
- SKU (Stock Keeping Unit)
- Is Published?
- Publish to Point of Sale
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- ProductRequired
- TitleRequired
- Exact MatchRequired
- Price
- Compare at Price
- SKU (Stock Keeping Unit)
- Inventory Policy
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Copy_to
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
- Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row Count
- First Row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- New Blog
Triggers when a new blog is added to your Shopify store.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - New Customer
Triggers when a new customer is added to your Shopify account.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - Abandoned Cart Age (Hours)Required
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan- New Draft Order
Triggers when a new draft order is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly. - New Order
Triggers when an order is created (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly. - New Product
Triggers when a product is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly. - New Tag Added to Customer
Triggers when a new tag is added to a customer.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan - Updated Order
Triggers when an order is updated (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly. - Order IDRequired
- Type of Line Item to AddRequired
- Reason for Edit
- Notify the Customer?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- BlogRequired
- TitleRequired
- Author NameRequired
- ContentRequired
- Featured Image URL
- Excerpt/Summary
- TagsRequired
- Is Published?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- First NameRequired
- Last NameRequired
- Email AddressRequired
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Phone
- TagsRequired
- Note
- Accepts Marketing
- Tax Exempt
- Send E-Mail Invite
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- LocationRequired
- ProductRequired
- Product VariantRequired
- Adjust Quantity By
- Set Quantity To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- TitleRequired
- Product_typeRequired
- VendorRequired
- ContentRequired
- TagsRequired
- Published At
- Price
- Inventory Policy
- Image URL
- More Image URLs
- SKU (Stock Keeping Unit)
- Is Published?
- Publish to Point of Sale
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- CustomerRequired
- First NameRequired
- Last NameRequired
- Email AddressRequired
- TagsRequired
- Phone
- Note
- Tax Exempt
- Accepts Marketing
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ProductRequired
- TitleRequired
- Product_typeRequired
- VendorRequired
- ContentRequired
- TagsRequired
- Price
- More Image URLs
- SKU (Stock Keeping Unit)
- Inventory Policy
- Is Published?
- Publish to Point of Sale
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Headers
- Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Delete Product by Product ID
This action will delete a specific product in your Shopify store using the product's ID.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app. - Query - Name
- Query - Confirmation Number
- Query - Email
- Query - Customer ID
- Query - Location ID
- Query - SKU
- Query - Order ID
- Sort Key
- Reverse?
- Raw Query
ActionThis is an event a Zap performs.SearchFind existing data in your app- Owner_resourceRequired
- Owner_idRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- IdsRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- SKU (Stock Keeping Unit)
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
- Email AddressRequired
- First NameRequired
- Last NameRequired
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Phone
- TagsRequired
- Note
- Accepts Marketing
- Tax Exempt
- Send E-Mail Invite
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found- TitleRequired
- Product_typeRequired
- VendorRequired
- ContentRequired
- TagsRequired
- Published At
- Price
- Inventory Policy
- Image URL
- More Image URLs
- SKU (Stock Keeping Unit)
- Is Published?
- Publish to Point of Sale
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Learn how to automate Google Sheets on the Zapier blog.
Automate Shopify: get inspired on the Zapier blog
Join millions worldwide who automate their work using Zapier
Other Google Sheets + Shopify Integrations
- activecampaign
- airtable
- trello
- schedule
- looping
- salesforce
- google-contacts
- clickfunnels
- asana
- xero
- sms
- klaviyo
- keap-max-classic
- stripe
- hubspot
- flodesk
- facebook-offline-conversions
- facebook-custom-audiences
- manychat
- typeform
- twilio
- sendinblue
- quickbooks
- pipedrive
- kajabi
- google-calendar
- getresponse
- thinkific
- tactful-ucx
- square
- shipstation
- onfleet
- keap
- google-forms
- zendesk
- zapier-chrome-extension
- wordsmith
- webflow
- thrivecart
- storage
- sql-server
- patreon
- mysql
- leadpages
- leadconnector
- gravity-forms
- google-drive
- google-docs
- google-chat
- facebook-lead-ads
- copper
- zoom
- zoho-sign
- zoho-mail
- zoho-desk
- zoho-crm
- youtube
- woocommerce
- wodify
- wave
- untappd
- trustpilot
- touchsms
- tookan
- surveymonkey
- superphone
- squarespace
- sparkpost
- smtp
- smsadvertio
- smartsheet
- shippo
- recharge
- reamaze
- pushover
- proof-factor
- powr-form-builder
- postalytics
- popupsmart
- paypal
- ontraport
- neoncrm
- mondaycom
- monday
- moloni
- microsoft-teams
- microsoft-outlook
- messenger-platinum-mobile-wallet
- mdstools
- mailjet
- magento
- lob
- kartra
- kafkai
- judgeme
- jotform
- intercom
- help-scout
- handwrytten
- google-tasks
- google-analytics
- freshdesk
- facebook-pages
- facebook-lead-ads-beta
- facebook-conversions
- email-parser
- ecwid
- dropbox
- drip
- docusign
- docparser
- detrack
- delighted
- dear-inventory
- clickup
- clearbit
- bombbombcom
- bitly
- bigmarker
- bigcommerce
- beaconstac
- autopilot
- apify
- alegra
- 90-day-sales
Other Google Sheets + Shopify Integrations
- xero
- keap-max-classic
- flodesk
- manychat
- sendinblue
- kajabi
- thinkific
- shipstation
- google-forms
- wordsmith
- storage
- mysql
- gravity-forms
- google-chat
- zoom
- zoho-desk
- woocommerce
- untappd
- tookan
- squarespace
- smsadvertio
- recharge
- proof-factor
- popupsmart
- neoncrm
- moloni
- messenger-platinum-mobile-wallet
- magento
- kafkai
- intercom
- google-tasks
- facebook-pages
- email-parser
- drip
- detrack
- clickup
- bitly
- beaconstac
- alegra
- sms
- stripe
- facebook-offline-conversions
- typeform
- quickbooks
- google-calendar
- tactful-ucx
- onfleet
- zendesk
- webflow
- sql-server
- leadpages
- google-drive
- facebook-lead-ads
- zoho-sign
- zoho-crm
- wodify
- trustpilot
- surveymonkey
- sparkpost
- smartsheet
- reamaze
- powr-form-builder
- paypal
- mondaycom
- microsoft-teams
- mdstools
- lob
- judgeme
- help-scout
- google-analytics
- facebook-lead-ads-beta
- ecwid
- docusign
- delighted
- clearbit
- bigmarker
- autopilot
- 90-day-sales
- klaviyo
- hubspot
- facebook-custom-audiences
- twilio
- pipedrive
- getresponse
- square
- keap
- zapier-chrome-extension
- thrivecart
- patreon
- leadconnector
- google-docs
- copper
- zoho-mail
- youtube
- wave
- touchsms
- superphone
- smtp
- shippo
- pushover
- postalytics
- ontraport
- monday
- microsoft-outlook
- mailjet
- kartra
- jotform
- handwrytten
- freshdesk
- facebook-conversions
- dropbox
- docparser
- dear-inventory
- bombbombcom
- bigcommerce
- apify