ConditionalVisibility

new-products-promo

integrate-google-sheets-with-shopify-01

integrate-google-sheets-with-shopify-02

integrate-google-sheets-with-shopify-03

integrate-google-sheets-with-shopify-04

integrate-google-sheets-with-shopify-05

integrate-google-sheets-with-shopify-06

integrate-google-sheets-with-shopify-07

integrate-google-sheets-with-shopify-08

integrate-google-sheets-with-shopify-09

integrate-google-sheets-with-shopify-10

integrate-google-sheets-with-shopify-11

integrate-google-sheets-with-shopify-12

integrate-google-sheets-with-shopify-13

Zapier tutorials

integrate-google-sheets-with-shopify-00-hero

Shopify

Google Sheets

Using Shopify and Google Sheets to manage your eCommerce store is critical for your business workflows, but they work even better together. Here are the most popular ways to connect them with Zapier. 

How to integrate Google Sheets with Shopify

Keep your new Shopify paid orders organized using  this automation. After your customer submits a new paid order on Shopify, Zapier will automatically add it to your Google Sheets spreadsheet as a new row. That way, you can manage your orders in a spreadsheet and easilyi keep everything organized.

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

Triggers when a new blog is added to your Shopify store.

New Blog

Triggers when a new entry is added to a blog in your Shopify store.

New Blog Entry

Triggers when a new customer is added to your Shopify account.

New Customer

Triggers when a customer account is enabled.

Customer Account Enabled

Triggers when an Order Risk Level is medium, high or both.

New Fraudulent Order

Triggers whenever a cart is "abandoned" (only open carts) (with line item support).

New Abandoned Cart

Triggers whenever a order is "cancelled" (with line item support).

New Cancelled Order

Triggers whenever an order is cancelled (with line item support).

Triggers when a new draft order is created

New Draft Order

Triggers whenever a new purchase is "paid". You can choose a different order status like pending or refunded (with line item support).

New Paid Order

Triggers when an order is fulfilled (with line item support).

New Fulfilled Order

Triggers when a new purchase is made (only open orders) (with line item support).

New Order

Triggers when an order is created (with line item support).

Triggers when an order is paid (with line item support).

New Product

Triggers when a refund or partial refund occurs.

New Refund

Triggers when a new purchase is made (of any order status).

New Order (Any Status)

Triggers when a new product is added to your Shopify store.

Triggers when a new tag is added to a customer.

New Tag Added to Customer

Triggers when a customer's information is updated.

Updated Customer

Triggers when an Inventory Item quantity is updated.

Updated Inventory

Triggers when an order is updated (with line item support).

Updated Order

Triggers when a Product is updated, ordered or when a variant is added, removed, or updated.

Updated Product

Triggers when a tag has either been added or removed from an order.

Updated Tag in Order

Find Customer

Find Order

Gets all fulfillment orders for a given order ID.

Get Fulfillment Orders by Order ID

Get Order by ID

Searches for Metafields data for a given resource (example order Metafields).

Find Metafields

Finds the Transactions associated to an Order.

Find Order Transactions

Finds multiple Products by IDs. Returned as line items.

Find Products by ID (With Line Item Support)

Finds a list of products by searching the titles.

Find Products by Title (With Line Item Support)

Find Product by Title

Finds a product by handle. Titles can also be used if handles are not customized.

Find Product by Title or Handle

Finds a list of product variants by searching the titles.

Find Product Variants by Title (With Line Item Support)

Find Product Variant by SKU

Finds a product variant by a title search.

Find Product Variant by Title

Find or Create Customer

Finds or creates a specific product by title.

Find or Create Product

Finds or creates a specific product by title v2.

Finds or creates a specific product by title v3.

Finds or creates a specific product variant by title.

Find or Create Product Variant

Find or Create Product Variant V2

Add Line Item to Order

Add Tag to Customer

Create Blog Entry

Create Company

Create Product Variant

Create Customer

Creates a new draft order (with line item support).

Create Draft Order

Creates a fulfillment for one or many fulfillment orders that are associated with the same order and are assigned to the same location.

Create Fulfillment

Creates a new gift card in your Shopify store.

Create Gift Card

Updates the quantity of an existing product variant.

Update Inventory Quantity

Updates the quantity of existing product variants.

Update Inventory Quantity (with line item support).

Creates a new order (with line item support).

Create Order

Create Product

Publishes a product to a channel (e.g., a sales channel).

Publish Product

Removes one or more tags from a customer.

Remove Tag from Customer

Create Transaction

Updates an existing customer. Replaces only data that is set.

Update Customer

Update Order

Updates an existing product. Replaces only data that is set.

Update Product

Updates an existing product variant. Replaces only data that is set.

Update Product Variant

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new spreadsheet row at the top of a spreadsheet (after the header row).

Create Spreadsheet Row at Top

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

Update one or more rows in a specific spreadsheet (with line item support).

Update Spreadsheet Row(s)

Add new paid Shopify orders to Google Sheets rows

Send line items from your eCommerce tool over to your spreadsheet app, where you can sort and share your data. Use this integration to automatically save line items from new paid Shopify orders to Google Sheets as multiple rows--instead of squeezing all the line items into one spreadsheet row. With your data cleanly and clearly organized in Google Sheets, you can quickly get insights and analyze it.

Add new Shopify paid orders to Google Sheets rows

Easily keep track of shoppers who are abandoning carts with this integration. Once active, this Zap adds cart details from Shopify automatically to a row in a specified Google Sheets spreadsheet. Data in the spreadsheet can later be easily imported into a marketing tool to retarget with email, ads, or other tactics.

Add newly-abandoned carts in Shopify to Google Sheets rows

Effortlessly manage your Shopify orders using this seamless workflow between Google Sheets and Shopify. Whenever a new or updated row appears in your Google Sheets, this automation will swiftly create an order in Shopify, streamlining your inventory and sales process. Focus on growing your business while this integration takes care of your orders.

Create Shopify orders from new or updated Google Sheets rows

Effortlessly manage your customer database with this seamless workflow between Google Sheets and Shopify. Whenever a new row is added to your spreadsheet, a new customer will be created in your Shopify store. This easy-to-use automation saves you time and ensures your customer information stays consistently updated across both platforms.

How to integrate Google Sheets with Shopify

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.