Google Sheets + Shopify
Track new Shopify orders by creating spreadsheets in Google Sheets
Streamline your order management process with this Shopify to Google Sheets workflow. Once set up, each time there's a new order in your Shopify store, it will create a spreadsheet row in Google Sheets. This helps you keep track of your orders seamlessly, saving you time and improving your productivity.
Streamline your order management process with this Shopify to Google Sheets workflow. Once set up, each time there's a new order in your Shopify store, it will create a spreadsheet row in Google Sheets. This helps you keep track of your orders seamlessly, saving you time and improving your productivity.
- When this happens...
New OrderTriggers when a new purchase is made (only open orders) (with line item support).
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create SpreadsheetCreate a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
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 planNew 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 planAbandoned Cart Age (Hours)Required
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew 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 Refund
Triggers when a refund or partial refund occurs.
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 planUpdated Order
Triggers when an order is updated (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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
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
Product Description
Tags
Published At
Price
Inventory Policy
Image URL
More Image URLs
SKU
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 Name
Last Name
Email Address
Tags
Phone Number
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
Product VariantRequired
Title
Price
Compare at Price
SKU
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.Product TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appName
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProduct 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo 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
Additional Request 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 appDrive
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 appDrive
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
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 Product
Triggers when a new product is added to your Shopify store.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Customer
Triggers when a customer's information is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.BlogRequired
TitleRequired
Author NameRequired
ContentRequired
Featured Image URL
Excerpt/Summary
Tags
Is Published?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Product
Product Variant
Product Quantity
Product Title
Product Price
Weight in Grams
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
TitleRequired
Price
Compare at Price
SKU
Inventory Policy
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
Title
Product Type
Vendor
Product Description
Tags
Price
Images
SKU
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.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appProductRequired
Product Variant TitleRequired
Exact MatchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProductRequired
TitleRequired
Exact MatchRequired
Price
Compare at Price
SKU
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 foundNo 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 planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
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 appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsAbout Shopify
Shopify is a simple way to create an online store to list products, collect credit card payments, and ship your goods.
Related categories
Related Zap Templates
- Add new paid Shopify orders to Google Sheets rows
- Add new Shopify paid orders to Google Sheets rows
- Add newly-abandoned carts in Shopify to Google Sheets rows
- Update products in Shopify from new updates in Google Sheet rows
- Add products to Shopify from new Google Sheets rows
- Create Google Sheet rows for new abandoned carts in Shopify
- Create Google Sheets rows for new customers in Shopify
- Create Google Sheets rows for new orders in Shopify
- Add new Shopify orders to Google Sheets row(s)
- Create Google Sheets spreadsheet rows from new Shopify orders
- Create Shopify orders from new or updated Google Sheets rows
- Log new cancelled orders in Shopify to create multiple spreadsheet rows in Google Sheets
- Update inventory quantities in Shopify when new or updated spreadsheet rows occur in Google Sheets
- Create Google Sheet rows for new updated orders in Shopify
- Create Google Sheet rows for new orders of any status in Shopify
- Add new paid Shopify orders as Google Sheets rows
- Create multiple Google Sheets rows for new Shopify orders with any status
- Create Google Sheets spreadsheet rows for new cancellations in Shopify
- Create multiple Google Sheets rows for new Shopify products
- Create Shopify customers from new Google Sheets rows
- Add new Shopify products to Google Sheets as rows
- Create new Shopify products from new or updated rows in Google Sheets team drive
- Turn new Google Sheets rows into product descriptions with Wordsmith and add products to Shopify
- Add newly-abandoned Shopify carts to Google Sheets rows
- Create Google Sheets rows for new paid orders in Shopify
- Add new Shopify orders (any status) to Google Sheets row(s)
- Create multiple Google Sheets rows for each new Shopify order.
- Create Google Sheets Rows for New Shopify Orders
- Create multiple rows in Google Sheets for updated Shopify orders
- Create Chime leads from new Fello Connect contacts
- Create Shopify blog entries from new Google Sheets rows
- Create Shopify customers from new spreadsheet rows in Google Sheets team drive
- Create Shopify customers from new or updated Google Sheets rows
- Add new Shopify blog entries to Google Sheets as rows
- Create Shopify products from new or updated Google Sheets rows
- Create Shopify blog entries from new or updated Google Sheets rows
- Create Shopify products with descriptions from TextCortex AI from new Google Sheets rows
- Create Shopify orders from new or updated Google Sheets team drive rows
- Track new paid Shopify orders by updating spreadsheet rows in Google Sheets
- Update Shopify inventory quantities based on new Google Sheets rows
- Track new abandoned Shopify carts by creating multiple rows in Google Sheets
- Update Google Sheets rows with updated Shopify orders
- Create product descriptions with Jasper and add to Shopify
- Generate product descriptions with Writer and add them to Shopify
- Copy new Shopify products to Google Sheets worksheets
- Create worksheets in Google Sheets for every new order from Shopify
- Create orders in Shopify from new rows on Google Sheets team drive
- Create new Shopify products from new Google Sheets rows in team drive
- Create spreadsheets in Google Sheets when customer accounts are enabled in Shopify
- Update Google Sheets rows when Shopify orders are updated
- Create spreadsheet rows in Google Sheets for updated customers in Shopify
- Create new Shopify customers from new or updated rows in your Google Sheets team drive spreadsheet
- Update spreadsheet rows in Google Sheets with new paid orders from Shopify
- Add new Shopify customers to Google Sheets as multiple rows
- Update Google Sheets rows for new Shopify orders of any status
- Create Google Sheets spreadsheets for new Shopify customers
- Create spreadsheets in Google Sheets for new paid orders in Shopify
- Create spreadsheet rows in Google Sheets for new draft orders in Shopify
- Create multiple rows in Google Sheets for every new draft order in Shopify
- Process new Shopify orders with custom actions in Google Sheets
- Update Shopify product variants when new or updated rows are detected in Google Sheets
- Create Google Sheets spreadsheets for every new product in Shopify
- Create spreadsheets in Google Sheets for new abandoned carts in Shopify
- Track new cancelled Shopify orders by creating a spreadsheet in Google Sheets
- Update Shopify customers based on new or updated rows in Google Sheets
- Update spreadsheet rows in Google Sheets with new draft orders from Shopify
- Create spreadsheet columns in Google Sheets for new orders in Shopify
- Create spreadsheet rows in Google Sheets for every new enabled customer account in Shopify
- Create spreadsheet rows in Google Sheets for new enabled accounts in Shopify
- Create spreadsheet rows in Google Sheets for new orders in Shopify
- Add new Shopify products to Google Sheets as rows automatically
- Create multiple spreadsheet rows in Google Sheets for new orders in Shopify
- Create multiple rows in Google Sheets for new abandoned carts in Shopify
- Create Shopify blog entries from new Google Sheets rows
- Create new Shopify orders from new or updated rows in Google Sheets
- Create new Shopify customers from new or updated rows in Google Sheets
- Create spreadsheet rows in Google Sheets for every updated order in Shopify
- Create spreadsheet columns in Google Sheets for new paid orders in Shopify
- Create spreadsheets in Google Sheets from new Shopify orders
- Create new Google Sheets columns for each new Shopify product
- Create spreadsheet rows in Google Sheets for new draft orders from Shopify
Related Zap Templates
- Add new paid Shopify orders to Google Sheets rows
- Update products in Shopify from new updates in Google Sheet rows
- Create Google Sheets rows for new customers in Shopify
- Create Google Sheets spreadsheet rows from new Shopify orders
- Update inventory quantities in Shopify when new or updated spreadsheet rows occur in Google Sheets
- Add new paid Shopify orders as Google Sheets rows
- Create multiple Google Sheets rows for new Shopify products
- Create new Shopify products from new or updated rows in Google Sheets team drive
- Create Google Sheets rows for new paid orders in Shopify
- Create Google Sheets Rows for New Shopify Orders
- Create Shopify blog entries from new Google Sheets rows
- Add new Shopify blog entries to Google Sheets as rows
- Create Shopify products with descriptions from TextCortex AI from new Google Sheets rows
- Update Shopify inventory quantities based on new Google Sheets rows
- Create product descriptions with Jasper and add to Shopify
- Create worksheets in Google Sheets for every new order from Shopify
- Create spreadsheets in Google Sheets when customer accounts are enabled in Shopify
- Create new Shopify customers from new or updated rows in your Google Sheets team drive spreadsheet
- Update Google Sheets rows for new Shopify orders of any status
- Create spreadsheet rows in Google Sheets for new draft orders in Shopify
- Update Shopify product variants when new or updated rows are detected in Google Sheets
- Track new cancelled Shopify orders by creating a spreadsheet in Google Sheets
- Create spreadsheet columns in Google Sheets for new orders in Shopify
- Create spreadsheet rows in Google Sheets for new orders in Shopify
- Create multiple rows in Google Sheets for new abandoned carts in Shopify
- Create new Shopify customers from new or updated rows in Google Sheets
- Create spreadsheets in Google Sheets from new Shopify orders
- Add new Shopify paid orders to Google Sheets rows
- Add products to Shopify from new Google Sheets rows
- Create Google Sheets rows for new orders in Shopify
- Create Shopify orders from new or updated Google Sheets rows
- Create Google Sheet rows for new updated orders in Shopify
- Create multiple Google Sheets rows for new Shopify orders with any status
- Create Shopify customers from new Google Sheets rows
- Turn new Google Sheets rows into product descriptions with Wordsmith and add products to Shopify
- Add new Shopify orders (any status) to Google Sheets row(s)
- Create multiple rows in Google Sheets for updated Shopify orders
- Create Shopify customers from new spreadsheet rows in Google Sheets team drive
- Create Shopify products from new or updated Google Sheets rows
- Create Shopify orders from new or updated Google Sheets team drive rows
- Track new abandoned Shopify carts by creating multiple rows in Google Sheets
- Generate product descriptions with Writer and add them to Shopify
- Create orders in Shopify from new rows on Google Sheets team drive
- Update Google Sheets rows when Shopify orders are updated
- Update spreadsheet rows in Google Sheets with new paid orders from Shopify
- Create Google Sheets spreadsheets for new Shopify customers
- Create multiple rows in Google Sheets for every new draft order in Shopify
- Create Google Sheets spreadsheets for every new product in Shopify
- Update Shopify customers based on new or updated rows in Google Sheets
- Create spreadsheet rows in Google Sheets for every new enabled customer account in Shopify
- Add new Shopify products to Google Sheets as rows automatically
- Create Shopify blog entries from new Google Sheets rows
- Create spreadsheet rows in Google Sheets for every updated order in Shopify
- Create new Google Sheets columns for each new Shopify product
- Add newly-abandoned carts in Shopify to Google Sheets rows
- Create Google Sheet rows for new abandoned carts in Shopify
- Add new Shopify orders to Google Sheets row(s)
- Log new cancelled orders in Shopify to create multiple spreadsheet rows in Google Sheets
- Create Google Sheet rows for new orders of any status in Shopify
- Create Google Sheets spreadsheet rows for new cancellations in Shopify
- Add new Shopify products to Google Sheets as rows
- Add newly-abandoned Shopify carts to Google Sheets rows
- Create multiple Google Sheets rows for each new Shopify order.
- Create Chime leads from new Fello Connect contacts
- Create Shopify customers from new or updated Google Sheets rows
- Create Shopify blog entries from new or updated Google Sheets rows
- Track new paid Shopify orders by updating spreadsheet rows in Google Sheets
- Update Google Sheets rows with updated Shopify orders
- Copy new Shopify products to Google Sheets worksheets
- Create new Shopify products from new Google Sheets rows in team drive
- Create spreadsheet rows in Google Sheets for updated customers in Shopify
- Add new Shopify customers to Google Sheets as multiple rows
- Create spreadsheets in Google Sheets for new paid orders in Shopify
- Process new Shopify orders with custom actions in Google Sheets
- Create spreadsheets in Google Sheets for new abandoned carts in Shopify
- Update spreadsheet rows in Google Sheets with new draft orders from Shopify
- Create spreadsheet rows in Google Sheets for new enabled accounts in Shopify
- Create multiple spreadsheet rows in Google Sheets for new orders in Shopify
- Create new Shopify orders from new or updated rows in Google Sheets
- Create spreadsheet columns in Google Sheets for new paid orders in Shopify
- Create spreadsheet rows in Google Sheets for new draft orders from Shopify